How to Create Custom AutoNumbering Columns in SharePoint List

Creating an Auto number column in the SharePoint list should be intuitive if such column type can be found in the list of available column type options in the SharePoint list but it is not.

I recently took up a task and had to create a custom auto-number column. This was when I found out how hard it is, and I have decided to share this learning journey with you.

I must also mention that ‎the @JohnDayQA   video resource on this topic was very useful while I was solving this challenge.

This is not my regular tutorial. The tone and mode were more narratives than instructional.

I made use of the ID column that is been created as hidden meta-data for every list on a SharePoint list. This worked but didn’t solve my challenge. I needed a custom Auto number. Something like CS/Enquiry/28/05/21/0001. To achieve this, I have to try something else.

#theoyinbooke #powerautomate #sharepoint #powerplatform #sharepointlist #autonumber #autonumberingcolumns

[JohnDayQA]

An excellent demonstration of Autonumbering ID's, and another great video.
Keep up the excellent work !!

[jamiecook]

You are a genius! Thank you so much!
I have been working on a new system for my company and without your help, I don't think we would have ever got away from Excel.
Well done, you've just got yourself a subscriber.

[MuhammedMuzzammilShah-lexq]

YOU ABSOLUTE GEM OF A PERSON. THANK YOU SO MUCH FOR THIS!!❤

[victorsoh]

This is the first video created by you that I watched. Very helpful. Keep up the good work!

[thigomes]

this is THE BEST tutorial I have ever seen. Thank you so much brother!

[davidtechnik]

Awsome! Exactly what I was looking for! Thx for Sharing!

[earlgutierrez]

This is really helpful an example of custom reference ticket Number!

[hugofasima]

Thank you. I even used this to "Reset" the ID by subtracting the last ID column number I had:

This is what I used for my "Purchase Request No" column




and the output was



Which was exactly what I wanted.

So prettey much, my last ID (that one that hidden sharepoint column that sharepoint adds automatically) was 51, so then I subtracted 50 from it inside the text so it keeps the format I needed. AMAZING.

I was trying to do this trough power automate and it was such a HEADACHE. Thank you so much mate, you have no idea!!!

[kennethclark]

Thank you so much, Instructions are very clear and easy to understand.

[obiekwegh]

Great video and good creativity in using the default seetings (Generating Id) and then in also hiding the editable column. Efficient throughtout.

[jasonblais]

Great video. For whatever reason i couldn't type FormatNumber and then pull in the ID, so i used the option available under Expression called "Format data by examples" and it provided this, which worked perfectly:
concat('Case ', formatNumber(float(items('For_each')?['ID']),

[ethisai]

Proper Tutorial i saw in youtube. thanks for the information.

[matthewdixon]

Thank you for this great tutorial, your presentation style is great for me and I need to do this for a work project.

[muhammadyunusmazlan]

Keep it up bro, supporting here from Malaysia 🇲🇾

[latenianalliah]

Thank you so very much for your video. I was able to further design my power apps experience. Thanks and keep up the good work!

[briank]

Excellent demonstration, thank you - subscribed!

[malcolmgash]

Great teaching methodology. Love the videos.

[MrEejal]

Assalammualaikum brother..
I can't thank you enough for sharing this wonderful tutorial! 👍👍 I have managed to do on my own and even adjusted the unnecessary details. This is indeed a great video.

May you have a greater achievements for 2023!! Insha'Allah...

Jazakllah khayran.

[shasikumar]

Love the way you explained. Simple nd superb

[jenkztv]

Very helpful and well explained! Keep it up