Refresh (SQL Database) in my Power App needs to happen once I have made an edit to the database,
This refresh is unavoidable when moving from my gallery-> my edit screen(clearcollect)-> my gallery-> back to edit page which isn't ready in time.
and it does not finish in time, hence appearing to the user as if the change has not been made.
I am using collections where possible. But I can't use collections everywhere (e.g 20,000 rows of data in some tables- and I want the app to be scalabale)
The app looks like it's not working due to this issue.
Hi @jesenavaranjan ,
Could you please share a bit more about your issue?
Do you mean that it take a long time to refresh your SQL Table data source within your app?
Please consider take a try to turn on the "Explicit column selection" option within Advanced settings of App settings of your app, then re-publish your app, check if the issue has been improved.
Also please take a try with the following app performance tips, then check if the issue has been improved:
Thanks for posting in the community @jesenavaranjan - can you review the above reply and update the thread when you have a chance?
Hi @jesenavaranjan .
Some other options:
The only time I have this type of lag is when trying to pull back image-type data from SQL. Changing to Azure Blog Storage can speed things up too.
Good luck and let us know what you land on.
Was a real solution ever figured out?
I'm running into the same issue on my app using On-Prem SQL.
We submit an item, go back into said item from gallery, and it's still displaying the old data.
When we go navigate back and then back into the same item, it loads fine.
Any ideas? This is preventing us from releasing to a wide audience.