Forum Discussion
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 'Multiple lines of text'. When a new item is added to the list, I want the ID column to auto-increment.
What I've tried is, using the 'Edit column' dialog, I checked the 'Use calculated value' checkbox and in the 'Default value' field I've entered the formula:
= "ID"+1
But the ID field is not getting populated nor is it auto-incrementing. Any thoughts what I am doind wrong?
Tom McCann
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
10 Replies
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.
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.
- Thank you! I was not aware of that field.
