Forum Discussion

OaklandMike's avatar
OaklandMike
Copper Contributor
May 05, 2020

Something went wrong trying to create a new list based on an existing list

Hi. I'm trying to create a new list based on an existing list, but every time I try it, I get the error message that something went wrong and to try again later. I've checked some of the other help resources and the only possible error is in setting the list to not need content approval. That's set correctly, so I'm stuck.

  • Chunai's avatar
    Chunai
    Copper Contributor

    OaklandMike wish it said what is wrong, which column is need to be fixed. Just a blank "something went wrong" is not helping, because I have 220 columns!

  • Vikram_Samal's avatar
    Vikram_Samal
    Steel Contributor

    OaklandMike This issue can be due multiple reasons so to make sure we narrow down the issue first try the below steps and then once we have some unique traits we cans see what are the alternatives

     

    1. Try creating a new list from an existing list which uses with common data types  such as single line of text, date, people picker. If you succeed with that then find our what are other type data type you are using there which might cause some error.

     

    2. Let the issue is with the data types we need to resolve that first and then we need to see either manged metadata or some look column is causing this.

     

    3. If any of the option is not working I can suggest the CREATION FROM LIST TEMPLATE and save the parent list as template and then create your destination list which is little bit more proven and seen more summers than the newer approach.

     

    I will be eager to see what is the outcome. 

    • Fixxser2's avatar
      Fixxser2
      Brass Contributor

      Vikram_Samal 

      I have a similar problem.  Customer of mine is editing a SharePoint site created by Teams.  He added a custom list under General.  All is working fine.  But he wants to add the same template or list to another Teams SharePoint site under General.  So he goes to create a list using from the good one he made and the error comes up "Something went wrong. Please try again later".  I don't know how to fix this.

  • metalhead971's avatar
    metalhead971
    Copper Contributor

    To anyone that has this problem, I was getting the exact same error on my end, and I was able to fix it. 

     

    My issue was that I had a column in my original list called "id". What I did not realize is that SharePoint automatically creates every list with a HIDDEN column named "ID", so on the back-end, my "id" column was actually being renamed by SharePoint to "id0". This seems to work fine when creating the list from scratch, but when you try to create a new list from a list that has an "id" column, you will get the error above. The name you give to the column is NOT the same name that SharePoint uses to refer to that column.

     

    I tested by deleting the "id" column from my original list, without deleting any other columns, and I was then able to create a new list from that original list without the same error. I added a similar column named "RecordId" instead, and tested again, and I was able to create the new list with this column name as well. I even renamed "RecordId" back to "Id", and I was still able to create the new list without error. 

    If you're getting the error "something went wrong" when trying to create a new list from an existing list, review the column names and make sure you don't have any columns with names that match reserved column names in SharePoint. If you do, don't bother renaming them, just add a new column with a different name and copy the data to that column, then delete the old column and try again. 

Resources