web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Generate a unique numb...

Power Automate

Unanswered

Generate a unique number for document

(0) Share

Report

Report

Posted on by Pavel48n0sh

87

Hi!
I have a flow to generate a Word document and I want to generate a unique number to it. The number will be included in the title of the document and additionally write it in the "Unique number" column. The number must be 5 digits.

The file ID is not suitable in this case, because I want to be able to reset the unique number to 00000. Can you please tell me how to implement this approach?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

MarvinBangert 1,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Pavel48n0sh

you can the "rand()" expression:

rand(0,99999)

It returns a random integer from a specified range. Of course this could also return less than 5 digits, you can use the "formatNumber()" expression to fix this:

formatNumber(rand(0,99999),'D5')

"D" stands for digits, there are also some more like "C" for currency, "X" for hexadecimal etc. Another format would be using placeholders like:

formatNumber(rand(0,99999),'00000')

Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel

Was this reply helpful? Yes No

Join the conversation