Unanswered

Autogenerating a unique ID number

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I want to be able to create a unique ID number for any document added to my document library beginning at 1186

I have built a new flow to automate a document approval process within by business however I can't find a way to auto generate an ID number at a starting point of my choosing (in this case 1186)

I thought initially about using the ID number automatically generated by the library itself + 1185 to generate my number but I can’t seem to find a formula that will work.

Short of adding over 1000 documents to the library just to get the ID number to where I need it to be, I’m lost for solutions.

Is there anything flow can do to automate this process?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (5)

Report

Hi @Anonymous,

I have made a test on my side, you could refer to screenshot below to create the flow:

Th flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-yuazh-msft

This works perfectly, thank you so much

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @v-yuazh-msft ,

Your solution and screen shots were extremely helpful! I ran into an issue using th ID field though, I need it to count by 1. It needs to start at 6045 and then increase by one each submission (i.e, 6046, 6047, 6048). What can I repalce the ID with to make this happen?

Thanks!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

You could initialize a variable at the beginning of your Flow and set the initial value to 6045, and then increment that by 1 each time you process a submission?

Was this reply helpful? Yes No
GPronnya 74 on at

Like (0)

Report

How would you do the incrementation?

Is it possible to incrementation for a newly created Row in Excel?

Thanks in advance,

Was this reply helpful? Yes No
earlylearner 58 on at

Like (0)

Report

Is it possible to create something with letters and numbers?

This is when a new email is being saved on the sharepoint and for every email saved - a document number is created (but based on the subject) @v-yuazh-msft

for example like DOC1001, DOC1002?

Was this reply helpful? Yes No
ques0buffet 105 on at

Like (1)

Report

use the string concant expressions.

concant('doc', ID field)

Was this reply helpful? Yes No