Forum Discussion

amazon439's avatar
amazon439
Copper Contributor
Aug 19, 2021

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

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! 

admin
Lists
SharePoint Online
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Aug 19, 2021

    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)

Resources