Forum Discussion

Stuart_Jolley's avatar
Stuart_Jolley
Copper Contributor
Aug 03, 2020

Rest list ID to 0

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.

  • 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.

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    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.

  • jab365cloud's avatar
    jab365cloud
    Steel Contributor

    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. 

    • Jorge_santos1972's avatar
      Jorge_santos1972
      Copper Contributor

      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!

      • RobElliott's avatar
        RobElliott
        Silver Contributor
        You just need to change the data source in Power Apps to the new list.

Resources