Overcoming Power Apps delegation with Power Automate

Canvas apps offer a wide range of features. Among them, we can highlight the ability to connect to multiple data sources simultaneously for a given application.

Delegation is a term used in canvas apps, which means that the platform is delegating the data processing to the data source rather than doing it in the application itself. We need to acknowledge this if we want to have applications with quick response times.

Querying data uses memory and processing power; the less of these our application uses, the better. That's why we need to use data sources that support delegation. To get more insight on this matter, please refer to https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Another critical aspect is the network bandwidth used when getting data. By default, Power Apps limits the number of records retrieved to 500. Even if your data source supports delegation, getting more items than...