To interact with relational databases like SQL Server, I think that standard data manipulation language (DML) function must be added in Power Apps to interact efficiently with databases. Instead of offering only "Patch", a kind of MERGE, all other DML function must be offered:
- INSERT
- UPDATE
- DELETE
- SELECT
- MERGE.
Actually, to do efficient insert in an SQL Server database, we have to send JSON to PowerAutomate and call a Store Proc with the JSON as parameters. This is really cumbersome. The PowerApps way of doing this is by using "Patch" but this is really inefficient.
(https://powerusers.microsoft.com/t5/Building-Power-Apps/Inserting-records-from-PowerApps-to-SQL-Serv...)
timl
on:
TImer control in Custom Page
NHelgren
on:
test
on:
Custom Pages - JS NavigateTo parameters