cancel
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:

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

Status: New