Do you need to copy a product list from recent lists. It does not list a product list for me. How can you get the iD from one developed from scratch. this is a perfect solution for me to create a list of my QR codes (with unique reference number) which will be part of the graphic. Just need to get on to right track. Any hints or tips.
Go to list settings page. In the URL you will see the id like List=%7B661fb415-2f00-43fa-a569-2bea5ed16471%7D. ignore %7B and %7D as they are html tags, in-between these tags you have the list ID, in my case it is 661fb415-2f00-43fa-a569-2bea5ed16471
Yes, it is possible. You can create a separate list to store the year counter. Then, use a Power Automate flow to increment the counter by one for each new entry. The flow will update the counter in the list and combine it with the current year to generate a unique reference number.
@@KeaPointTechTips Thank you for your kind reply. As I don't have much experience with this, I don't fully understand your tip. I also don't know if I have been clear enough - I'm interested in a self-updating reference number which is restarted every year (ex. REK-24-001, REK-24-002, ...). The first entry in 2025 would be REK-25-001. Thank you in advance!
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
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
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.
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.
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.
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!
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?
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.
Hello. I would like to create unique ID : country (based on a choice of 5 country in à column, year YYYY, month MM, number xxxx. And this number starts again at 1 at the beginning of month. Thanks a lot
capture the numbers with country name in a separate lists for each country, update it's counter via flow every time it is used, reset the list item counter on first day using a different flow. year and date stuff you can retrieve form the current date.
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 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.
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!
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.
Thanks, this worked. I have no experience and I was able to set this up! Appreciate you sharing this!!
I'm so glad to hear that it worked for you! It's always great to see beginners getting things set up successfully. Keep it up!
Great tx!! Much easier to find and follow than what Microsoft puts out about this topic.
Glad you liked it Carl!
Does what it says on the tin. Quick, simple and effective. Thank you so much for sharing your knowledge
You are welcome!!
thanks so much for this !! spent hours finding for a solution
Thanks David!
Thanks for the video. Learned a lot
Glad to hear it!
Excelent 🎉💯
Thanks!
Simple and to the point. Thank you for the tutorial
You're welcome!
This is something that I've been looking for for 3 days😢
Finally, you got it working!
Thi worked for me! Thank you very much good sir!
You're welcome!
@@KeaPointTechTips Subbed! Can we do this in excel too?
Do you need to copy a product list from recent lists. It does not list a product list for me. How can you get the iD from one developed from scratch. this is a perfect solution for me to create a list of my QR codes (with unique reference number) which will be part of the graphic. Just need to get on to right track. Any hints or tips.
Go to list settings page. In the URL you will see the id like List=%7B661fb415-2f00-43fa-a569-2bea5ed16471%7D. ignore %7B and %7D as they are html tags, in-between these tags you have the list ID, in my case it is 661fb415-2f00-43fa-a569-2bea5ed16471
Is it possible to make an self-updating auto-incrementing year-based reference number? Thank in advance!
Yes, it is possible. You can create a separate list to store the year counter. Then, use a Power Automate flow to increment the counter by one for each new entry. The flow will update the counter in the list and combine it with the current year to generate a unique reference number.
@@KeaPointTechTips Thank you for your kind reply. As I don't have much experience with this, I don't fully understand your tip. I also don't know if I have been clear enough - I'm interested in a self-updating reference number which is restarted every year (ex. REK-24-001, REK-24-002, ...). The first entry in 2025 would be REK-25-001. Thank you in advance!
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
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
Yes, generating this pattern is possible. What is the question?
@@KeaPointTechTips Thank you for the response. Can you indicate how I can do this using power automate?
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.
That is easy to do. Just follow the below video from my channel
th-cam.com/video/j8Eu0ytRfO4/w-d-xo.html
@@KeaPointTechTips Thank you so much.
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.
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.
@@KeaPointTechTips Thank you so much. Would you mind simply let me know how the + 1 formula syntax is? Thanks a lot.
@@KeaPointTechTips Dear the Respectable Expertise, would you mind giving me some brief desc. on the solution. Appreciate you very much.
@@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?
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
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.
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!
It should work for dataverse as well. The dataverse record already have a guid as ID which can be used in many scenarios.
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?
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.
Hi, what Value would I want, if i want the ID to be the same as the title?
In this case, you need to set title column to have unique values.
@@KeaPointTechTips Hi, thanks for the resonse. so in the initalise variable where it says value, what will i add? Or is this something different.
If you want to use the title as ID, you don't need a flow. You just need to make title column settings to have a unique value
What if you want to start Id number at a different sequence?
Hello. I would like to create unique ID : country (based on a choice of 5 country in à column, year YYYY, month MM, number xxxx. And this number starts again at 1 at the beginning of month.
Thanks a lot
capture the numbers with country name in a separate lists for each country, update it's counter via flow every time it is used, reset the list item counter on first day using a different flow. year and date stuff you can retrieve form the current date.
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
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.
@@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.
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!
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.