Forum Discussion
How can I recover a corrupted Sharepoint list?
The user tried to delete a column and suddenly received this error:
However, trying to navigate back to the list, the page only shows the title. No columns, no "Add item", no Settings "gear" icon, no Recycle Bin.
Is there some way we can retrieve the list? There is no data in the list, it is just the configuration (lookups and rules, etc.) that we need to get back.
3 Replies
Hi DChenIT ,
I had the owner of the list try the first option, but it did not make any difference.
On the second option, we can see the Export button and click on it, but it does not drop down and give us the options. In addition, even the owner cannot see the Settings button. The owner has recreated the List structure and made a backup copy, so we are going ahead that way.
It sounds like the second option would work, but I can't mark it as the solution because we can't get to the menu to try it. Thank you again for your help.
Hi phammar
I do see in your description that you said you don't see the settings gear like so correct?Option 1)
When accessing the list, try adding "ClassicView=1" at the end of the .aspx like so:
https://yourtenant.sharepoint.com/sites/yoursite/Lists/ProfileRequestLog/AllItems.aspx?ClassicView=1
to see if that gets you the settings icon back.Most likely if you're not seeing the gear you dont have sufficient permissions on the list and you can possibly reach out to the owner of the list to see if they can access said settings.
Option 2)
What you can do is use the Export to ExcelWhat you should get is a "query.iqy" file.
Open the .iqy file with notepad and you should see this (SharePointListName is the parameter you want):From there, it should be the same across all tenants but you can plug in that list name like so:
If it is a personal list
https://yourtenant.sharepoint.com/personal/your_email_onmicrosoft_com/_layouts/15/listedit.aspx?List=%7Bbc58ba58-3e05-47ba-bd80-933f57c1e5aa%7D
If it is a list connected to a SharePoint Site:
https://yourtenant.sharepoint.com/sites/yoursite/_layouts/15/.listedit.aspx?List=%7Bbc58ba58-3e05-47ba-bd80-933f57c1e5aa%7D
The main thing here is that you just want that Sitename string to be between %7Bstringhere%7D
Try it out and let me know if it works. 😀Hi DChenIT
Thank you so much for the suggestions. Great idea on exporting to Excel to grab the list parameter and then plugging it into the URL! I tried to get to the list to try your second option but now I can't access the list at all. I will let you know once I can get the owner to try this. Thanks again.
