Answered

Submiting form with people picker not updating in SharePoint

(0) Share

Report

Posted on by soraiataipa

Hi everyone,

I have a SharePoint list with a people picker column type. In the PowerApps I want to update an item selected from a galley using form. After editing all fields, including selecting a person from the people picker, I'm using a bottom to submit the form. All the fields are updated in the SharePoint list except the one with the people picker. Any idea on how to solve this?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (4)

Report
Copy link

Link copied!
@soraiataipa

On the Items property of your Person DropDown are you using office365users? Like below

Filter(Office365Users.SearchUser({searchTerm:Person.SearchText}))

and on the Update Property of the Data Card use below

If(!IsBlank(personControl.Selected.Mail)&&!IsEmpty(personControl.Selected.Mail),{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(projectplanmanager.Selected.Mail), Department:"", DisplayName:personControl.Selected.DisplayName, Email:personControl.Selected.Mail, JobTitle:".", Picture:"."},{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(ThisItem.PersonfieldInsharepoint.Email), Department:"", DisplayName:ThisItem.PersonfieldInsharepoint.DisplayName, Email:ThisItem.PersonfieldInsharepoint.Email, JobTitle:".", Picture:"."})

Was this reply helpful? Yes No
soraiataipa 68 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly 🙂

Thnk you so much for your reply and help.

I'm facing an issue in the firts part.

When adding the formula to Items property of the Person DropDown:
Filter(Office365Users.SearchUser({searchTerm:Person.SearchText}))

it appears the following error:
invalid number of arguments: 1 received, 2 or more expected.

After I've tried to change "Person" to the name of the column in SharePoint and to the datacard name and the error continues.

Any idea how can I fix it?

Thank you so much!

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!
@soraiataipa

Please use below instead

Office365Users.SearchUser({searchTerm:dropdown.SearchText})

Was this reply helpful? Yes No
Verified answer

soraiataipa 68 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Mira_Ghaly.

I've removed the form and add it again and now when an edit the item, all content is update in the SharePoint list, including the people picker content. Didin't make any change in the dropdown of the people picker. Maybe it was a temporary bug.

Was this reply helpful? Yes No
shakeel_fcc 10 on at

Like (0)

Report
Copy link

Link copied!

Can you please elaborate it?

Actually, I am having the same issue that the form is not updating on the SharePoint list and give an error "Network error when using Patch function: The requested operation is invalid"

I have an optional people picket in the form, when I select a user in the Office365User people picket datacardvalue the form submits and updated on the SharePoint list without any problem but if I kept the people picker blank and fill the rest of the form, I got that error.

Could you please help how to submit the form when the people picker is empty or no user selected?

Thanks.

Was this reply helpful? Yes No