Press "Enter" to skip to content

Tag: Low-Code

How to Handle Complex Calculations with Power Apps, Flow and SQL

Published October 31, 2020
How to Handle Complex Calculations with Power Apps, Flow and SQL

Power Apps can deal with basic anthemics. But unless your requirement is to build a four function calculator, you will need to incorporate few other pieces from Microsoft’s arsenal. In the following solution, I will calculate linear regression in Power Apps with user defined axis. This will be achieved with the following combination: Power Apps: Handle user inputs and shows…

Continue ReadingHow to Handle Complex Calculations with Power Apps, Flow and SQL

Low-CodePower Apps

Business LogicCalculationFlowLinear RegressionLow-CodePerformancePower AppsPower AutomateSQLStored Procedure

Improve Power Apps to SQL Patch Performance

Published October 10, 2020
Improve Power Apps to SQL Patch Performance

For my use case, I had to: 1. Load a SQL table/view to a collection 2. Record user updates in collection 3. Insert updated records to SQL The challenge I faced was the slow performance of ForAll and Patch commands when used with SQL. This is the standard method outlined in Power Apps reference documentation, but I couldn’t get it…

Continue ReadingImprove Power Apps to SQL Patch Performance

Low-CodePerformance TuningPower Apps

Batch PatchLow-CodePerformancePower AppsPower AutomateSQL