Custom ID for SP List

%3CLINGO-SUB%20id%3D%22lingo-sub-1130919%22%20slang%3D%22en-US%22%3ECustom%20ID%20for%20SP%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130919%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20SP%20list%20with%20a%20unique%20identifier%2C%20I%20know%20each%20new%20item%20has%20a%20unique%20%22ID%22%20field%20associated%20with%20it%2C%20incrementally%20increasing.%20What%20I%20am%20looking%20to%20do%20is%20have%20each%20new%20item%20with%20the%20following%20Format%20%22%3CSPAN%3ETGT002001-03%22%20Where%20the%20%22TGT00%22%20part%20is%20fixed%2C%20the%20%2220%22refers%20to%20the%20year%2C%20%2201%22%20refers%26nbsp%3B%20to%20the%20month%20(January)%20and%20the%20%22-03%22%20refers%20to%20the%20instance%20in%20that%20month%2C%20i.e.%20it%20is%20the%203rd%20item%20created%20in%20January%20of%202020.%20Is%20this%20possible%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1130919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1131321%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20ID%20for%20SP%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1131321%22%20slang%3D%22en-US%22%3EYou%20should%20be%20able%20to%20do%20that%20with%20a%20calculated%20field%20and%20some%20formulas%20there...but%20bear%20in%20mind%20that%20calculated%20fields%20are%20very%20limited%20too...the%20other%20alternaytive%20could%20be%20to%20set%20the%20field%20using%20a%20PowerAutomate%20Flow%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1132928%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20ID%20for%20SP%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1132928%22%20slang%3D%22en-US%22%3ECalculated%20field%20won't%20work%20for%20this.%20User%20flow%20to%20generate%20the%20custom%20id%20field%3C%2FLINGO-BODY%3E
Regular Visitor

I am trying to create a SP list with a unique identifier, I know each new item has a unique "ID" field associated with it, incrementally increasing. What I am looking to do is have each new item with the following Format "TGT002001-03" Where the "TGT00" part is fixed, the "20"refers to the year, "01" refers  to the month (January) and the "-03" refers to the instance in that month, i.e. it is the 3rd item created in January of 2020. Is this possible?

2 Replies
You should be able to do that with a calculated field and some formulas there...but bear in mind that calculated fields are very limited too...the other alternaytive could be to set the field using a PowerAutomate Flow
Calculated field won't work for this. User flow to generate the custom id field