SOLVED

Create a column that automatically assigns number value from 1-50, and resets when list is cleared

%3CLINGO-SUB%20id%3D%22lingo-sub-2108422%22%20slang%3D%22en-US%22%3ECreate%20a%20column%20that%20automatically%20assigns%20number%20value%20from%201-50%2C%20and%20resets%20when%20list%20is%20cleared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108422%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20find%20out%20if%20there%20is%20a%20way%20to%20basically%20replicate%20the%20built-in%20ID%20column%20in%20SP.%20The%20reason%20the%20ID%20column%20isn't%20working%20for%20us%20is%20that%20once%20you%20clear%20the%20list%2C%20it%20won't%20allow%20for%20the%20IDs%20to%20start%20back%20at%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20need%20the%20column%20to%20number%20items%20starting%20at%201%20and%20up%20to%2050%20as%20that%20is%20the%20maximum%20amount%20of%20these%20items%20that%20are%20active%20at%20a%20time.%20Once%20the%20items%20have%20been%20completed%2C%20they%20are%20cleared%20out%20of%20the%20list.%20At%20that%20point%2C%20we%20would%20need%20the%20new%20batch%20of%20items%20to%20be%20numbered%2C%20starting%20over%20at%201%20again%20and%20going%20up%20to%2050.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20challenge%20is%20that%20we%20currently%20do%20not%20have%20access%20to%20Power%20Automate.%20Is%20there%20a%20way%20to%20accomplish%20this%20without%20Power%20Automate%20or%20do%20we%20have%20to%20manually%20number%20these%20items%20as%20we%20add%20them%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2108422%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-2114119%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20column%20that%20automatically%20assigns%20number%20value%20from%201-50%2C%20and%20resets%20when%20list%20is%20clear%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2114119%22%20slang%3D%22en-US%22%3E%3CP%3EI%20suspected%20as%20much%2C%20but%20wanted%20to%20double%20check%20before%20saying%20no.%26nbsp%3B%20Appreciate%20the%20response!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2108465%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20column%20that%20automatically%20assigns%20number%20value%20from%201-50%2C%20and%20resets%20when%20list%20is%20clear%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108465%22%20slang%3D%22en-US%22%3EWithout%20Power%20Automate%20or%20some%20custom%20Dev%20I%20think%20it's%20not%20possible%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

 

I'm trying to find out if there is a way to basically replicate the built-in ID column in SP. The reason the ID column isn't working for us is that once you clear the list, it won't allow for the IDs to start back at 1.

 

We need the column to number items starting at 1 and up to 50 as that is the maximum amount of these items that are active at a time. Once the items have been completed, they are cleared out of the list. At that point, we would need the new batch of items to be numbered, starting over at 1 again and going up to 50.

 

The challenge is that we currently do not have access to Power Automate. Is there a way to accomplish this without Power Automate or do we have to manually number these items as we add them?

 

Thank you!

2 Replies
best response confirmed by leonsig93 (New Contributor)
Solution
Without Power Automate or some custom Dev I think it's not possible

I suspected as much, but wanted to double check before saying no.  Appreciate the response! 

 

@Juan Carlos González Martín