How to autofill incrementally?

%3CLINGO-SUB%20id%3D%22lingo-sub-1559105%22%20slang%3D%22en-US%22%3EHow%20to%20autofill%20incrementally%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559105%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20the%20best%20way%20to%20automate%20the%20entry%20of%20new%20rows%20in%20a%20SharePoint%20list%20in%20SharePoint%20Online%2C%20where%20the%20ID%20column%20contains%20new%20values%20of%20a%20given%20range%20X%20-%20Y%20and%20each%20new%20entry%20in%20the%20list%20needs%20the%20ID%20value%20incremented%20by%201%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1559105%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-1561070%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20autofill%20incrementally%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746226%22%20target%3D%22_blank%22%3E%40austin40%3C%2FA%3E%26nbsp%3Byou%20can't%20set%20what%20the%20ID%20will%20be%3B%20SharePoint%20will%20assign%20the%20number%20and%20you%20can%20neither%20change%20it%20nor%20manipulate%20it%20in%20any%20way.%20This%20is%20a%20safety%20measure%20so%20that%20no%202%20IDs%20can%20ever%20be%20the%20same.%20You%20would%20need%20to%20have%20another%20column%20for%20%22your%22%20ID.%20Then%20what%20we%20do%20is%20to%20have%20a%20flow%20in%20Power%20Automate%20with%20a%20trigger%20of%20%3CEM%3EWhen%20an%20item%20is%20created%3C%2FEM%3E.%20This%20looks%20at%20a%20separate%20%22increment%22%20list%2C%20gets%20the%20next%20increment%20number%20(there's%20only%20ever%201%20item%20in%20that%20increment%20list)%2C%20adds%20that%20number%20into%20the%20main%20list%20then%20adds%201%20to%20the%20increment%20list%20ready%20for%20the%20next%20item.%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563742%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20autofill%20incrementally%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563742%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3BThe%20ID%20column%20is%20actually%20just%20a%20regular%20text%20column%20without%20those%20restrictions.%20Is%20it%20possible%20to%20do%20this%20in%20a%20way%20where%20new%20ID's%20are%20added%20in%20a%20random%20order%20with%20a%20specified%20range%20X%20through%20Y%20where%20Y%20is%20(Y-X)%20numbers%20away%20from%20X%2C%20but%20X%20can%20be%20any%20random%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574030%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20autofill%20incrementally%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574030%22%20slang%3D%22en-US%22%3EYou%20answered%20a%20different%20question%20than%20the%20one%20that%20I%20asked.%20Could%20you%20help%20me%20please%3F%3C%2FLINGO-BODY%3E
New Contributor

What is the best way to automate the entry of new rows in a SharePoint list in SharePoint Online, where the ID column contains new values of a given range X - Y and each new entry in the list needs the ID value incremented by 1?

3 Replies

@austin40 you can't set what the ID will be; SharePoint will assign the number and you can neither change it nor manipulate it in any way. This is a safety measure so that no 2 IDs can ever be the same. You would need to have another column for "your" ID. Then what we do is to have a flow in Power Automate with a trigger of When an item is created. This looks at a separate "increment" list, gets the next increment number (there's only ever 1 item in that increment list), adds that number into the main list then adds 1 to the increment list ready for the next item.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott The ID column is actually just a regular text column without those restrictions. Is it possible to do this in a way where new ID's are added in a random order with a specified range X through Y where Y is (Y-X) numbers away from X, but X can be any random number.

You answered a different question than the one that I asked. Could you help me please?