Powerapps delegation limit. Aug 2, 2023 · Understanding the Data Row Limit for Power Apps Delegation The number of records Power Apps retrieves for non-delegable queries is determined by the "data row limit" setting, it defaults to 500 and can be set to a maximum of 2000. . Apr 7, 2021 · All the delegation warnings related to the SP lists which contains (or will contain) more than 2000 should be resolved by adjusting the formulas. Changing the limit Power Apps limits the result size to 500 records to keep your app performing well. Aug 26, 2025 · When a query is nondelegable, Power Apps gets the first 500 records from the data source and then runs the actions in the query. You can increase this limit to 2,000 records. Dec 31, 2024 · I’ve been fortunate enough to be able to work with PowerApps on a large enterprise scale project and I feel the biggest consideration that needs to be taken into account is a design decision made by the PowerApps team called delegation, and the 500 record limit that is associated with it. May 5, 2021 · In this article, we will discuss PowerApps delegation, delegable data sources, and functions, and how to overcome the delegation warning in PowerApps? Jun 18, 2025 · In Power Apps, when you're working with large data sources like SharePoint, Dataverse, or SQL, there's a default limit on how many records you can retrieve — usually 500 to 2000 items (based on This SharePoint delegation cheat sheet is the quickest way to check which Power Apps functions support delegation. If this reply helped you to solve the issue, please mark the post as Accepted Solution. When you get a delegation warning like this: “the Filter part of this formula may not work correctly on large data sets”, change your code to only use functions found on this page. rbujte dznyy hunv psigz cdncwm bxrthr kyfl phdzk shk xmu