Get the Manager of a particular user in Dynamics 365
Guowei_Xu
407
Like
Share
ReportBackground
We have various scenarios where it’s necessary to locate the manager of a particular user. For instance, to identify the manager as an Approver, or to send reminders/notifications to the manager.
Although there is a manager field within the user table, this field is always Null, therefore, we are eager to know how to synchronize the Manager field from O365 into the D365 user table.
There is no "Manager" property in the AAD User table either.
Reply from Microsoft CSS Team
Below content is a summary of the reply from the Microsoft CSS Team.
1, There’s no hierarchy concept in the Dynamics CRM Application.
2, The manager property is not synchronized when the user is synchronized from O365/AAD to Dynamics 365 CRM.
3, There is no way to configure the attribute mapping and no public document about it.
4, Below table is the mapping table for your reference.
|
CDS SystemUser Property |
Azure AD Property |
|
DomainName |
UserPrincipalName |
|
WindowsLiveId |
UserPrincipalName |
|
FirstName |
Given Name |
|
LastName |
SurName |
|
Address1_Country |
Country |
|
Address1_City |
City |
|
Address1_StateOrProvince |
State |
|
Address1_Line1 |
StreetAddress |
|
Address1_PostalCode |
PostalCode |
|
Address1_Telephone1 |
BusinessPhones |
|
MobilePhone |
MobilePhone |
|
Title |
JobTitle |
|
InternalEmailAddress |
|
|
azureactivedirectoryobjectid |
objectId |
Workaround
Workaround 1: Power Automate Action
We can get a user's manager by calling the Get Manager (V2) action of the O365 Users connector in Flow.
The screenshot below is a detailed description of this action.
Workaround 2: Microsoft Graph API
You can call the Microsoft Graph API to get the manager of a particular user.
See the API description in the screenshot below or visit the details page for more information.
*This post is locked for comments