Тёмный

How to Create Custom AutoNumbering Columns in SharePoint List 

TheOyinbooke
Подписаться 13 тыс.
Просмотров 64 тыс.
50% 1

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.
I created this video to add to resources out there and you can always check many of them for more advanced topic and customization. ‎@John Day Q&A channel is recommended for more in-depth content on this.
#theoyinbooke #powerautomate #sharepoint #powerplatform #sharepointlist #autonumber #autonumberingcolumns

Развлечения

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 64   
@JohnDayQA
@JohnDayQA 2 года назад
An excellent demonstration of Autonumbering ID's, and another great video. Keep up the excellent work !!
@jamiecook4288
@jamiecook4288 2 месяца назад
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-le8xq
@MuhammedMuzzammilShah-le8xq 2 месяца назад
YOU ABSOLUTE GEM OF A PERSON. THANK YOU SO MUCH FOR THIS!!❤
@davidtechnik8779
@davidtechnik8779 2 года назад
Awsome! Exactly what I was looking for! Thx for Sharing!
@briank1082
@briank1082 Год назад
Excellent demonstration, thank you - subscribed!
@matthewdixon7274
@matthewdixon7274 Год назад
Thank you for this great tutorial, your presentation style is great for me and I need to do this for a work project.
@ethisai
@ethisai 11 месяцев назад
Proper Tutorial i saw in youtube. thanks for the information.
@victorsoh9069
@victorsoh9069 2 года назад
This is the first video created by you that I watched. Very helpful. Keep up the good work!
@TheOyinbooke
@TheOyinbooke 2 года назад
Glad it was helpful!
@latenianalliah6053
@latenianalliah6053 Год назад
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!
@thigomes23
@thigomes23 11 месяцев назад
this is THE BEST tutorial I have ever seen. Thank you so much brother!
@obiekwegh6340
@obiekwegh6340 Год назад
Great video and good creativity in using the default seetings (Generating Id) and then in also hiding the editable column. Efficient throughtout.
@kennethclark9872
@kennethclark9872 4 месяца назад
Thank you so much, Instructions are very clear and easy to understand.
@sarahlumgair3759
@sarahlumgair3759 2 года назад
Such a helpful vid. You explained the process so well. Thank you!
@TheOyinbooke
@TheOyinbooke 2 года назад
Glad you found it helpful
@jenkztv3782
@jenkztv3782 2 года назад
Very helpful and well explained! Keep it up
@malcolmgash2545
@malcolmgash2545 4 месяца назад
Great teaching methodology. Love the videos.
@MrEejal
@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.
@amitjadhav8198
@amitjadhav8198 Год назад
So detailed explanation. Thank you
@manjulajayawickrama9127
@manjulajayawickrama9127 10 месяцев назад
Nicely explained. Cheers 👍
@earlgutierrez9298
@earlgutierrez9298 Год назад
This is really helpful an example of custom reference ticket Number!
@antoinecaner6354
@antoinecaner6354 Год назад
Super useful tricks! thank you!!!
@jasonblais1667
@jasonblais1667 8 месяцев назад
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'))
@muhammadyunusmazlan3772
@muhammadyunusmazlan3772 2 года назад
Keep it up bro, supporting here from Malaysia 🇲🇾
@TheOyinbooke
@TheOyinbooke 2 года назад
Thank you very much bro. Love from Nigeria
@valentineozala6433
@valentineozala6433 Год назад
Keep up the good work brother!!!!
@joeaggrey9166
@joeaggrey9166 2 года назад
you are doing well
@eaarayauc
@eaarayauc Год назад
Excellent video, thanks bro!!
@hugofasima
@hugofasima 8 месяцев назад
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!!!
@TheOyinbooke
@TheOyinbooke 7 месяцев назад
Really glad you found this video useful. Thanks for your comment and encouragement
@shasikumar2851
@shasikumar2851 2 года назад
Love the way you explained. Simple nd superb
@TheOyinbooke
@TheOyinbooke 2 года назад
Glad you liked it
@victoriabertone7256
@victoriabertone7256 Год назад
Excellent Content!! Were you able to generate an next number ID which is not based on the internal ID and follows another NN? Thanks!
@abbaslokhandwala8445
@abbaslokhandwala8445 5 месяцев назад
Its awesome, a simple and smart language
@valentineozala6433
@valentineozala6433 Год назад
This guy is just amazing!!!!!!!
@romalouis1
@romalouis1 10 месяцев назад
Thank you. Worked well👏🏾👏🏾🗳️
@WilsonC15
@WilsonC15 4 месяца назад
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.
@elonli5752
@elonli5752 2 года назад
Thank you! Great Job
@TheOyinbooke
@TheOyinbooke 2 года назад
Glad it was helpful!
@styles3540
@styles3540 11 месяцев назад
Wow, I owe you brother thanks alot u ❤
@lokeshkarnam6521
@lokeshkarnam6521 8 месяцев назад
Thanks for your wonderful video bro, it saved my biggest problem
@TheOyinbooke
@TheOyinbooke 7 месяцев назад
I am so glad it did. Thank you!
@remotebusiness-cl9vy
@remotebusiness-cl9vy 7 месяцев назад
So amazing
@adwenewilliams4312
@adwenewilliams4312 11 месяцев назад
@theOyinbooke, Great video, how can i get the CaseID to reset to 1 in new month?
@DuncanCunningham
@DuncanCunningham Год назад
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.
@hassantorres8863
@hassantorres8863 2 года назад
excellent video. how do I make the numbering restart every year?
@swarnacreation6796
@swarnacreation6796 2 года назад
Hey excellent video
@bisiwilliams1193
@bisiwilliams1193 2 года назад
This was extremely useful! thank you!
@carlw
@carlw 2 года назад
Cool tx. Just hide the field in the form then no one can change it. It'll still be available in the view
@TheOyinbooke
@TheOyinbooke 2 года назад
Exactly
@user-dr9kd5em8k
@user-dr9kd5em8k Год назад
Can we do this using SharePoint Designer and not power automate? Thanks 😊
@brianahstamp7512
@brianahstamp7512 Год назад
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?
@pointybinkie2982
@pointybinkie2982 10 месяцев назад
Did you ever figure this out?
@bhargavipaturi425
@bhargavipaturi425 2 года назад
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.
@pointybinkie2982
@pointybinkie2982 10 месяцев назад
Did you figure this out?
@musicislost
@musicislost Год назад
What if i want to start on a specific number instead of the provided ID?
@deandraboyd2943
@deandraboyd2943 Год назад
Hi! I am having similar issues and I tried using your format but I am still getting issues. Need Help!
@imranjaafar2102
@imranjaafar2102 Год назад
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.
@shathike4079
@shathike4079 Год назад
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
@HiroshimaMS
@HiroshimaMS 6 месяцев назад
You're patient, I am not :P
@venkyboddula
@venkyboddula 8 дней назад
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.
@TheOyinbooke
@TheOyinbooke 6 дней назад
Thank you for the request. Can you elaborate a bit more?
@elonli5752
@elonli5752 2 года назад
hello,i have a question ,can we hide content type?Thank you!
@TheOyinbooke
@TheOyinbooke 2 года назад
Yes, you can
Далее
Разбудили Любимой Песней 😂
00:14
SharePoint Document Library Tutorial
20:22
Просмотров 647 тыс.
Run a flow when a SharePoint column is modified
9:58
Просмотров 124 тыс.
How To Create A Lookup Column On A SharePoint List
7:00
How To Add Email Notifications To A SharePoint List
15:41
Приятного аппетита 🤣
0:15
Просмотров 5 млн
Отнимают ребенка ч.4
0:55
Просмотров 4,2 млн
Заячий Стон - Рот пятничный
0:55