Power Platform Community Forum Thread Details

Hello,

I would like to assign a user to an existing Sharepoint list Item, but it does not work although there is no error. I use the Patch function + Lookup. If I only use the Patch function without Lookup it wants me to update every column.

Patch(
 'Sharepoint List';
 LookUp(
 'Sharepoint List';
 Person.Email = Dropdown3.Selected.Email
 );
 {
 Person: {
 Claims: Concatenate(
 "i:0#.f|membership|";
 User().Email
 );
 Department: "";
 DisplayName: Dropdown3.Selected.FullName;
 Email: Dropdown3.Selected.Email;
 
JobTitle: "";
 Picture: Dropdown3.Selected.Image
 }
 }
)

Thank you,

Mazlum

Categories:

Building Power Apps

Hi @Mazlum ,

Firstly try this

Patch(
 'Sharepoint List';
 LookUp(
 'Sharepoint List';
 Person.Email = Dropdown3.Selected.Email
 );
 {
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser";
 Person: 
 {
 Claims: "i:0#.f|membership|" & Lower(Dropdown3.Selected.Email);
 Department: "";
 DisplayName: Dropdown3.Selected.FullName;
 Email: Dropdown3.Selected.Email;
 JobTitle: "";
 Picture: Dropdown3.Selected.Picture
 }
 }
)

I have to assume here that you have a record where the Person field has an email matching that selected in Dropdown3.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps