cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielleruns
Advocate II
Advocate II

Creating a Unique ID with SharePoint ID value

What I'm looking to do is take a Prefix (we'll call it CCB) and then grab the ID of the item that was just created in SharePoint to build a unique ID. It would always be 9 characters long. In another workflow tool we were able to run an expression that would take the prefix and combine it with a PadLeft function that knew the overall length of the padding to add (in this case 6), the pad character (in this case 0) and the text to combine (SharePoint List ID) to output something that would look like CCB000333.

 

I'm racking my brain on how to achieve this in Flow. Any ideas? 

3 REPLIES 3
edgonzales
Super User II
Super User II

@danielleruns 

Hi there - This one sounds interesting, and I feel like there's a better way to do this, but I did find this creative solution.

 

It seems cumbersome but might get you going in the right direction.

 

-Ed-

 

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

CollabTechie
Responsive Resident
Responsive Resident

Hi @danielleruns , how about this approach?

concat('ABC', triggerBody()?['ID'])



cap2.PNGcap1.PNG

v-litu-msft
Community Support
Community Support

Hi @danielleruns,

 

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (55,848)