Friday Functions Series | Set a SharePoint People Column to the Current User's Manager

Опубликовано: 07 Октябрь 2024
на канале: Audrie Gordon
7,201
32

Supporting Carlos' blog this week, learn how to default a control in PowerApps to set the value of a Person/People column on SharePoint to the current user's manager using the Office 365 Users Connector. **I noticed that the last paragraph of his blog mentions managers too just after I posted the video. However, I figured the video would still be useful to some.

Carlos' awesome blog on setting default values on complex SharePoint columns:
https://powerapps.microsoft.com/en-us...

More on the Office 365 Users Connection:
https://docs.microsoft.com/en-us/powe...

Syntax:
If(
Form1.Mode = FormMode.New,
{
DisplayName: Office365Users.ManagerV2(User().Email).displayName,
Claims: "i:0#.f|membership|" & Office365Users.ManagerV2(User().Email).mail
},
Parent.Default)

Enjoy!
Audrie