Forum Discussion
How to autofill incrementally?
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 t...
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
You answered a different question than the one that I asked. Could you help me please?