If you try to use a Filter statement where a Boolean value is not equal to something you will see that it issues a delegation warning. The following screenshot shows an example. But if I change the formula to the Boolean being equal to true then the delegation warning goes away and the...
if the function is not delegable. The warning message states that: “Delegation warning: The “filter” part of this formula might not work correctly on large data sets.”
For operations that can't be delegated, Power Apps will give a warning at authoring time and operate on only the first 500 records of the data source. See the [Filter function](functions/function-filter-lookup.md) article for more details about delegation. 1. **Excel data must be ...
Here’s an example to help you understand delegation. You have a list of 5,000 projects stored in SharePoint. The ProjectStatus column stores the values Active or Inactive. Half (2,500) of the records are set to each of these values. You could show the list in a gallery and filter ...