Unanswered

Lookup Office user and update a Sharepoint People

(0) Share

Report

Posted on by Community Power Pla...

Having a moment. I want to lookup a user profile and patch a Sharepoint list People item (Owner).

Patch(Hardware,First(Filter(Hardware,ID=ThisItem.ID)),{Owner: Office365Users.UserProfileV2({searchTerm:HomeGalleryEmployees.Selected.'Email Address'})});

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Also tried Set(varPerson, Office365Users.SearchUser({searchTerm:HomeGalleryEmployees.Selected.'Email Address'}));Patch(Hardware,First(Filter(Hardware,ID=ThisItem.ID)),{Owner: varPerson}));Set(AddAssetPopup,false)

But it's a Record / Table mismatch. I guess I don't understand. varPerson is a table but I assumed a Person or Group would also be a table.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Here is what worked for me:

Set(varPersonClaim, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",Claims:"i:0#.f|membership|" & Office365Users.UserProfile(HomeGalleryEmployees.Selected.'Email Address').Mail, Department:"", DisplayName:"", Email:"", JobTitle:"", Picture:""});Patch(Hardware,First(Filter(Hardware,ID=ThisItem.ID)),{Owner: varPersonClaim});

Was this reply helpful? Yes No