SOLVED

Rest list ID to 0

%3CLINGO-SUB%20id%3D%22lingo-sub-1563504%22%20slang%3D%22en-US%22%3ERest%20list%20ID%20to%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563504%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20a%20modern%20sharepoint%20team%20site%2C%20how%20do%20you%20reset%20a%20list%20ID%20value%20back%20to%200.%20During%20development%20i%20have%20created%20a%20number%20of%20records%20which%20i%20now%20need%20to%20delete%20and%20start%20again%20from%200.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1563504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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.

5 Replies
best response confirmed by Stuart_Jolley (Occasional 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. 

@Jacques Alexandre Bergeron 

 

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