Sharepoint list deleted, column names no longer match

(1) Share

Report

Posted on by CU29082315-0

Good evening everyone,

I accidentally deleted a list from Sharepoint and restored it from a backup.

List is called: News

All of my created collections are now complaining that some columns are no longer accessible.

Example:
before: Subject
since restoration: field_3

I have already tried various options:
Clear(GroupedDataNews);
ClearCollect(GroupedDataNews, News);

Unfortunately without success.

Is there a way to solve my problem without all the individual parameters (gallery, label field, etc.)?

Categories:

General Questions

All responses (2)

Answers (0)

WarrenBelz 145,580 on at

Like (0)

Report

Sharepoint list deleted, column names no longer match

@CU29082315-0,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee
WarrenBelz 145,580 on at

Like (0)

Report

Sharepoint list deleted, column names no longer match

Hi @CU29082315-0

I assume your backup was an Excel sheet and you created the list directly from this. If so what you are seeing is an unfortunate product of creating a list this way as the underlying field names are a field_x sequence.

You need to create the list in the native SharePoint interface with the field names and types required, then import the data either with copy/paste into a "grid view" in SharePoint, or if there is a lot of records, it can be done with Power Automate.

Also did you look in the site recycle bin to see if your deleted list was in there (it should be kept for 90 days)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee