Unanswered

Network Error when using Patch function: The requested operation is invalid- SQL table

(0) Share

Report

Posted on by sbroud

Good evening ,

I am getting error when using Patch function to update and /or create a row in SQL table (using Powerapps of course). so the error is [

Network Error when using Patch function: The requested operation is invalid] is stopping the code and nothing happens on the side of data (SQL).

Just to let you know: connection is working and data is displayed from data source (table). Also, I have developer permissions on this db.

Function is :

Patch(

TableName, Lookup(TableName, Column_Key = Dropdown.selected.Value)

{

field1: data1,

field2: data2,

field3: data3

}

)

Please assist. If you can suggest other solutions, that will be much appreciated.

Thank you.

Categories:

Connecting to Data

All responses (2)

Answers (0)

gates78 10 on at

Like (0)

Report

Re: Network Error when using Patch function: The requested operation is invalid- SQL table

Hi everyone,

The issue persists but I fix it by using flows. So power automate push action to procedure in sql server that receives parameters as variables to change or add data to tables.

Power Automate is magic.

Thank you all.
FLMike 29,366 on at

Like (0)

Report

Re: Network Error when using Patch function: The requested operation is invalid- SQL table

@sbroud

unfortunately you need to have more information since the code looks fine. So please do this and it will tell you exactly whats wrong.
Step 1. Close your App (stop it running)

Step 2. Click the Stethoscope in the Top Right

Step 3. On the bottom click Open Monitor

Step 4. Once Monitor is running go back and run your app

Step 5. Cause your issue to happen

Step 6. Close the app

Step 7. Go to the Monitor and Filter (top right) based on Error, or key word. Go to the line or lines that match this

Step 8. Look at the Response Tab and you will have to expand the Body > and the Header >. Then look at the body to see more details on the error
Do this for each line you find

Step 9. On each line, also check the Code being executed on Tab 2

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey