Power Platform Community Forum Thread Details

I have a canvas app with tens of dropdown controls on one screen. They form a "grid" where dropdowns' selected values come from collections that are a similar "shape" like the grid. So the collections reflect the shape of the dropdowns' selected values. When you press a Populate button, the grid will be "filled" with certain dropdown values which come from the collections.

Also, selected dropdown values have certain indexes which are summed to get certain overall indicator values.

With all of these functions, when you press Populate, a time spinner will appear. And when you after populating change dropdown values manually, the dropdown controls are "stuck" couple of seconds because the functions are counting every change in the background.

I wonder, is there any ways to reduce the load time? I have tried to change some of the settings behind Settings in the app like Delayed load: yes; but these seem not to have an impact.

Categories:

Building Power Apps

It's difficult to give you specific advice without a deep dive into your app, but it sounds like your app is making multiple queries to populate dropdowns and then generate collections.

A few tips to help performance:

Make sure all queries are delegable to the datasource
If a query is being made multiple times on a segment of your data that does not change rapidly, consider loading that into a variable or collection and re-running that query only when necessary. Your dropdown choices might fit into this category
Analyze which data can be queried earlier (before it is needed for your grid) through the OnStart property for the app, or the OnVisible property for the screen

Hope that helps,

Bryan