Showing results for 
Search instead for 
Did you mean: 

Add data manipulation (DML) functions for SQL Server connector

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:

  • 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.


Status: New