Unanswered

Seeking Guidance on Implementing Sequential Reference Numbers flow in Power Automate

(0) Share

Report

Posted on by BenLakhoua

Dear All ,

I'm relatively new to SharePoint List and Power Automate, and I'm working on setting up a list to track purchase requests. I want to assign a unique reference to each purchase request, like DOP00001, DOP00002, and so on.

To achieve this, I'm planning to use Power Automate to increment a column in SharePoint. My goal is to ensure that the incrementing is seamless even if multiple users are working simultaneously, and there's no overlap in the assigned references.

I'd appreciate your insights or any suggestions

Thanks

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,532 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Instead of doing that just reuse the ID column in SharePoint to generate the Reference number. You can do that with a calculated column.

Was this reply helpful? Yes No
BenLakhoua 2 on at

Like (0)

Report
Copy link

Link copied!

Hello ,
when using the default ID, I get correct results for existing items but incorrect ones for new items

Thanks

Was this reply helpful? Yes No
Pstork1 69,532 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Could you explain more about "but incorrect ones for new items". IDs are guaranteed to be unique and sequential. If you mean that some IDs are missing because they were created and then deleted. That is a reality to the way it works. You have to decide which is worse, having some gaps in the numbers but being assured that they are sequential or potentially having duplicates because multiple people create records too close to each other.

Was this reply helpful? Yes No