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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,433 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 153,433 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No