How Can Power Apps Performance Be Improved When Working With Large Datasets?

When a Power Apps application becomes slow with large datasets, the first thing I would investigate is **how much data is being transferred to the client** and whether the query is being delegated to the data source. The biggest performance improvement usually comes from designing the query so that Dataverse, SQL Server, or the underlying data source performs the filtering and sorting rather than downloading a large dataset and processing it inside the app. Microsoft specifically recommends delegation and keeping data payloads small for scalable canvas apps. For example, avoid patterns such as loading thousands of records with `ClearCollect()` and then filtering the collection. Prefer a delegable query directly against the data source: ```powerfx Filter( Accounts, StartsWith(Name, txtSearch.Text) ) ``` Also consider: * Avoid loading entire tables when the user needs only a subset. * Select only the columns required by the screen. * Check delegation warnings carefully. * Avoid unnecessary `ClearCollect()` operations for large datasets. * Use server-side filtering and aggregation where appropriate. * Review Dataverse query design and indexes where applicable. * Use Power Apps Monitor to identify slow data calls. * Design galleries to retrieve data progressively rather than loading everything at startup. A particularly important point for beginners: increasing the nondelegable row limit is **not a real scalability solution**. Microsoft notes that nondelegable queries can process only a limited number of records locally, which can produce incomplete or incorrect results on large datasets. For enterprise applications, I would therefore think in this order: **Data volume → Delegation → Query design → Payload size → Network calls → Server-side processing → Client-side rendering** If an application is slow with 50,000 records, don't start by adding more collections or timers. First ask: **why is the app trying to bring those records to the client at all?** What Power Apps performance issue have you encountered most often—delegation, slow Dataverse queries, large collections, or excessive API calls?