Answered

SharePoint list form stops working with Excel-imported data

(0) Share

Report

Posted on by duncanpryde

I've been working on a SharePoint list PowerApp that works in mutiple languages. In order to accomplish this I've imported data from Excel for the translations.

Initially, it works fine, but after a while the app stops loading data. What I mean by this is that I can publish the app ok, and click on a list item to view/edit. But after a few clicks on the item the entire form stops loading data from the list and I get the error "No data source provided". Refreshing the page doesn't work.
Sometimes a re-publish kicks it back into life, sometimes not. Sometimes removing and re-adding the Excel data works, sometimes not. Reloading the list and app in a new private browsing session usually doesn't work.

It's impossible to debug, as it's sporadic in nature, and when it stops loading the data all code in the app ceases to work. The only things that display on the form are static elements with no code. The logo image I uploaded to the app doesn't even show.

So, has anyone else encountered a similar issue? And if so, was it resolved somehow? Getting desperate here!

Duncan

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @duncanpryde ,

Could you please share a bit more about the Excel table in your app? Is it stored in your cloud storage (e.g. OneDrive)?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please consider set the OnNew property of the SharePointIntegration control to following:

Refresh('SPList'); NewForm(SharePointForm1)

set the OnEdit property of the SharePointIntegration control to following:

Refresh('SPList'); EditForm(SharePointForm1)

set the OnView property of the SharePointIntegration control to following:

Refresh('SPList'); ViewForm(SharePointForm1)

then re-publish your app, then check if the issue is solved.

In addition, please also consider clear cache of your browser, remove the custom form from your SP List, then re-add new one for it, check if the issue is solved.

Note: Please also make sure the Network on your side is in good condition.

Best regards,
duncanpryde 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kris

Thank you for your reply. As it happens, after extensive research I'd found the idea of adding the Refresh to the code as a solution to another issue I was having with the form retaining old version of the data, and thought it might solve this issue too. I tried it yesterday and the form is still working today, so I think that must have been the problem.

So for anyone else who gets the same error, even under different circumstances, it looks like this is the solution.

Thank you again for looking into this.

Duncan