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:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
bozo88 25 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
bozo88 25 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bozo88 ,

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

Best regards,

Was this reply helpful? Yes No
bozo88 25 on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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,

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

Like (0)

Report
Copy link

Link copied!

Hi @bozo88 ,

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

Best regards,

Was this reply helpful? Yes No
Verified answer

bozo88 25 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No