Hi@samooo,
Based on the issue that you mentioned, do you want the updates to be fed back to the data source in a timely manner?
Could you please tell that if the records in your excel table exceed 2000?
Generally, if you have a huge data set, PowerApps may have slow performance.
Also, Excel on OneDrive have a poor performance when updating from PowerApps is an known issue.
If you add large codes within your app, it would consume large CPU resources, memory, and network bandwidth, so your app would execute slowly.
Actually, there are many reasons that an app can be slow to load, slow to respond, and slow to write to data sources. The common reasons as below:
- A large number of controls added within your app
- Shaping expressions (i.e. Filter or Search) that contain clauses that require frequent server calls
- Shaping expressions that are not delegated
- Use of inherently slow data sources such as Excel on OneDrive
If you want to check the updates from the Excel table, yes, it spends much more time to get the updates.
However, if you could accept it in PowerApps which means that check the updates directly in a Gallery of DataTable, the performance will be better.
Add a Gallery and set the Items as your Excel table name.
As an alternative solution, you could also change your data source if the workload is not too heavy. SharePoint list or on-premise SQL Server and the data gateway.
Hope it could help.
Regards,
Qi
