Answered

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

All responses (3)

Answers (2)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

nicolaslemerle 22 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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,