Answered

SubmitForm(FormName) - Network error using Patch function: The requested operation is invalid

(0) Share

Report

Posted on by vicucd

I have a form to create a new record where the user inputs the only 4 required fields and clicks a submit button. The form is attached to a SQL Server table that is accessed via a gateway. While I can edit records in other tables, I am not able to create records. I keep getting "Network error when using Patch function: The requested operation is invalid." The data types match the data types in the SQL server. I'm the database administrator, so I have all CRUD permissions. I've re-created the table in the SQL Server, re-created the form, removed and then recreated the connection, and verified all data types but keep getting the same error. Not sure what is going on. It was working fine on Friday, but come Monday the issue began and has not gone away. Not sure what is going on. Were there PowerApps updates that could have caused the error or other external forces i'm not aware of?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

CU31080113-0 80 on at

Like (0)

Report
Copy link

Link copied!

Hello @vicucd,
Maybe the external forces are tricking you.
So, about your error, most of the times is related to column type or primary key missing/wrong,
despite other specifics errors.
To Discovery what's wrong, I recommend you to try to patch a single item on your datasource that you know the ID, with just one field, just like this:
Patch(
Datasource,
{
ID: 1;
Name: "kacia"
}
)
See If it's works, for some reason, you get more error handling this way.
Then add more fields, one by one, to find what's wrong.
If It didn't work, then use the Monitor Debug functionality to help you out:
Debug in Powerapps

I hope It helps

Was this reply helpful? Yes No
Verified answer

vicucd 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you for all of your help, much appreciated! Also, thanks for introducing me to the Monitor Debug, very helpful.

However, after hours of investigation, I figured out the problem. I had created a trigger that would create records on other tables when a record was inserted on my main table. Lesson learned: PowerApps does not like db triggers.

Was this reply helpful? Yes No
CU31080113-0 80 on at

Like (0)

Report
Copy link

Link copied!

Glad that I was able to help!
If it's solved, you can close this Topic.

Appreciate.

Was this reply helpful? Yes No