Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Dynamics 365 CE - Manager field

Posted on by 78

Hi All,

I am being given a task to complete, which I need help with, please. as you know, D365 CE does not pull the manager's record to user from office 365; I hope to bulk update about 1300 user records in the system with their manager's names received from HR.

I can pull the GUID of the managers out from CE using XRM, but I will like to confirm the easiest and possible way of updating the users' records with their manager's names, respectively, with no issue.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics 365 CE - Manager field

    Hi Partner,

    You can update manager field of the user through with export / reimport.

    1.Export the user view with columns you want.

    pastedimage1627893718706v1.png

    pastedimage1627893798501v3.png

    pastedimage1627893899805v4.png

    2.Open the excel file and fill manager field.

    pastedimage1627894035800v5.png

    3.Import the file.

    pastedimage1627894170221v6.png

    4.Test results:

    pastedimage1627894620942v7.png

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • OlaAde Profile Picture
    OlaAde 78 on at
    RE: Dynamics 365 CE - Manager field

    Thank You so much for this, and it's already packaged as an unmanaged solution - currently, there is a change freeze in my organization; this step will require change - can I do it in another way without using the power to automate flow?

  • OlaAde Profile Picture
    OlaAde 78 on at
    RE: Dynamics 365 CE - Manager field

    I am trying to get the data from azure AD for the hierarchy relationship and not D365

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics 365 CE - Manager field

    Hi partner,

    Maybe you can get & set manager of CDS|D365 users with Power Automate flow.

    The link below tells how to use Power Automate flow to automatically set the manager field for a Dynamics 365 User record based on the Manager attribute in Azure AD and Office 365.

    Get & set manager of CDS|D365 users with Power Automate flow - There's Something About Dynamics 365 (2die4it.com)

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • AriaConsulting Profile Picture
    AriaConsulting 2,655 on at
    RE: Dynamics 365 CE - Manager field

    Hi,

    Can you just clarify if you are trying to get the data FROM Azure AD for the hierarchy relationship to push into D365 Sales or you have the hierarchy already in D365 Sales and you want to push it into Azure AD?  Wasn't really clear in your question.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans