web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Reset ID at the end of...
Power Automate
Unanswered

Reset ID at the end of each new calendar year.

(0) ShareShare
ReportReport
Posted on by 16

Hello Microsoft Community

 

I am seeking your assistance with a functionality that I am trying to implement in SharePoint using Power Automate.

 

The desired functionality is as follows:

 

I am aiming to develop a system that numbers the items added to a SharePoint list in a sequential manner, but with a unique twist: the numbering should be based on the year of the post and reset at the beginning of each new calendar year.

 

To elaborate further:

  • Crucially, the sequence number should be reset to 1 at the beginning of every new year. For example, if the final post of 2023 is numbered 250/2023 (indicating it was the 250th post of the year 2023), the first post of 2024 should be numbered 1/2024.

 

The primary purpose of this feature is to act as a yearly post counter within a single SharePoint list.

I am curious if it is possible to implement this functionality within SharePoint or Power Automate. Any insights, suggestions, or potential solutions would be greatly appreciated.

 

For your better understanding, I have attached a mock-up of what I am envisioning:

 

EXAMPLE_tst.png

 

Thank you in advance for your assistance!

Best Regards, David

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard