cancel
Showing results for 
Search instead for 
Did you mean: 

Calling a SQL Function in PowerApps (parameters before views)

When connecting to SQL we can use tables as well as views.
When using delegated queries this can search through thousands of records very fast.

This idea is to make it possible to call a SQL function so we can give dynamic parameters from the Power App before a view is called. This way we can perform complex joins on SQL side to create a complex view which returns as less records as possible.

Advantages:

  1. No additional views needed for every use case
  2. Calculations on SQL side with dynamic parameters given from Power App are more efficient so less Azure Resources used returning results
  3. Less records returned in the end result which improves Power Apps performance
Status: New
Comments
Django
Kudo Kingpin

If you found this page also please vote for: Calling a Stored Procedure in PowerApps
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Calling-a-Stored-Procedure-in-PowerApps/idi-p/1...