Forum Discussion
Solved
Microsoft Lists Auto Increment Number Field
Hi Experts, I am using MS Lists within MS Teams for the 1st time today. I am trying to create a simple issue list with 2 columns. 1st column (ID) is of type Number and the 2nd column is of type '...
Hi tmc_legrand,
Each list already has a default ID column, which is auto-incrementing. Could you use that as an ID column for your solution?
You can add it to your view from Show/hide columns
Careful with using the ID column in a SPO list for the purpose you are explaining here. While it's true the ID column autoincrements its value for every new record created, it's also true the ID column is not aware if there is deletion of a previous record and you cannot reuse the ID of a deleted record
And for this case, to solve these problems, which alternative do you suggest?