How to start automatic numbering at 83 in a SharePoint list?

%3CLINGO-SUB%20id%3D%22lingo-sub-2665750%22%20slang%3D%22en-US%22%3EHow%20to%20start%20automatic%20numbering%20at%2083%20in%20a%20SharePoint%20list%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2665750%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20migrated%20an%20Excel%20spreadsheet%20to%20a%20SP%20list%20that%20tracks%20our%20project's%20risks.%26nbsp%3B%20I%20would%20really%20like%20to%20utilize%20the%20ID%23%20automatic%20numbering%20capability%2C%20however%2C%20since%20I%20am%20working%20with%20existing%20risks%2C%20I%20need%20the%20automatic%20numbering%20to%20start%20at%2083%20to%20avoid%20duplicate%20numbers.%26nbsp%3B%20I%20have%20seen%20a%20lot%20of%20info%20on%20how%20to%20create%20unique%20numbering%20patterns%2C%20ie%3A%20AS-001%20but%20I%20have%20not%20been%20able%20to%20find%20anything%20that%20has%20worked%20on%20how%20to%20start%20the%20numbering%20at%20something%20other%20than%201.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20much%20appreciated!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2665750%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi there!

 

I have migrated an Excel spreadsheet to a SP list that tracks our project's risks.  I would really like to utilize the ID# automatic numbering capability, however, since I am working with existing risks, I need the automatic numbering to start at 83 to avoid duplicate numbers.  I have seen a lot of info on how to create unique numbering patterns, ie: AS-001 but I have not been able to find anything that has worked on how to start the numbering at something other than 1.  

 

Any help is much appreciated! 

1 Reply

@amazon439 that's because it's not possible. SharePoint will save an ID for every item and it will start at 1. Always. You can't change this. All you could do is to have a separate number column that starts at 83 and then use a flow in Power Automate to increment it.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)