How to create auto generate ID column in SharePoint list using MicroSoft Power Automate flow

In this video you will learn How to create auto generate ID column in SharePoint list using MicroSoft Power Automate flow. when there is a new item is created the flow will trigger to update the item with unique ID. watch full video to learn.

[VictorBalestra]

I had to concatenate with other column and worked perfect as well. Thanks a lot!!

[musicislost]

Thank you so much other videos were so complex you made this so easy🎉

[abbasthegreat]

Thank you Sir,
To start from 1, I used the following formula.
add(sub(triggerBody()?['ID'], 32), 1)
Where 32 is the current ID + 1, i.e my current list ID was 31 and it put here 32 to make it 0 and then added 1 to make it start with 1.

[danielfonseca]

Hi Sr. thank you for your contents. Could I create a new number instead of using the sharepoint Id? I would like to genarete a new sequencial number, that I can reset when a new year starts.

[linuxdocc]

Is there a way to generate UserID's for all "old" existings entries in the sharepoint list?

[bitspieces]

Wondering if I can use concat instead of add. I need to combine two columns to produce a unique identifier the case is ( AX-ID) <-- this is what I want my output to look like. I you could please advise I will be thankful.

[omsingh]

Hi i was started on power automate but when i create column and added new data for me UserID option is showing in new column for you its not showing why is that??

[soffffia]

I have a question, I'm new using this, but I tried to continue the flow with otre list to make their autogenerate columns but it doesn't work, I need to do a flow to each of my list?? thanks for the video btw

[demiuxp]

Thank you for posting this video. I do have one quick question, isn't the "Id" field that already exists a unique identifier for that particular row, and if so, couldn't that be used later on in other processes instead of adding in another unique identifier to the row?

[WilsonC]

I like the video! Thank you. 1 request I don't want to use Default ID reference. I want incremental 001, 002, 003 automatically. How?

[fabiomrocha]

This works, but not too well. Because the numbers is being well generated, but if you delete the item, the numbers will keep counting even if you delete a item. Exist a way that I can not to consider part of counting deleted items?

[njunukkupani]

Anybody plz help me. I m adding some info to a custom list without signing in. And, I would like to get ID/ reference number when I save the item as a popup. Thanks in advance.

[snath]

Sir, Thank you for this tutorial video, I am using your process and I have added an email triggering the approval with this flow, on that email subject, I have included the same auto-generated ID, but after the receiving email, in the subject auto-generate ID has missing, because the SharePoint list is taking a few seconds to generate the ID, before creating the ID email flow (approval flow) has sent the email, please suggest

[jyostnaroy]

What if we want to put text(Query ID) instead of the number(1000)? What would be the expression? How do i fill the existing information in the list?

[leoniesnyman]

How do I add a bunch of characters prior to the number generation? Eg AB-1001 ?

[luiscuellar]

Hi, thank you so much for your video. I have a question for you... I would like it to be 0001 instead of 1001, but at moment of putting 0000 in the string it takes it as if it were empty and puts me 1 instead of 0001, how can I put it so that it puts 0001?

[gamingescape]

What if I want to send email after ID is generated and email should contain that USerID along with other details? Can you tell how to do that as I am trying to send email however email is getting triggered before ID is generated and email does not show ID generated .

[Rohit-edhz]

Will "ID" start from 1 if we delete all records and insert new one. if not how to do that.

[marketing-institute]

where did you get the source on the left of sharepoint, as i dont have it

[saksaridchangtham]

Take more than 10 minutes to update. Can we improve the time to update