Forum Discussion
tmc_legrand
Mar 15, 2021Copper Contributor
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 '...
- Mar 16, 2021
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
ChasanC
May 24, 2022Copper Contributor
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?
Jan 09, 2023
You need to create for example a Power Automate Flow, which updates the field value when a new item is created on the list.
- SoyuzJan 27, 2025Copper Contributor
Doesn't the ID field manage the Version history with Auto-Increment whenever there is a change to the record.