Add custom prefix to unique ID

(0) Share

Report

Posted on by CarlHRVA

601

Hello,

I am trying to create a custom ID with a text prefix before it anytime a new item is created. I have a large list that we've been using in a 2013 environment with the last ID created being 176,420. Since I know that the 176,240 is the last ID created in our old environment, I'd like the flow to create a new unique ID( whenever a new item is submitted) in increments of one, starting with 176,241. The format of the ID would be as follows: "OTC-US-2020-176421". Any help is greatly appreciated and if any of this did not make sense please let me know and I will try to better clarify.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

DeepakS 2,301 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CarlHRVA

You can create an integer variable counter and initiate it with 176421.
following expression will help you creating unique ID:
concat('OTC-','US-','2020','-',variables('Counter'))

——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying, @DeepakS ! When you say "initiate it with 176241", do you mean set the default value of the Variable to that? Also, I'm a bit confused how this will add 1 to the ID each new item. Should I be using an increment variable like the below or does the formula do that already somehow?

Here is what my variable looks like:

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CarlHRVA

Yes, set the default value to 176241.
I think I misread your question, I thought you are looping through each item, but it seems you want on item add.
For this You may need to query your list and get the total items count and add that number to 176241.

——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like
a
(0)

Report
Copy link

Link copied!

@DeepakS I looked closer at my list and what I needed was really close to your answer! Since I brought the list over with ShareGate the ID's still match up with items . I just needed to add the ID onto the end of the formula you provided. Thank you so much for your help! The formula I'm using is:

concat('OTC-','US-','2020','-','triggerBody()?['ID']')

Was this reply helpful? Yes No