You’re offline. This is a read only version of the page.
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
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.
Hello ,
when using the default ID, I get correct results for existing items but incorrect ones for new items
Thanks
Instead of doing that just reuse the ID column in SharePoint to generate the Reference number. You can do that with a calculated column.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (