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.
MST97 I agree with jcgonzalezmartin, and one way you can do this is to have a separate list on your SharePoint site which just has 1 item for the increment number. Then you'll need Flow to get that number and add it to the item then update it +1 for the next item. If you need detailed steps for this come back to us.
Rob
Los Gallardos
Microsoft Flow Community Super User