web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch Function Error: ...
Power Apps
Answered

Patch Function Error: Gives a network error even when everything is seemingly correct

(0) ShareShare
ReportReport
Posted on by 392

I am getting the "network error when using patch function: the requested operation is invalid" error when I try to write data to sql server. The connection works, and the account is viable (it works in sql server). I have a more complicated patch written, but even a simple operation of adding a blank row does not work. 

developingteal_0-1717005078912.png

When I run this on its own, it does not work. The database values can all be null except for the pkey, which is automatically done by sql server. I just am not sure what I am doing wrong, but it seems to not work. Thanks for any insight you can give into the issue.

Categories:
I have the same question (0)
  • developingteal Profile Picture
    392 on at

    I should mention the above code is wrong, I have included a comma and then {}, so it should not be merging the records.

  • Verified answer
    developingteal Profile Picture
    392 on at

    here is my more detailed iferror log: 

    developingteal_0-1717011679371.png

     

    does this mean the database can not have any triggers? or am I mistaken 

  • developingteal Profile Picture
    392 on at

    figured it out : had to delete the db triggers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard