Answered

Sudden Patch Error

(0) Share

Report

Posted on by StacyO

101

I am suddenly getting a patching error and have (I think!) traced it to the OnSuccess function of my form. This was working fine last week but now I am getting this error:

"Network error occurred on the server"

I removed all the patch functions from the OnSuccess property and left the Notify and Reset form functions.

Still giving me the same patch error even though I removed all the patch functions. Any idea of what to check next?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@StacyO

Difficult to say without any code to reference

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StacyO ,

It would be possible that data structure of the data source the form connecting to has been changed. Please refresh the connection, add the form to your App again. SubmitForm function uses the Patch method as well, the error could be due to this function.

Best regards,

Was this reply helpful? Yes No
StacyO 101 on at

Like
a
(0)

Report
Copy link

Link copied!

my apologies - I have a button with the SubmitForm function, OnSelect property:
Set(
varOppSubmitDialog,
false
);
If(
OpportunityForm.Mode = FormMode.New,
Set(
varReqStatus,
"New Request"
)
); //set for OnSuccess functions
SubmitForm(OpportunityForm);
Navigate(Screen_Main);

in the form's OnSuccess is where I put the Patch function which updates 2 choice fields, a date field and 2 text fields.

Hopefully this provides enough context. Thanks!

Was this reply helpful? Yes No
StacyO 101 on at

Like
a
(0)

Report
Copy link

Link copied!

I've refreshed the connection, checked all required fields, removed the buttons and added them again.
I've removed all Patch functions from the OnSuccess property, leaving only a Notify function. Still gave me a patch error. I put a simple button on the form with just a random patch and that worked. The monitor is giving me a 502 Bad Gateway errors where it tries to Create the Row. Is there an issue with my form?
Do I need to rebuild the form?

Was this reply helpful? Yes No
StacyO 101 on at

Like
a
(0)

Report
Copy link

Link copied!

I've nailed it down to one of my Combobox fields. When I remove the field there is no error. When I add it back then the Patch error:
"Error reading string. Unexpected token: StartObject. Path 'Value', line 2, position 13.\r\nclientRequestId: 9c607a94-2e32-4511-9685-b89dad844de0\r\nserviceRequestId: a21430a1-1037-0000-2dcd-bce661b6caf0"

Here are the property settings:

Items: If(varShowLaborFields= true,Choices([@'My SharePointList'].'Cost Element'),Distinct(Filter(
'My SharePointList',Vendor=cmbVendor_1.Selected.Value),'Cost Element'))

DefaultSelectedItems: ThisItem.'Cost Element'

Update: cmbCostElementOpp.Selected

NOTE: I have nearly this same field configuration in use on another form in my app and it works fine. I've removed the field, added it back again. still same error.

Was this reply helpful? Yes No
Verified answer

EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@StacyO

This formula

// re-written If( varShowLaborFields, // this is a Choices table, usually 2 columns Choices([@'My SharePointList'].'Cost Element'), // this is a single column table Distinct( Filter( myList, Vendor=cmbVendor_1.Selected.Value ), 'Cost Element' ) )

Is confusing your data source by the looks. You are creating 2 different schemas for the ComboBox Items depending on the value of the variable varShowLaborFields. This doesn't work for the Form Submit / Patch.

Was this reply helpful? Yes No
StacyO 101 on at

Like
a
(0)

Report
Copy link

Link copied!

what I'm trying to do that if the variable is true then I need all choices in the list for that column, if false then I need a filtered list from that same column. It's the same list for both functions. Is there another way to accomplish this?

Was this reply helpful? Yes No
StacyO 101 on at

Like
a
(2)

Report
Copy link

Link copied!

Ok.. so you led me down the right path. I was able to create a variable and use that to avoid the schema confusion and it works. Thank you so much!

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@StacyO

Well done on solving this. Always rewarding to build the solution yourself 🙂

Was this reply helpful? Yes No
StacyO 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Appreciate your help!!! I don't know what I'd do without this community! 🤗

Was this reply helpful? Yes No