Unable to get the user's manager using Office365Users.ManagerV2() connector

Question

I have 2 SharePoint People or Group fields which allow single selection. one field represents the User (DateCardValue6) and the other field represents the Manager. now inside the manager field i disabled the field + i added this formula inside the DefaultSelectedItems, as follow:-

but when i run the form and i select a value inside the User field, nothing will be shown inside the manager.. any advice? Although the user has a manager inside AD.

Answer 1

Hi @john john ,

Set the DefaultSelectedItems of Manager combobox Property to:

{  
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",  
    Claims: "i:0#.f|membership|" & Office365Users.ManagerV2(DataCardValue2.Selected.Email).mail,  
    Department: "",  
    DisplayName: Office365Users.ManagerV2(DataCardValue2.Selected.Email).displayName,  
    Email: Office365Users.ManagerV2(DataCardValue2.Selected.Email).mail,  
    JobTitle: "",  
    Picture: ""  
}  

Note: replace DataCardValue2 - User Combobox with your own

Sample:

Save and publish it to your SharePoint site.

Test result in my SharePoint list form.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.