Unanswered

Create Unique ID like YYYY-Iincrement in SharePoint list using Power Automate flow

(0) Share

Report

Posted on by nicolaslemerle

Hi,

I have a column 'date' on the list sharepoint and by the column i need extract the year and creat a column with date+increment ID, but the difficult i need reset ID every year

2022-50

2022-51

2023-1

2023-2

etc...

can you help me ?

thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @nicolaslemerle ,

Could you tell me, did you want Unique ID to be generated automatically when a new item created?

I made a sample for you:

Create a list that includes column 'Data' and column 'Id'. 'Data' is a date type column and 'Id' is a text type column.

Create a flow, and I will explain step by step.

When creating a new item, get all items in the list.

Filter the 'Date' column for items in the same year as the new item.

substring(item()?['Date'], 0, 4)

substring(triggerOutputs()?['body/Date'], 0, 4)

Gets the number of filtered items.

Length(body('Filter_array'))

Update the new item.

substring(triggerOutputs()?['body/Date'],0,4)

If the new item has items of the same year, the ID will increase.

If the new item does not have items of the same year, the ID is reset to 1.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

nicolaslemerle 22 on at

Like (0)

Report

Hi,
thank you for the quickly answer !
Yes i want the unique ID is automatically generated, when a new item created.

Was this reply helpful? Yes No
habibarif 18 on at

Like (0)

Report

Hi @v-xiaochen-msft,
Hope you are fine.
I need similar type of flow thats why using your solution but flow is failing.
Just want to know if it worked last time.

Want a flow where date and id resets every month.

Thanks in advance,

Was this reply helpful? Yes No