Create a Unique ID using custom Autonumber columns in SharePoint

preview_player
Показать описание
If you want to create an autonumber for refrence codes with prefixed charctares and "x" number of digist long. This video will show you using a SharePoint list and a small Power Automate flow.

There is a follow-on video that will allow to centrally manage all your ID's from one place with lots of extra featrures. It continues on the build of what is covered in this video.
Рекомендации по теме
Комментарии
Автор

Fantastic tutorial, very clear, no jumping around and perfectly understandable verbiage.

Excellent guidance, thank you for assisting with this deliverable.

bitAtheist
Автор

I searched and read multiple forums. I think this was the best. Thanks John. Much appreciated.

jacksonsheikh
Автор

1000 cool points awarded to this man for a very useful video.

M_Minion
Автор

Hi John, I was searching low and high, for days without any luck and thanks to YouTube Gods to direct me to your video. I was stuck at a pivotal moment in my project and I really needed a customized column name for my automation to work as designed. Massive thanks to you!!!

TheDistractionStudio
Автор

Thank you, thank you, thank you! MVP. It worked! If you are not patient, you will leave halfway.

minstreltokunbo
Автор

Excellent - thank you - just stumbled across this video and answered a number of questions I had

lucassandecker
Автор

John... Fantastic Video. You explained the process perfectly. Please keep making the videos!

GenElias-jdvh
Автор

I agree with all the below comments - by far the simplest and most effective solution I could find after much trawling. Has worked really well for my list - many thanks, John.

ThomasBaker-pnxp
Автор

Brilliant explanation and it worked like a charm. Please keep doing more videos. Thanks again !

mailingveera
Автор

great video, this helped me build my first Powerautomate flow for a SharePoint List - felt weirdly giddy when it worked as intended. Big thanks!

TheAlphaDingo
Автор

Hi John. Thank you so so so much for posting this great content and you made my day today as I was looking for this for almost 5 hours.

eugchern
Автор

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']),

jasonblais
Автор

Hi John this is very useful and will definitely come in handy. Looking forward to more great videos

lornatic
Автор

Thank You sir, this was really helpful and nicely and explained

tockjutube
Автор

Hi John. Fantastic solution. Thank you for sharing.

ces-cl
Автор

Perfect! Thank you for sharing. Big help!

rajaaustin
Автор

Thanks, John, it's the best illustration I could find on youtube for this topic. simple and easy :)

SherifKhalaf
Автор

This was very useful. Thank you so much for sharing

karolinaunderwood
Автор

Excellent work! Spent hours looking for this! Thanks so much.

rossjackson
Автор

Thank you so much this was extremely helpful!

JessicaPricejessimey