How can I recover a corrupted Sharepoint list?

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 Excel

What 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. 😀