Power Platform Community Forum Thread Details

Hi all,

I have an issue with SharePoint List as a data source, that I still could´t find an efficient solution. Following the details:

The Background:

I have built 4-5 Apps connected with a data source (aka "MasterData") located in SharePoint lists.
"MasterData" has 7000 rows and originally was exported from an Excel file to SP Lists
The Apps are working as expected, without any specific problem.

The Issue:

I need to update "MasterData" every month. I receive the information in an excel file that has the same structure, but the excel has new rows, some rows removed, and also some rows with internal changes.
As you can imagine, to track the changes in the new version of "MasterData" is almost impossible, so my approach is to replace the old MasterData SP list for a new one with exactly the same structure/name (URL path) with the new information.
I tried to:
1. Remove the old "MasterData" SP list
2. Export from the new excel to SP List, the updated "MasterData" SP list. With exactly the same name and same structure.
3. However, when I refresh an App, it cant find "MasterData" SP list.
4. If I delete the updated "MasterData" SP list and restore the old "MasterData" from the recycle bin, the connection works again.

The BIG question:

Which is the recommended way to deal with this situation?

Or in other words: Which is the best way to deal with routine massive updates in SharePoint Lists without loosing the connection from the Apps/Dashboards?

Manually reconnecting the Apps to the new "MasterData" SP lists is not an option, considering that in some months, I will have 10+Apps (plus Power BI dashboards) reading this SP List.

Thanks in advance for your help!

Categories:

Building Power Apps

Hi @Seba1 ,

I will plant a few thoughts here.

An Excel file in OneDrive is a valid data source for SharePoint. The issue is your comment

Excel has new rows, some rows removed, and also some rows with internal changes.

I manage a similar process with a large quantity of Excel records downloaded from a customer website and then updated in an Excel file in OneDrive that is then referenced in PowerApps.

I have similar issues to you in that the customer is a very large entity and different regions tend to present the data in slightly different ways. The key here is that we have a master template into which the data is pasted and then pasted again into the OneDrive file. This is the only way we have found to manage it - and it works.

In your case, if you adopted this method, you could do a ForAll Patch and update the relevant fields in SharePoint.

Please click Accept as solution 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 Thumbs Up.