Sharepoint List To Create Number with Year And Increment by 1 Each Entry

[gerrymouse1]

Hello,

I have a Share point list that a user enters a new item through a PowerApp.

I would like Power Automate to add a unique number for the items added to the Sharepoint list that includes the current year.  (Eg 2020-1, 2020-2 etc)

The number should reset to 1 when a new year occurs.  Therefore,  when we get to 2021 it should start 2021-1 automatically.

Any thoughts on whether this is possible?  Help really appreciated.

Regards,

Gerald

[gerrymouse1 · Accepted solution]

Hello,

I have had an additional thought on this, but still not familiar with PowerAutomate on how to do it. 🙂

If I add a column on my share point list that auto defaults to the current year from the PowerApp, then if I get the PowerAutomate flow to perform a count of items with the year, increment by one and add it to the text of the current year could this work?

Any ideas on how to do this or any other way?

Gerald

[gerrymouse1 · Accepted solution]

Resolved myself

[Pete_Walburn]

Hi,

 I am trying to do something similar and think that this would work, unless records were deleted. So, if there were 3 records:

2022-1

2022-2

2022-3

then 2022-2 was deleted. The next entry would then be 2022-3 because there are 2 entries for the year 2022. But then there would be a duplicate.

Can I get the maximum value after the 2022- and increment that and append it to 2022-?

Pete