Calculated Count

%3CLINGO-SUB%20id%3D%22lingo-sub-1218582%22%20slang%3D%22en-US%22%3ECalculated%20Count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218582%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20it%20is%20possible%20to%20have%20a%20count%20similar%20to%20the%20ID%20column%20but%20adding%20the%20number%203200.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20reason%20why%20I%20want%20to%20do%20this%20is%20because%20we%20currently%20have%203200%20records%20on%20file%2C%20and%20we%20do%20not%20want%20to%20have%20a%20mix%20up%20when%20these%20numbers%20repeat.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20our%20ID%20column%20start%20at%203201%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1218582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1218651%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20Count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1218651%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F577839%22%20target%3D%22_blank%22%3E%40KiewitEmployee%3C%2FA%3E%26nbsp%3Bthe%20ID%20column%20can't%20start%20at%203201%20unless%20you%20create%203200%20items%20fist%20and%20then%20delete%20them..%20But%20you%20could%20have%20a%20number%20column%20in%20your%20SharePoint%20list.%20Then%20when%20a%20new%20item%20is%20created%20in%20your%20list%20use%20a%20flow%20in%20Power%20Automate%20to%20get%20the%20next%20increment%20number%20from%20another%20list%20(which%20only%20ever%20has%20that%201%20item).%20That%20increment%20number%20could%20start%20at%203201.%20That%20flow%20would%20add%20the%20next%20increment%20number%20into%20the%20column%20in%20the%20main%20list%20and%20then%20add%201%20to%20the%20next%20increment%20number%20in%20the%20other%20list%20ready%20for%20the%20next%20item%20to%20be%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

 

I was wondering if it is possible to have a count similar to the ID column but adding the number 3200.

The reason why I want to do this is because we currently have 3200 records on file, and we do not want to have a mix up when these numbers repeat. 

Can our ID column start at 3201?

 

1 Reply
Highlighted

@KiewitEmployee the ID column can't start at 3201 unless you create 3200 items fist and then delete them.. But you could have a number column in your SharePoint list. Then when a new item is created in your list use a flow in Power Automate to get the next increment number from another list (which only ever has that 1 item). That increment number could start at 3201. That flow would add the next increment number into the column in the main list and then add 1 to the next increment number in the other list ready for the next item to be created.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User