Forum Discussion
Solved
Generate a unique number like ID in A SharePoint list.
Hello, I have created a SP List. From what I see every item has a unique number (ID). I found out that there is impossible to reset this ID number. I would like to add a column which generate a num...
- may I ask why you would reset it if it needs to be unique? Technically speaking if you need to just go quarter to quarter with the number, type of thing, you could always just use a calculated column and user [ID] for first quarter, then if you have a hard reset of items, you can then go set that column to [ID] minus whatever your ID currently is at.
It's not pretty, but depending on your use case on how that flows it could work assuming you no longer care about the numbers once you do a reset. Otherwise flow would be your solution and you could take a similar logic without needing to maintain another list, you can just update the flow to subtract however many you want to reset back too off of the ID column.
The difference with option 1 vs. flow, is flow would set the individual list item number, using calculated method reevaluates the number for all the existing items once you change it.
may I ask why you would reset it if it needs to be unique? Technically speaking if you need to just go quarter to quarter with the number, type of thing, you could always just use a calculated column and user [ID] for first quarter, then if you have a hard reset of items, you can then go set that column to [ID] minus whatever your ID currently is at.
It's not pretty, but depending on your use case on how that flows it could work assuming you no longer care about the numbers once you do a reset. Otherwise flow would be your solution and you could take a similar logic without needing to maintain another list, you can just update the flow to subtract however many you want to reset back too off of the ID column.
The difference with option 1 vs. flow, is flow would set the individual list item number, using calculated method reevaluates the number for all the existing items once you change it.
It's not pretty, but depending on your use case on how that flows it could work assuming you no longer care about the numbers once you do a reset. Otherwise flow would be your solution and you could take a similar logic without needing to maintain another list, you can just update the flow to subtract however many you want to reset back too off of the ID column.
The difference with option 1 vs. flow, is flow would set the individual list item number, using calculated method reevaluates the number for all the existing items once you change it.
Hi ChrisWebbTech! I found a thread about how to get a SharePoint List column similar to the ID. In my case, I really need to find a solution or a workaround without needing to use the ID column (to avoid Jump in the sequential reference numbers when an entry is deleted). Could you please provide further details or, a step-by-step to create a flow for this end?