Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Manager attribute of the Azure Active Directory user table

(0) ShareShare
ReportReport
Posted on by

Hello everyone, 

In our model-driven app, we're leveraging aaduser virtual table to fetch users from our o365 tenant. In addition to this we would like to be able to show for each user the corresponding manager. This is not directly available as a table column but this is more an attribute that can be fetched through Graph API. 

Any easy / recommended way to workaround this?

Thanks

Faten

Categories:
  • gulshankhurana Profile Picture
    gulshankhurana 1,383 on at
    Re: Manager attribute of the Azure Active Directory user table

    Thanks @fatenyahiaoui_m for appreciating my efforts and for the update. If you feel my answer helped you with your query then please accept it as a solution so that it can help others in the same situation.

     

    Kind regards 

    Gulshan

  • Re: Manager attribute of the Azure Active Directory user table

    @gulshankhurana  thank you, we eventually ended up choosing a low code approach using Power Automate like you suggested for the time being. The plugin option is to be explored later on if time permits

  • Verified answer
    gulshankhurana Profile Picture
    gulshankhurana 1,383 on at
    Re: Manager attribute of the Azure Active Directory user table

    Hi @fatenyahiaoui_m 

     

    As a no-code alternative to what @Michaelfp suggested, you could achieve this through Power Automate.

    I also had a need to have the manager info in D365 sync'ed from AAD (now Microsoft Entra ID) in one of my projects and I found the following article very helpful (although it is a bit old now but it'll give you an idea) when building a flow:

    https://2die4it.com/2020/09/02/get-set-manager-of-cds-d365-users-with-power-automate-flow/

     

    I hope this information helps.

     

    Kind regards

     

    Gulshan

    Please give it a thumbs up 👍🏻 if you appreciate my efforts.

    If my answer helped you resolve your issue then please also mark it as a solution âœ…  so that it helps others experiencing the same problem. You can mark more than one replies as solutions.

  • Re: Manager attribute of the Azure Active Directory user table

    Thanks @Michael, in fact this is helpful. I am new to plugin to development so will give it go and accept this as a solution once I am ready to roll. 

  • MichaelFP Profile Picture
    MichaelFP 1,543 on at
    Re: Manager attribute of the Azure Active Directory user table

    Try this one.

    Custom virtual table data providers (Microsoft Dataverse) - Power Apps | Microsoft Learn

     

    If my answer help you , please give me a kudo. If solve your question please mark as solution.

  • Re: Manager attribute of the Azure Active Directory user table

    Hello @Michaelfp ,

    Thanks. Could you please point me to some documentation that could help me achieve this?

  • MichaelFP Profile Picture
    MichaelFP 1,543 on at
    Re: Manager attribute of the Azure Active Directory user table

    You can do it that by include a plugin on the retrieve and retrievemultiple requests. Applying for each row searching the manager using Graph API. And you can apply the value that you found on a customized field inside the AAD Virtual Table.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics