Functions in Power Apps can be either delegable or non-delegable.
Delegable functions are those that send the query to the data source and process the full dataset. E.g. Filter(), Sort() etc.
Non-delegable functions as those that run inside the app and can process only limited records. E.g. Search(), FirstN()
Delegation depends on three factors:
- Function used
- Operator used
- Data source capability
