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 …

PowerApps: Replace the Defaults() function to improve performance

The Deafults() function is often used inside a Patch() function to create new records, with this sort of syntax: Patch( MyTable, Defaults(MyTable), {TextColumn: “Hello world”, NumberColumn: 123.45}) Performance of this expression is slow because every time the Defaults() function is invoked, there is a call to the server where MyTable is stored.  The above expression …

PowerApps 101: Create your own forms

Quite often you want to customise the out-of-the-box forms that PowerApps provides, for example to: Collect user input over more than one screen Implement cascading dropdowns or combo boxes Include business logic in the forms Combine user input with other data