web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Error when using PATCH...

Power Apps

Unanswered

Error when using PATCH against SQL Server record

(0) Share

Report

Report

Posted on by darylvogan

274

I'm trying to update an existing record in SQL Server, via an on-premise gateway. I'm able to read data just fine, but when executing a PATCH, I get the message: "Network error when using the Patch function: The requested operation is invalid".

Patch(xxxx,selUser,{MiddleName:TextInput1.Text})

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

SebS 4,867 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@darylvogan

I think it's cause it can't find the record.

Patch(xxxx, {ID:selUser.ID}, { MiddleName:TextInput1.Text } )

Or You will need to do Lookup to find ID
darylvogan 274 on at

Like
a
(1)

Report
Copy link

Link copied!

I've found the root cause: there is a trigger on the table, which is causing the error:

The target table 'xxxxxx' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.\r\ninner exception: Microsoft SQL: The target table 'xxxxxx' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

I'm going to look into a video i see about calling a SP instead of Patch.

Join the conversation