SOLVED

Generate auto-increment, unique ID dependent of other field in SharePoint/Microsoft Lists

%3CLINGO-SUB%20id%3D%22lingo-sub-3263121%22%20slang%3D%22en-US%22%3EGenerate%20auto-increment%2C%20unique%20ID%20dependent%20of%20other%20field%20in%20SharePoint%2FMicrosoft%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3263121%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20to%20generate%20an%20auto-increment%2C%20unique%20ID%20dependent%20of%20a%20different%20field%20within%20the%20same%20SharePoint%2FMicrosoft%20List.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%2C%20our%20users%20are%20allowed%20to%20assign%20Status%20%3D%20%3CEM%3EVetted%3C%2FEM%3E%2C%20%3CEM%3EPlanning%3C%2FEM%3E%2C%3CEM%3E%20Testing%3C%2FEM%3E%2C%26nbsp%3B%3CEM%3EComplete%3C%2FEM%3E%2C%20OR%20%3CEM%3ECancelled%20%3C%2FEM%3Ewhen%20entering%20an%20item's%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20users%20update%20the%20status%20from%20%22%3CEM%3EVetted%3C%2FEM%3E%22%20(default)%20to%20%22%3CEM%3EPlanning%22%3C%2FEM%3E%20or%20create%20a%20new%20item%20under%20the%20%22%3CEM%3EPlanning%3C%2FEM%3E%22%20status%2C%20we'd%20like%20for%20a%20unique%20ID%20(i.e.%2022-00%23)%20to%20be%20generated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20plan%20to%20use%20this%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsharepoint%2Fauto-increment-number-field-in-a-sharepoint-list%2Fm-p%2F1141477%22%20target%3D%22_blank%22%3Esolution%3C%2FA%3E%20to%20achieve%20the%20generation%20of%20a%20unique%20ID%20(denominated%20%3CEM%3EProject%20Number%3C%2FEM%3E%20in%20screenshot%20below)%2C%20but%20I'm%20still%20missing%20the%20dependency%20portion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20guidance%20it's%20greatly%26nbsp%3Bappreciate%20it%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Unique_ID.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F357440i6B58FFBB568C1FEC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Unique_ID.PNG%22%20alt%3D%22Unique_ID.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3263121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3263157%22%20slang%3D%22en-US%22%3ERe%3A%20Generate%20auto-increment%2C%20unique%20ID%20dependent%20of%20other%20field%20in%20SharePoint%2FMicrosoft%20Lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3263157%22%20slang%3D%22en-US%22%3EHi%20Jenna%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20suggest%20to%20use%20a%20flow%20to%20achieve%20this.%20You%20can%20easily%20create%20one%20that%20triggers%20on%20an%20item%20created%20or%20changed%20event%20and%20use%20for%20instance%20a%20date%20property%20and%20the%20ID%20of%20the%20listitem%20to%20generate%20a%20unique%20ID.%20In%20the%20flow%20you%20can%20also%20build%20a%20check%20to%20verify%20the%20planning%20state.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20this%20helps.%20Let%20me%20know%20if%20you%20need%20more%20info%20to%20achieve%20this.%3C%2FLINGO-BODY%3E
Regular Visitor

Hi there,

 

I'm working to generate an auto-increment, unique ID dependent of a different field within the same SharePoint/Microsoft List.

 

Currently, our users are allowed to assign Status = Vetted, Planning, TestingComplete, OR Cancelled when entering an item's information.

 

When users update the status from "Vetted" (default) to "Planning" or create a new item under the "Planning" status, we'd like for a unique ID (i.e. 22-00#) to be generated.

 

I plan to use this solution to achieve the generation of a unique ID (denominated Project Number in screenshot below), but I'm still missing the dependency portion.

 

Any guidance it's greatly appreciate it :smile:

 

Unique_ID.PNG

1 Reply
best response confirmed by Juan Carlos González Martín (MVP)
Solution
Hi Jenna,

I suggest to use a flow to achieve this. You can easily create one that triggers on an item created or changed event and use for instance a date property and the ID of the listitem to generate a unique ID. In the flow you can also build a check to verify the planning state.

I hope this helps. Let me know if you need more info to achieve this.