Network error when using the Patch function: Field 'Venue' is required

(0) Share

Report

Posted on by bozo88

This is driving me crazy. I getting "Network error when using the Patch function: Field 'Venue' is required".

Customized Power App Form with a lookup to another SharePoint list to retrieve Venue details.

OnSelect = SubmitForm(SharePointForm1) - no Patch command here but power app monitor points at this formula.

Field 'Venue' is required on the sharepoint list - it itself is lookup in a 'Venues' list (with 'VenueName' (renamed Title) and 'Code' columns). Setting venue to optional works but venue does not flow into sharepoint list.

Ideas

Thanks

Categories:

Using Apps Using Formulas

All responses (9)

Answers (2)

Verified answer

bozo88 25 on at

Like (1)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

After some hair tearing I finally worked out that I need to change the DataField back to "Venue" (original name) from the renamed "Location".

Looking through the names of the fields there was nothing there to suggest needing to use original name (or even what it was unless you looked at the actual URL being called). Even Sharepoint Designer didn't help with the names!

But finally the form is working.

Thanks for all the help.
v-jefferni on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

Hi @bozo88 ,

I have a LookUp column testT1 in list test2, then Combo box settings:

Best regards,
v-jefferni on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

Hi @bozo88 ,

No, it should be the initial list LookUp column. If I have a LookUp column Venue in SharePoint list1, then it should be Choices(list1.Venue)

Best regards,
bozo88 25 on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required
Verified answer

v-jefferni on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

Hi @bozo88 ,

As I said, for SharePoint list LookUp columns, the Items property of Combo box should be Choices(ListName.ColumnName).

Best regards,
bozo88 25 on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

Items is set as Choices(Venues) but then has a red squiggle underneath it.
"The function Choice has some invalid arguments"
v-jefferni on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

Hi @bozo88 ,

How did you modify the Form? If the Items property of this Combo box is Choices(SPlist.Venue) and Update of Venue Data Card is VenueDataCardValue.Selected (both are default settings), and a choices is selected in the Combo box then submit the form, the error should not present.

Best regards,
bozo88 25 on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

It is a Combo Box.
Form has been modified slightly but this really shouldn't affect

Venue_Datacard with combobox on in with datasource of Venues.
v-jefferni on at

Like (0)

Report

Re: Network error when using the Patch function: Field 'Venue' is required

Hi @bozo88 ,

SubmitForm function is a patch command as well. The issue is you have required column Venue but no value or value is invalid when submit the form. Basically, it should be a Combo box control in the Venues Data Card in the Form. Have you modified this form?

Best regards,