How to Generate Unique ID for Microsoft Lists Records Using Power Automate

Подписаться 10 тыс.

Просмотров 36 тыс.

50% 1

In this video you will learn different ways to generate unique ID for Microsoft Lists records using power automate.
I will show you three different wats to generate unique Id for SharePoint or Microsoft list records using power automate. First Option is to concatenate available List ID column with some prefix value to generate unique ID. Second option is to use datetime to generate unique ID and third way is to use Power automate Guid function to generate unique ID.
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 00:42 Using Prefix with List Record ID to Generate Unique ID
• 03:40 How to Generate Unique ID for List Records Using Date Time
• 05:10 Unique ID for List Items Using Power Automate Guid Function
• 05:58 Outro & Subscribe
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerAutomate
#MicrosoftLists
#UniqueIdentifier

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

21 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 47

@carlw 2 года назад

Great tx!! Much easier to find and follow than what Microsoft puts out about this topic.

@KeaPointTechTips 2 года назад

Glad you liked it Carl!

@paulskelton8799 Год назад

Does what it says on the tin. Quick, simple and effective. Thank you so much for sharing your knowledge

@KeaPointTechTips Год назад

You are welcome!!

@alpanapradhan2328 Год назад

Simple and to the point. Thank you for the tutorial

@KeaPointTechTips Год назад

You're welcome!

@jj1607jj 3 года назад

Thanks for the video. Learned a lot

@KeaPointTechTips 3 года назад

Glad to hear it!

@davidsrinivasan7764 2 года назад

thanks so much for this !! spent hours finding for a solution

@KeaPointTechTips 2 года назад

Thanks David!

@averynight2817 2 года назад

This is something that I've been looking for for 3 days😢

@KeaPointTechTips 2 года назад

Finally, you got it working!

@Brothercole1994 3 года назад

Thi worked for me! Thank you very much good sir!

@KeaPointTechTips 3 года назад

You're welcome!

@Brothercole1994 3 года назад

@@KeaPointTechTips Subbed! Can we do this in excel too?

@ceciliachan9616 3 года назад

Thanks for the video. Would you please advise me how to do the "Colored Labeling" in the Colour column in your "Product" list? Thanks a lot.

@KeaPointTechTips 3 года назад

That is easy to do. Just follow the below video from my channel ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-j8Eu0ytRfO4.html

@ceciliachan9616 3 года назад

@@KeaPointTechTips Thank you so much.

@aisyaharimurti Год назад

how if i wanna make an id sequentially, but not based on the columb ID from sharepoint list, but from the date of the item create. for example, the first data will have id for-00123, rhe the second will be for-00223, and so on

@aharshaa1 2 года назад

This is brilliant, thanks for the video. Just to confirm, this will work for Dataverse as well right? I don't see any reason why it would not work. However, while using Dataverse do you advise any other way/practice for Unique ID, please share a link to your video repository if you have done that already. Thanks and I have subscribed you!

@KeaPointTechTips 2 года назад

It should work for dataverse as well. The dataverse record already have a guid as ID which can be used in many scenarios.

@nerdgal Год назад

What if you want to start Id number at a different sequence?

@ceciliachan9616 3 года назад

I have another quite difficult part that if I want to do the unique ID based on the sequence of the entry created per day prefixed by the date, such as YYMMDD01 (the 1st entry on the day is 21070601) and the 99th entry on the day is 21070699? Thank you so much.

@KeaPointTechTips 3 года назад

You can get current date in the above format and can also retrieve the last saved record ID, it it is from the same date then append 1 to the last record ID to generate new id otherwise that will be your first id of the day and you can simply append 01 to the date.

@ceciliachan9616 3 года назад

@@KeaPointTechTips Thank you so much. Would you mind simply let me know how the + 1 formula syntax is? Thanks a lot.

@ceciliachan9616 3 года назад

@@KeaPointTechTips Dear the Respectable Expertise, would you mind giving me some brief desc. on the solution. Appreciate you very much.

@mkavo 2 года назад

@@KeaPointTechTips Hi, I would also like to know the syntax to this if possible as I've been asked to do the same and this sounds like good solution?

@abhishekgor27 2 года назад

Thank you for the video, just wanted to ask I have different attributes and have been trying to create IDs based on attribute type in the Sharepoint List. Below is an example of the outcome I want to achieve, 1. (Company Name)-(Booking A)-0001 2. (Company Name)-(Booking A)-0002 3. (Company Name)-(Booking B)-0001 4. (Company Name)-(Booking A)-0003 5. (Company Name)-(Booking B)-0002 And so on so forth as new attribute type of booking comes it should start from 1 and then 2 and so on. I would like these to be mutually exclusive in the same list. Is this possible in Sharepoint List? At the moment I can only have a series like below 1. (Company Name)-(Booking A)-0001 2. (Company Name)-(Booking A)-0002 3. (Company Name)-(Booking B)-0003 4. (Company Name)-(Booking A)-0004 5. (Company Name)-(Booking B)-0005

@KeaPointTechTips 2 года назад

Yes, generating this pattern is possible. What is the question?

@abhishekgor27 2 года назад

@@KeaPointTechTips Thank you for the response. Can you indicate how I can do this using power automate?

@LAXMIKANT1992 2 года назад

Since You have added ODR00+ID so it is fine till ODR0099. But for the 100th item will it be ODR0100 or ODR00100? If its ODR0100,ORD0101.....ODR1000,ODR1001 then fine otherwise how to acheive this?

@KeaPointTechTips 2 года назад

You need to add a switch condition and check, check how many digits are there in the unique id. Add the number of zero's at the front of the id accordingly before appending it to ODR string.

@wouterpinkhof7283 2 года назад

Nice tutorial, but when you create an item in the sharepoint list in a different way (i.e. create it from an email that is received), the process never starts. The Power Automate does not "see" the item is created in the list. Do you have a workaround for this? Kind regards, Wouter

@KeaPointTechTips 2 года назад

Strange! It should start as long as the trigger is set to when item created in SharePoint list regardless of how the record were created in the list.

@wouterpinkhof7283 2 года назад

@@KeaPointTechTips Well, it does not work as expected. I found a way to solve the issue however. In my scenario, if you introduce a "Sharepoint Get Item" step after the "Sharepoint Create Item' step, the process will flow correctly. Must be some kind of bug.

@sabrenahamid7504 2 года назад

Is there a way to configure the ID column so it starts from a number such as 450 instead of the ID column starting at 1

@KeaPointTechTips 2 года назад

SharePoint ID Column is a default column. One option is to create a custom ID column. Another option is to create 449 records to the list via script and delete them later. Next record you will create will have the ID 450 and so on.

@rico451 Год назад

@@KeaPointTechTips I'm running into the same issue. The problem with your solution is that all subsequent entries will not follow the proper order after the newly added entry. In the example, all lines after the prior "450" entry and forward won't automatically be adjusted with a "+1" and the user will need to manually fix all such entries. I'm wondering if there's a quick way to use power automate to do so... Any suggestions? Thanks in advance!

@oraibabdulla 3 года назад

I want to create a column will start from 1 even the original ID column is not 1 and auto increase with 1 each time the item added ,,, do anybody know how to do this ? please help!

@KeaPointTechTips 3 года назад

Create a custom column in SharePoint list and add value 1 to the starting record. Create power automate flow on item created trigger. You need to retrieve last saved record from the list and get the id value and add 1 to it. Save the new id in the newly created record by calling the item update action.