SOLVED

Rest list ID to 0

Copper Contributor

In a modern sharepoint team site, how do you reset a list ID value back to 0. During development i have created a number of records which i now need to delete and start again from 0.

8 Replies
best response confirmed by Stuart_Jolley (Copper Contributor)
Solution

@Stuart_Jolley It's not possible to re-set the ID of a list. Once you've got the list created with its views and you've tested it then go to Site contents and click +New and select List. In the screen that appears, select From an existing list. This will then open up your sites and all the lists to which you have access. Select your site and the original list and click Create. A new empty list will be created with all the views from the source list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

@Stuart_Jolley  You can't but with the new list creation release recently you can easily create a new list based on an existing one. If the path should be kept then delete your original list and recreate a new list based on your copy with the appropriate name\path and you will get a brand new list starting with ID 0. 

@jab365cloud 

 

Hi But how would that impact on a PowerApps application that already uses that list?

There as several screens and formulas related to fields in that SharePoint list!!!

 

Would everything be maintained? (formulas and screens) Do i have to recreate everything that relates to that List?

 

Thanks

Jorge

 

PS: I kind of scared of trying to create a new on from "template" and then DELETE the original. If anything goes wrong its weeks of work down the drain!

You just need to change the data source in Power Apps to the new list.

@RobElliott 

 

Thanks a lot Rob! I'll try that.

 

Cheers

Jorge

I have tried that and it does not go smoothly. All the fields, even though the list is an exact duplicate, gets reset!!! All for screens has to be started from practically from scratch.

You would be better off using Power Automate to create an additional columnID and naming it NEW_ID and restarting it at 1 based on the condition needed. Use that for reference in your app and flows.
Thanks @ColumbusOHPowerUser for sharing your testing and insights!
I wanted to perform the same action to "reset" the list, but decided not to.
I wish Microsoft develops this action.
Can you please explain how you would do this? I can create a column and rename, but what would you do in PA to number the items?
1 best response

Accepted Solutions
best response confirmed by Stuart_Jolley (Copper Contributor)
Solution

@Stuart_Jolley It's not possible to re-set the ID of a list. Once you've got the list created with its views and you've tested it then go to Site contents and click +New and select List. In the screen that appears, select From an existing list. This will then open up your sites and all the lists to which you have access. Select your site and the original list and click Create. A new empty list will be created with all the views from the source list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

View solution in original post