Sharepoint Online List ID Starting Point

[junganthony]

Hi All,

I have a Sharepoint Online List that I would like to change the starting value, instead of just having it start at 1. Is there a way to do so? Is there anyway to change the settings of that column at all? It seems to be the only column that doesn't have a settings menu that I can go in and tinker.

Thanks.

[RandyHayes · Accepted solution]

@junganthony 

There is no way to change the properties of the ID column like that.

I would recommend using your own column with the ID that you want.  This will also perhaps come in handy in the future when your list grows and delegation becomes a problem as you will have more delegable choices for your own ID column rather than the built-in one.

If you have a particular logic in mind for it, you could use Flow or WorkFlow to populate your column with the proper value.  If your list will only be altered by a PowerApp, then you could also put that logic directly into your app.

I hope this is clear and helpful for you.

[v-yuxima-msft]

Hi @junganthony 

As @RandyHayes  says, ID is generated automatically by system, you can't change it.

And if you eant to create another type of  Auto-Incrementing Number, please reference 

https://www.epmpartners.com.au/blog/how-to-create-an-auto-incrementing-number-field-in-a-sharepoint-...

And you can also post here:

https://techcommunity.microsoft.com/t5/SharePoint/ct-p/SharePoint

Hope this could be helpful.

Best Regards.

Yumia