Answered

Create unique ID like 2019-001

(0) Share

Report

Posted on by Dricc

179

I had set this up a year ago with Sharepoint Designer and it still works: when I create a new item, a unique identification number is generated using the year + an incremental number from another list, as shown in my pictures here.

Now I want to do the same in another list that I have, but I don't use Sharepoint Designer any more and wonder if I can do the same with Ms Flow?

probably something like this but I don't fully understand it:

https://powerusers.microsoft.com/t5/Building-Flows/Autogenerating-a-unique-ID-number/m-p/142345#M14182

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Dricc ,

Do you want to update the item with format Year-Number?

Please try with action Increment variable to see if it will work for your scenario.

I have set up the flow likes below for your reference.

Function used in Compose action is:

length(body('Get_items')?['value'])

Best regards,

Mabel

Was this reply helpful? Yes No
Dricc 179 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, @v-yamao-msft .
Where do I tell the flow to take the year information?
Should I enter an ODATA query in Get items?

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Dricc ,

I am using a function to get the current Year info:

Utcnow(‘yyyy’)

Best regards,

Mabel

Was this reply helpful? Yes No
Dricc 179 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yamao-msft Thanks. And something else: can I put a condition like do it only when a field in a column (a choice column) contains certain text? how would the flow be?
Also, can I make the count start at a certain number, let's say 172 ?

Was this reply helpful? Yes No
Dricc 179 on at

Like (0)

Report
Copy link

Link copied!

Would this work, to put a condition?

I've been playing around with it in a trial list that I have. There, the count starts at 032. Who knows why. 2019-032, 2019-033, 2019-034...

Was this reply helpful? Yes No
Dricc 179 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yamao-msft do you have an idea?

Was this reply helpful? Yes No
Dricc 179 on at

Like (0)

Report
Copy link

Link copied!

@v-yamao-msft I got my condition working. Now my issue is that I would like that also the count skips the line items when the condition does not apply. You see in my screenshot below that the generated number passes from 2019-34 over to 2019-38:

Also, if anyone knows how to make the count start at a certain number, lets say 162, I would love to know. Many thanks.

Was this reply helpful? Yes No
Verified answer

Dricc 179 on at

Like (0)

Report
Copy link

Link copied!

Solution in this topic: https://powerusers.microsoft.com/t5/Building-Flows/Unique-ID-like-2019-01-with-condition-don-t-count-other-line/td-p/333516

Was this reply helpful? Yes No
Powerplatform01 386 on at

Like (0)

Report
Copy link

Link copied!

@Dricc
You can watch this video to resolve your issue.
Also request you to please subscribe this channel.
https://youtu.be/LSjDBxgIQZ8

Was this reply helpful? Yes No