Unanswered

SubmitForm: Network Error When Using Patch Function

(0) Share

Report

Posted on by fhamm

I'm building an app that connects to a SharePoint list. I have had trouble with it in the past trying to get it to auto-populate and update certain fields, but seemed to find some solution to those issues. Now, however, when I try to submit the form, I am getting the error: "Network error when using Patch function: The requested operation is invalid". I am using a button with the OnSelect property being SubmitForm(Form1).

I have attempted reconnecting to the data source and re-making the submit button. In one instance, the submit button worked briefly after being remade. I am not sure where the issue lies at this point or how to troubleshoot further.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Ami K 15,687 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @fhamm,

Very common question. A few typical checks:

Remove each field from the Form one by one until the error disappears to pinpoint which field is causing the problem.
Check if you are patching text values to a number column (and vice versa) or if you’re patching to a choice field
Check if any of those fields have "enforce unique values" enabled and you're not patching to a field which already has the same value
If any of your fields are a choice field type, check if the choice from the combo box/dropdown in the app exists in the available choices in the SharePoint list. If not, you will need set the SharePoint choice column to allow “fill in” choices (or 'can add values manually' in modern SharePoint
------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
fhamm on at

Like (0)

Report
Copy link

Link copied!

I'm not sure what the problem was, but I did find the field that was causing the issue, deleted it, and re-added it. I used the exact same code in all of the properties as before and it worked.

Was this reply helpful? Yes No
Viswanath 28 on at

Like (0)

Report
Copy link

Link copied!

It helped. I got the same error. In my case, the lookup record I'm selecting doesn't have minimun roles. So, any error that occur (from CRM) the canvas app shows the error msg as Network Error When Using Patch Function

Was this reply helpful? Yes No
TKSHEP 212 on at

Like (0)

Report
Copy link

Link copied!

I have the same error doing the same function where you able to find a solution for your error?
Thank you for any assistant you can provide.

Was this reply helpful? Yes No
RBettinelli 23 on at

Like (0)

Report
Copy link

Link copied!

I'm having the same problem but only for other uses who are trying my app. I can use it just fine my SharePoint list is populating but other users get errors.

Was this reply helpful? Yes No
Shravyashree_01 174 Moderator on at

Like (1)

Report
Copy link

Link copied!

This can happen If you are validating User().Email = yourEmail in any of the controls
or using createdby = user().email [since you would have created the list items]
If these do not work,
It would be better if you shared the error for better understanding.

Was this reply helpful? Yes No
RBettinelli 23 on at

Like (1)

Report
Copy link

Link copied!

i ended up recreating the app and it got rid of the errors.

Was this reply helpful? Yes No
Stoffel-Thorste 2 on at

Like (0)

Report
Copy link

Link copied!

I had the same problem and I looked at countless explanations on the web from all kinds of experts explaining complicated patch syntaxes.
What solved the problem for me was a setting in my SharePoint list that required unique values. That meant a certain choice could only be selected for one single data set. ... When I deselected, the "unique value" requirement, the PowerApp worked fine. I could easily edit as well as add new data.
Hope this helps as much as the comments from the experts.
Keep well
Thorsten

Was this reply helpful? Yes No
ahenn22 15 on at

Like (0)

Report
Copy link

Link copied!

Please check that you don’t have any calculated fields in your form or patch

Was this reply helpful? Yes No
CCJones 244 on at

Like (0)

Report
Copy link

Link copied!

Thanks for this! I had this in a few places and was pulling my hair out trying to figure out where the error was coming from! I changed it to use the Office365Users connection instead and the error is now gone!

Was this reply helpful? Yes No