cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasNor
Regular Visitor

Incremental unique number generator from FORMS to EMAIL

Hello,

I am trying to build a flow that reads information stored in LISTS based on input from FORMS and sends resulting new rows to EMAIL.

We use the numbers to track items in our small organization so each number is "captured" by one person and needs to be unique.

We use different ranges (1m, 5m, 8m and 9m) to roughly differenciate type of item. 

 

I have the following setup:

 

FORMS with two inputs:

1) What type of number is required?

  1000000-series

  5000000-series

  8000000-series

  9000000-series

2) How many numbers do you require

  Type number between 1 ~ 100

 

LIST with two columns:

Column1 (ID-column): Unique number

Column2: Name of person holding number

 

To book a number and send it by email i imagine the following flow:

1) Get FORMS respons

2) Get LIST respons

3) Find highest number in column 1 for the range

4) Write x amount of new rows into list based on FORMS question 2 and responders ID

5) Email the same new rows to responders ID

 

But after searching and trying i am a little lost..

 

Lastly, will there be a chance that there might be a clash if two persons try to book numbers at the same time?

 

With best regards,

Thomas

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-duann-msft
Community Support
Community Support

Hi @ThomasNor 

 

Thank you for posting.

 

According to your description, you would like to get SPO list based on form response and then send result via email. If any misunderstood, please kindly let me know.

 

As per you required, I create form and list as below:

For form:

v-duann-msft_0-1614159167569.png

 

For list:

v-duann-msft_1-1614159167576.png

 

From my understanding, the unique number column in SharePoint list is a number rang from Q1 to Q1+Q2. For example, if I choose 500,0000 series and 5 in form. I should be able to create 5 rows in the list as: 500,0001;500,0002;500,0003;500,0004 and 500,0005.

 

If that’s the case, please refer my flow steps as below:

v-duann-msft_2-1614159167580.png

 

For detailed info:

Refer expression:

int(outputs('Get_response_details')?['body/r383b0e3a74b747ac8a1f95871263d201'])

v-duann-msft_3-1614159167583.png

Expression:

int(outputs('Get_response_details')?['body/r383b0e3a74b747ac8a1f95871263d201'])

add(int(first(split(outputs('Get_response_details')?['body/r670446d4231f459a9895d8e43932aaf8'],'-'))),variables('shuzi'))

v-duann-msft_4-1614159167586.png

 

Expression: add(int(first(split(outputs('Get_response_details')?['body/r670446d4231f459a9895d8e43932aaf8'],'-'))),int(outputs('Get_response_details')?['body/r383b0e3a74b747ac8a1f95871263d201']))

v-duann-msft_5-1614159167590.png

 

 

Expression:

v-duann-msft_6-1614159167592.png

 

Once I submit form, choosing 1000000-series and 5 as answer. I’m able to get SharePoint list and email as below:

v-duann-msft_7-1614159167594.png

 

SPO:

v-duann-msft_8-1614159167596.png

 

Email:

v-duann-msft_9-1614159167597.png

Hope the content above may help you.

 

Thanks

Anna

View solution in original post

3 REPLIES 3
v-duann-msft
Community Support
Community Support

Hi @ThomasNor 

 

Thank you for posting.

 

According to your description, you would like to get SPO list based on form response and then send result via email. If any misunderstood, please kindly let me know.

 

As per you required, I create form and list as below:

For form:

v-duann-msft_0-1614159167569.png

 

For list:

v-duann-msft_1-1614159167576.png

 

From my understanding, the unique number column in SharePoint list is a number rang from Q1 to Q1+Q2. For example, if I choose 500,0000 series and 5 in form. I should be able to create 5 rows in the list as: 500,0001;500,0002;500,0003;500,0004 and 500,0005.

 

If that’s the case, please refer my flow steps as below:

v-duann-msft_2-1614159167580.png

 

For detailed info:

Refer expression:

int(outputs('Get_response_details')?['body/r383b0e3a74b747ac8a1f95871263d201'])

v-duann-msft_3-1614159167583.png

Expression:

int(outputs('Get_response_details')?['body/r383b0e3a74b747ac8a1f95871263d201'])

add(int(first(split(outputs('Get_response_details')?['body/r670446d4231f459a9895d8e43932aaf8'],'-'))),variables('shuzi'))

v-duann-msft_4-1614159167586.png

 

Expression: add(int(first(split(outputs('Get_response_details')?['body/r670446d4231f459a9895d8e43932aaf8'],'-'))),int(outputs('Get_response_details')?['body/r383b0e3a74b747ac8a1f95871263d201']))

v-duann-msft_5-1614159167590.png

 

 

Expression:

v-duann-msft_6-1614159167592.png

 

Once I submit form, choosing 1000000-series and 5 as answer. I’m able to get SharePoint list and email as below:

v-duann-msft_7-1614159167594.png

 

SPO:

v-duann-msft_8-1614159167596.png

 

Email:

v-duann-msft_9-1614159167597.png

Hope the content above may help you.

 

Thanks

Anna

View solution in original post

ThomasNor
Regular Visitor

Hi @v-duann-msft,

 

Thank you so much for your thoughtfull reply.

 

I have one follow up question:

 

For the expression below, I assume the text in bold-italic is different from case to case, how will i find what to type in my case?

int(outputs('Get_response_details')?['body/r383b0e3a74b747ac8a1f95871263d201'])

 

I sorted out that original question, but ended up with a couple of new.

 

1) I might be wrong, but does the proposal take into acount numbers already in the list? When i teste on my end with two submissions of 5000000 series with 5 numbers each the list populated 5000001 to 5000005 two times instead of 5000001 to 5000010

 

2) The email that is composed sends the whole list, not only the numbers that are new. 

 

Is it the same on your end?

 

With best regards,

Thomas 

 

Hi @ThomasNor 

 

Thank you for your update.

 

For your queries, here are the related information:

1.Yes, it will generate duplicate numbers if two more persons select same series. For this point, I'm still testing since yesterday.

 

2.From my end, it only returns according numbers required by that submitter. Seems I missed show you 'get items' details as below:

v-duann-msft_0-1614243654023.png

If we set up filter here, you will only get the numbers just submitted.

 

Thanks

Anna

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (77,106)