AutoNumbering Columns in SharePoint List

Occasional Visitor

Good morning,


I have a Sharepoint list used for tracking my documents. I manually number each document, but this has become challenging over the past month. 


Is there a way to automatically create a unique ID?


I need something that starts with the two-digit year and has the document number created that year. for example, 22-205

22 for the two-digit year 205 for the document added that year.


The number will also need to be reset every year. Once January first, 2023 comes, the following document created will be 23-001.


Can someone assist me?

1 Reply

Hello @torresH


you can do it with Power Automate Flows. Here is one example:


Other you can find with internet search machines, search "power automate flow sharepoint autonumber"


Regards, Dave