Let’s say that you have tens of thousands of rows of sales and want to display for any given day:
- the year-to-date total sales amount
- the individual sales of the day
- the details for all of the day’s customers
Normally this would require three separate operations in PowerApps, and the first may not even work since Sum() is not yet delegated. With the approach I outline in this post, this can be done in one operation and without any delegation issues. For this we leverage Flow. Continue reading “PowerApps: Concurrently returning variables and multiple arrays from Azure SQL Database”