Tag: Azure SQL Database

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

PowerApps: Repeating section with editing

In this post I will build a repeating section in a simple PowerApp.  You will be able to select an order and view/edit its details in a repeating section.

As a data source I will be using the AdventureWorksLT database on Azure SQL Database, but this will work with any data source such as SharePoint or CDS as long as you have two tables: OrderHeader and OrderDetail.  OrderDetail should have a column pointing to a row of OrderHeader. Continue reading “PowerApps: Repeating section with editing”

Posted on

PowerApps and Azure SQL Database: Current issues and how to work around them

Azure SQL Database is a very powerful tool, but currently there are limitations to its use in conjunction with PowerApps.  I would appreciate any feedback on this list so that it can be kept up to date.  Please note that all work-arounds are temporary, since sooner or later these limitations should be resolved by Microsoft. Continue reading “PowerApps and Azure SQL Database: Current issues and how to work around them”