SOLVED

Microsoft Lists Auto Increment Number Field

%3CLINGO-SUB%20id%3D%22lingo-sub-2211697%22%20slang%3D%22en-US%22%3EMicrosoft%20Lists%20Auto%20Increment%20Number%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2211697%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20MS%20Lists%20within%20MS%20Teams%20for%20the%201st%20time%20today.%20I%20am%20trying%20to%20create%20a%20simple%20issue%20list%20with%202%20columns.%201st%20column%20(ID)%20is%20of%20type%20Number%20and%20the%202nd%20column%20is%20of%20type%20'Multiple%20lines%20of%20text'.%20When%20a%20new%20item%20is%20added%20to%20the%20list%2C%20I%20want%20the%20ID%20column%20to%20auto-increment.%3C%2FP%3E%3CP%3EWhat%20I've%20tried%20is%2C%20using%20the%20'Edit%20column'%20dialog%2C%20I%20checked%20the%20'Use%20calculated%20value'%20checkbox%20and%20in%20the%20'Default%20value'%20field%20I've%20entered%20the%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%20%22ID%22%2B1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20the%20ID%20field%20is%20not%20getting%20populated%20nor%20is%20it%20auto-incrementing.%20Any%20thoughts%20what%20I%20am%20doind%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETom%20McCann%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2211697%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2212881%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%20Auto%20Increment%20Number%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2212881%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F985179%22%20target%3D%22_blank%22%3E%40tmc_legrand%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEach%20list%20already%20has%20a%20default%20ID%20column%2C%20which%20is%20auto-incrementing.%20Could%20you%20use%20that%20as%20an%20ID%20column%20for%20your%20solution%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20add%20it%20to%20your%20view%20from%20Show%2Fhide%20columns%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Matti_Paukkonen_0-1615869404146.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F264178i471AE18A8164C558%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Matti_Paukkonen_0-1615869404146.png%22%20alt%3D%22Matti_Paukkonen_0-1615869404146.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2213875%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%20Auto%20Increment%20Number%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2213875%22%20slang%3D%22en-US%22%3EThank%20you!%20I%20was%20not%20aware%20of%20that%20field.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2594958%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%20Auto%20Increment%20Number%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2594958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774111%22%20target%3D%22_blank%22%3E%40Matti_Paukkonen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20the%20same%20unique%20ID%20available%20within%20the%20MS%20Teams%20Task%20List%2FTask%20Board%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20could%20not%20see%20a%20way%20to%20add%2Fremove%20columns-%20I%20only%20see%20Task%20Title%2C%20Assigned%20To%2C%20Priority%2C%20Due%2C%20and%20Bucket%20columns%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2658789%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%20Auto%20Increment%20Number%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2658789%22%20slang%3D%22en-US%22%3EIt%20is%20not%20possible%20to%20modify%20Teams%20Tasks%20App%2FPlanner%20task%20board%20columns.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2659549%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%20Auto%20Increment%20Number%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2659549%22%20slang%3D%22en-US%22%3ECareful%20with%20using%20the%20ID%20column%20in%20a%20SPO%20list%20for%20the%20purpose%20you%20are%20explaining%20here.%20While%20it's%20true%20the%20ID%20column%20autoincrements%20its%20value%20for%20every%20new%20record%20created%2C%20it's%20also%20true%20the%20ID%20column%20is%20not%20aware%20if%20there%20is%20deletion%20of%20a%20previous%20record%20and%20you%20cannot%20reuse%20the%20ID%20of%20a%20deleted%20record%3C%2FLINGO-BODY%3E
Occasional Contributor

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

5 Replies
best response confirmed by tmc_legrand (Occasional Contributor)
Solution

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

Matti_Paukkonen_0-1615869404146.png

 

 

 

Thank you! I was not aware of that field.

@Matti_Paukkonen 

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 columns

Thanks!

 

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
www.000webhost.com