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:
- No additional views needed for every use case
- Calculations on SQL side with dynamic parameters given from Power App are more efficient so less Azure Resources used returning results
- Less records returned in the end result which improves Power Apps performance
on:
Allow Users to Add Columns to View in Unified Inte...
on:
Improve Print(): Implement printing of multiple pa...
on:
There is a bug in the RoundUp and RoundDown functi...
Oliviatran
on:
Ability for embedded canvas apps to auto-set heigh...
on:
Enable gallery nested in edit form control
on:
Disable Microsoft Feedback Survey