Skip to main content

Notifications

Announcements

No record found.

Get the Manager of a particular user in Dynamics 365

Background

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.

pastedimage1681806882223v1.png

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

Mail

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.

 pastedimage1681807188274v2.png

 The screenshot below is a detailed description of this action.

 pastedimage1681807318857v3.png

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.

 Get Manager

pastedimage1681807922396v4.png

Comments

*This post is locked for comments