Insert/Update data from PowerApps to SQL table

(0) Share

Report

Posted on by prabakar21

Hi,

I am new to PowerApps.

I am developing a Canvas app to insert/update data to SQL server database. For which I create an edit Gallery view to allow the users to make changes , create a collection to capture changes and try to patch it to the database.

I struck with an error " Network Error when using Patch function".

FYI- using Forms I can update the data in database using SubmitForm,(so I have appropriate access to the DB) but the requirement is to update multiple records together.

Thanks in advance for any suggestions/help.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @prabakar21 , Please share the code also. Ideally the code should look like this:
ForAll(collection As var, Patch(DataSource, LookUp(DataSource, ID = var.ID), { column1: var.column1, column2: var.column2 } ) )
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
prabakar21 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ANB ,
Thanks for your quick reply.

Still no luck. Attaching the file. Can you please check.

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @prabakar21, I would request you to send the screenshots of complete code, because I cannot import your app because I dont have SQL db to create connection.

Thanks,
ANB

Was this reply helpful? Yes No
prabakar21 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ANB ,

PFA the screenshots of the code

Was this reply helpful? Yes No
Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @prabakar21, Please check Reza's video which can help you: https://www.youtube.com/watch?v=8I0Pt_8I6k8&t=1295s

The only thing is that he is using dataverse and you just need to use SQL as data source.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Verified answer

prabakar21 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @ANB , Reza's video is quite handy. I can update the data now, thanks

Was this reply helpful? Yes No