Power Platform Community Forum Thread Details

Hello everyone,

A PowerApp has been created to store data from SharePoint lists, and Dataverse tables. Unfortunately due to the amount of data the app has become very slow when trying to load. There have also been issues when trying to edit within the app. A point to note is that the "Data row limit" has been set to max that is 2000 to ensure the recent records being added within the tables and lists will show up in the app. If anybody can help guide how to speed up the app, that would be greatly appreciated. Thank you.

Categories:

Building Power Apps

Hi,

This can be caused by some issues,

To limit the number of controls on the screen, as the time taken to render the page in PowerApps screen has a direct relation with the number of controls on the screen, To use components rather than controls whenever possible, as components can be reused across multiple screens and can help reduce the number of controls on each screen.
To uses the Clear Collect function to cache data locally if it doesn't change during the user session. This can help reduce the amount of time an app needs to load data and improve its performance.
It's recommended to monitor the OData requests at the client side and tune the data row limit for non-delegable queries and the number of columns in the list.
It's recommended to monitor the app's behavior by using the Power Apps Monitor and check what data calls are taking a long time and how many data calls trigger. It's also recommended to leverage cache mechanism and optimize data calls to reduce the number of data calls per user.
Apply filters and sorting on the data source level whenever feasible. This reduces the amount of data transferred to the app, improving loading times and overall performance.
If your app includes images, make sure they are properly optimized and compressed to reduce their file size. Large image files can significantly impact loading times.

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.