Unanswered

Automated document numbering, not using ID from sharepoint list.

(2) Share

Report

Posted on by CU04030153-0

"I am building a flow to allocate a unique document number based on the data populated for a new item in a SharePoint list. The numbering convention includes letters followed by a unique three-digit sequential number.

Example: ABC-ABC-ABC-001

I have built the flow to generate the letter portion of the document number but cannot figure out how to add the sequential three-digit number at the end.

Additionally, the numbering should be sequential based on the letter string. For example, if AAA-BBB-REP-001 already exists in the SharePoint list, then the next number should be AAA-BBB-REP-002."

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

So its not hard to do what you want, and I will simply say except and its a big one.

There is no way to stop multiple people at the same time from doing that action that should update REP-001 to 002 and you end up with 2 002's instead of 002-003

My concern isn't showing you have to generate, but more than it can be duplicated.

Was this reply helpful? Yes No
Yang_Tao_202305 6 on at

Like (0)

Report
Copy link

Link copied!

My idea is that when creating a new Item, retrieve all the items in the List and check if there is an 'AAA-BBB-REP'. If not, assign the value '001'. If it exists, find the maximum value in the entire List and add 1. For example, if '001' already exists, the new item will be '002'. This way, you can automatically create the Seq No. you need.

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Try the below approach if you can utilize SharePoint ID column.

Create a new column of calculated type and add the below formula.

="AAA-BBB-REP-"&TEXT(ID,"000")

If you don't want to utilize and ID column go for a Power automate which gets triggered when ever any new item is created in the list and add a number column take max(columnvalue) + 1 in case of new item creation and in the above formula change the ID column with new column created.

Regards,

PG

Was this reply helpful? Yes No