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
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
- Could you associate that number to another column? I'd like to have the TEST_PROJECT_XXXX, where "TEST_PROJECT_" is always in the beginning of that field and the XXXX number is associated to the ID number from the hidden ID column. Is this possible?
- You need to create for example a Power Automate Flow, which updates the field value when a new item is created on the list.
Doesn't the ID field manage the Version history with Auto-Increment whenever there is a change to the record.
Is the same unique ID available within the MS Teams Task List/Task Board?
I could not see a way to add/remove columns- I only see Task Title, Assigned To, Priority, Due, and Bucket columnsThanks!
- It is not possible to modify Teams Tasks App/Planner task board 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
- Thank you! I was not aware of that field.
