cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gerrymouse1
Frequent Visitor

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

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
gerrymouse1
Frequent Visitor

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

View solution in original post

gerrymouse1
Frequent Visitor

3 REPLIES 3
gerrymouse1
Frequent Visitor

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
Frequent Visitor

Resolved myself

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,093)