Power Platform Community Forum Thread Details

The data source for the form is a SharePoint List.

I've narrowed down the issue to the Person type column using the following steps in the canvas app:

Scenario 1:

Click on "Edit Item" in the gallery. (redirects to the edit form)

Update/change every field to a new value and click submit/save. [triggering SubmitForm(form)]

Update the changes at the data source (SharePoint List).

(Everything works as expected without any errors)

Scenario 2:

Click on "Edit Item" in the gallery. (redirects to the edit form)

Update/change every field except for the person (column) dropdown to a new value and click submit/save. [triggering SubmitForm(form)]

Error: Network Error when using Patch function. The requested operation is invalid

(no changes are updated at data source)

This error occurs only when the value of the "Person" column remains unchanged.
Based on this, I suspect the issue may be related to the default values of the "Person" field in the form, but I am not 100% sure.

Person Column Properties

I have a custom Combobox (old controls - just for the person column) in the Datacard instead of using the default dropdown for persons since the old controls Combobox has more customizations and I am using modern controls for the rest of the form.

Properties of the DataCard:

Default:

ThisItem.RequestedBy

Update:

If(
 OrderForm.Mode = FormMode.New,
 {
 Claims: "i:0#.f|membership|" & Lower(Office365Users.MyProfileV2().mail),
 Department: "",
 DisplayName: Office365Users.MyProfileV2().displayName,
 Email: Office365Users.MyProfileV2().mail,
 JobTitle: "",
 Picture: ""
 },
 {
 Claims: "i:0#.f|membership|" & Lower(RequestedBy_ComboBox.Selected.Mail),
 Department: "",
 DisplayName: RequestedBy_ComboBox.Selected.DisplayName,
 Email: RequestedBy_ComboBox.Selected.Mail,
 JobTitle: "",
 Picture: ""
 }
)

Properties of the person ComboBox (within datacard):

OnChange:

false

OnSelect:

false

Default:

//this is empty

DefaultSelectedItems:

Parent.Default

Items:

Filter(
 Office365Users.SearchUserV2(
 {
 searchTerm: Trim(Self.SearchText),
 isSearchTermRequired: false
 }
 ).value,
 AccountEnabled = true && Not("#EXT" in UserPrincipalName)
)

Any help or suggestions are appretiated.

Categories:

Building Power Apps

Hi @Gurkirat_K,

Since you are no longer using the standard Items property of that Form combobox 'Choices(ListName.PersonColumn), the column schema of the Default property no longer matches the Items column schema. (ThisItem.RequestedBy does not match the SearchUserV2 output schema)

Although visually a value may be present in the combobox in edit mode, this does not correspond with a correct record within your Items property - causing issues during Form submission. Changing the combobox DefaultSelectedItems property to the code below did the trick on my end:

Office365Users.SearchUserV2(
 {
 searchTerm: ThisItem.RequestedBy.Email,
 //true to avoid auto-fill when Form is in New mode
 isSearchTermRequired: true
 }
).value

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!