Create Unique ID for SharePoint List

[sgeibel]

I'm trying to create a request form for coworkers to use that when they submit a request, a Unique ID is given to that request.

We use the term "Marketing Project Request", so we would like the ID to be MPR and then followed by numbers like MPR0032, MPR0033, etc. I'm trying to use a flow with Power Automate to do so.

I'd like for the numbers to not be random, and if possible to start at a certain number. For example, we have already had 1165 requests from over the years using other forms, since we like to keep track of our previous requests. So I'd like the next request to be submitted start at MPR1166. As each request comes in... MPR1166, MPR1167, MPR1168, etc. Added a photo below of what I would like to see.

Thank you!

[David_MA]

The easiest thing to do would be to use the internal ID column of the SharePoint list as it is unique and cannot be repeated. However, you will need to do a few things to get the format you want:

1. You can use a concat expression to add the prefix.
2. You can use the formatNumber expression to pad it with zeroes if needed, but since you want it to begin from a certain number, I don't think that will be necessary.
3. So, to get it to begin at your desired number, just use an add expression to add 1166 (or whatever you end up with when you go live) to the ID to set the ID.