Tag: Microsoft Flow

Posted on

PowerApps: Concurrently returning variables and multiple arrays from Azure SQL Database

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”

Posted on

Microsoft Flow: Automatically uploading foreign exchange rates daily from the European Central Bank

Many applications require reference foreign exchange rates to be updated daily and/or a table of historical forex rates to be maintained.  These are typically accounting, expense reporting, portfolio tracking, e-commerce applications.  Microsoft Flow is perfect for this, and the data can be stored almost anywhere.

Continue reading “Microsoft Flow: Automatically uploading foreign exchange rates daily from the European Central Bank”