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. To support this, the platform applies specific techniques to remain performant. One of these techniques is Delegation.

Delegation is a term used in canvas apps that means the platform delegates the data processing to the data source, rather than doing it in the application itself. As querying data uses memory and processing power, the less our application uses, the better. That’s why using data sources that support delegation is a great idea. To get more insight into this matter, please refer to https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview.

By default, Power Apps limits the number of records retrieved to 500. Even if your data source supports delegation, requesting more items will throw a warning because the platform won...