Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft PowerApps _ Save Data On Powerapps On Premise Gateway

Posted by: carlo Sep 13 2019, 05:20 AM

Hi

I have connect in pwa gataway SQL database.. to save records which command to use collect .. forall or patch???


thank

Carlo

Posted by: RobKoelmans Sep 13 2019, 06:29 AM

It's much better to work 3-tier between PA and SQL-server by Flow (for a whole collection of reasons).
Flow converts a collection automatically to JSON and you can write the JSON variable directly to SQL with Exec Query embedded in a statement that uses OpenJSON

Like: Insert into table1 (col1, col2) SELECT col1,col2 FROM OpenJson(@json);

Rob