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.
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!!!
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'))
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.
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.
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.
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, 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
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.
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!
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.
YOU ABSOLUTE GEM OF A PERSON. THANK YOU SO MUCH FOR THIS!!❤
you are doing well
Awsome! Exactly what I was looking for! Thx for Sharing!
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
this is THE BEST tutorial I have ever seen. Thank you so much brother!
Love the way you explained. Simple nd superb
Glad you liked it
Proper Tutorial i saw in youtube. thanks for the information.
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
Great video and good creativity in using the default seetings (Generating Id) and then in also hiding the editable column. Efficient throughtout.
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'))
Thank you so much, Instructions are very clear and easy to understand.
Great teaching methodology. Love the videos.
Such a helpful vid. You explained the process so well. Thank you!
Glad you found it helpful
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!
So detailed explanation. Thank you
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.
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.
Its awesome, a simple and smart language
Super useful tricks! thank you!!!
Nicely explained. Cheers 👍
Excellent video, thanks bro!!
This guy is just amazing!!!!!!!
Very helpful and well explained! Keep it up
Keep up the good work brother!!!!
Thank you. Worked well👏🏾👏🏾🗳️
Thanks for your wonderful video bro, it saved my biggest problem
I am so glad it did. Thank you!
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.
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.
Cool tx. Just hide the field in the form then no one can change it. It'll still be available in the view
Exactly
Wow, I owe you brother thanks alot u ❤
So amazing
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?
You're patient, I am not :P
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?
excellent video. how do I make the numbering restart every year?
Excellent Content!! Were you able to generate an next number ID which is not based on the internal ID and follows another NN? Thanks!
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! I am having similar issues and I tried using your format but I am still getting issues. Need Help!
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
What if i want to start on a specific number instead of the provided ID?
Can we do this using SharePoint Designer and not power automate?
Thanks 😊
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.
Thank you for the request. Can you elaborate a bit more?
hello,i have a question ,can we hide content type?Thank you!
Yes, you can