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.
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.
Hi, Thanks for the great video. I have a question though. In the list I am working on, I want the ID numbering to be continuous. Let say I delete the last entry, the ID would skio a number (go from 28 to 30). How can I make that happen ?
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 ="PR"&TEXT(ID-50,"00000000") and the output was PR00000001 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!!!
Awesome tutorial! Thank you much! Could you made another video that don't use default ID because I have repeated list which I need unique. For example case 1-01, case 1-02, case 1-03. case2-01. The default ID given sequence that 5, 3 which is not correct.
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']), '000000'))
Hi, SharePoint serial number why not sequenced, for example, S # must be 1,2,3 instead of 1,10, 100, 11, 12 13, please let me know how to do that in SP
Hello! Great video! I added this capability to an existing list in SharePoint. Is there a way to have the autonumbering apply to items that were in the list beforehand?
Hi Sir, how to I create custom numbering using my own format? Example, NONPR-0001-2023. The middle 4 digits number will continue if there is any new request and the last 4 digit is the current year when the request was made. Hope you can assist me, please.
Bro I need your help in creating the powerautomate flow to assign tickets automatically to more than two agents and users need to get email saying that you submitted the ticket agent will get back to you soon.
Microsoft are just making the use of Sharepoint harder and harder to force you to take the Dataverse path, which is better but ultimately a cost added service. you used to be able to make a auto increment field in sharepoint.
An excellent demonstration of Autonumbering ID's, and another great video.
Keep up the excellent work !!
This is the first video created by you that I watched. Very helpful. Keep up the good work!
Glad it was helpful!
this is THE BEST tutorial I have ever seen. Thank you so much brother!
This is really helpful an example of custom reference ticket Number!
Keep it up bro, supporting here from Malaysia 🇲🇾
Thank you very much bro. Love from Nigeria
Proper Tutorial i saw in youtube. thanks for the information.
Thank you so much, Instructions are very clear and easy to understand.
you are doing well
Incredibly helpful in my constant battle with incremental numbering in SharePoint Lists!
Love the way you explained. Simple nd superb
Glad you liked it
Great teaching methodology. Love the videos.
Awsome! Exactly what I was looking for! Thx for Sharing!
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.
Great video and good creativity in using the default seetings (Generating Id) and then in also hiding the editable column. Efficient throughtout.
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!
Saved me! Thanks!🙏🙏🙏🙏
YOU ABSOLUTE GEM OF A PERSON. THANK YOU SO MUCH FOR THIS!!❤
Such a helpful vid. You explained the process so well. Thank you!
Glad you found it helpful
Its awesome, a simple and smart language
Thank you. Worked well👏🏾👏🏾🗳️
Nicely explained. Cheers 👍
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.
So detailed explanation. Thank you
This guy is just amazing!!!!!!!
Keep up the good work brother!!!!
Excellent video, thanks bro!!
Super useful tricks! thank you!!!
Wow, I owe you brother thanks alot u ❤
Excellent demonstration, thank you - subscribed!
Thank you for this great tutorial, your presentation style is great for me and I need to do this for a work project.
Hi, Thanks for the great video.
I have a question though. In the list I am working on, I want the ID numbering to be continuous. Let say I delete the last entry, the ID would skio a number (go from 28 to 30). How can I make that happen ?
Thanks for your wonderful video bro, it saved my biggest problem
I am so glad it did. Thank you!
So amazing
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
="PR"&TEXT(ID-50,"00000000")
and the output was
PR00000001
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!!!
Really glad you found this video useful. Thanks for your comment and encouragement
Awesome tutorial! Thank you much! Could you made another video that don't use default ID because I have repeated list which I need unique. For example case 1-01, case 1-02, case 1-03. case2-01. The default ID given sequence that 5, 3 which is not correct.
Very helpful and well explained! Keep it up
Thank you! Great Job
Glad it was helpful!
Hey excellent video
This was extremely useful! thank you!
@theOyinbooke, Great video, how can i get the CaseID to reset to 1 in new month?
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']), '000000'))
Hi! I am having similar issues and I tried using your format but I am still getting issues. Need Help!
excellent video. how do I make the numbering restart every year?
Hi, SharePoint serial number why not sequenced, for example, S # must be 1,2,3 instead of 1,10, 100, 11, 12 13, please let me know how to do that in SP
Can we do this using SharePoint Designer and not power automate?
Thanks 😊
What if i want to start on a specific number instead of the provided ID?
Excellent demo. How do i reset my ID now to go back to one. It continues though I deleted earlier documents that I created to practice.
Did you figure this out?
Cool tx. Just hide the field in the form then no one can change it. It'll still be available in the view
Exactly
Hello! Great video! I added this capability to an existing list in SharePoint. Is there a way to have the autonumbering apply to items that were in the list beforehand?
Did you ever figure this out?
Hi Sir, how to I create custom numbering using my own format? Example, NONPR-0001-2023. The middle 4 digits number will continue if there is any new request and the last 4 digit is the current year when the request was made. Hope you can assist me, please.
Excellent Content!! Were you able to generate an next number ID which is not based on the internal ID and follows another NN? Thanks!
Bro I need your help in creating the powerautomate flow to assign tickets automatically to more than two agents and users need to get email saying that you submitted the ticket agent will get back to you soon.
Thank you for the request. Can you elaborate a bit more?
Microsoft are just making the use of Sharepoint harder and harder to force you to take the Dataverse path, which is better but ultimately a cost added service. you used to be able to make a auto increment field in sharepoint.
hello,i have a question ,can we hide content type?Thank you!
Yes, you can
You're patient, I am not :P