How to Patch Person Lookup in PowerApps with SharePoint
Ram Prakash
5,055
Like
Share
ReportImplementation Steps:
Consider a Scenario, we need to Update or Set Person Lookup Field from PowerApps
Patch Logged in User to a Lookup Field:
Patch(
'TABLE NAME',
PERSONLOOKUPNAME: {
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|"&User().Email,
Department: "",
DisplayName: User().DisplayName,
Email: User().Email,
JobTitle: "",
Picture: ""
}
}
);
Patch different User to a Lookup Field:
Patch(
'TABLE NAME',
PERSONLOOKUPNAME: {
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|email@emaildomain.com",
Department: "",
DisplayName: "USER FULLNAME",
Email: "email@emaildomain.com",
JobTitle: "",
Picture: ""
}
}
);
That's it 🙂
Comments
-
How to Patch Person Lookup in PowerApps with SharePoint
Hi, could you give another or similar way to Patch Person Lookup and replace the information:
Example:
Patch( Database; Lookup(Database; Sentence );
{
FirstColumOfTypePerson : SecondColumOfTypePerson
}
)
But this doesn't work, so i don't know how to do that.
*This post is locked for comments