Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Governance and Administ... / How to get all users o...
Power Apps - Power Apps Governance and Administ...
Answered

How to get all users on AAD with access to make Power Apps on any Environment?

(0) ShareShare
ReportReport
Posted on by leandrolopez 11

Hi All,

 

As part of governing PowerApps, I am creating a web app with resources for new users to get started. The web application does validations on behalf of the users to check if a license has been assigned to them and if they have access to any environment with and a power apps maker role assigned.  

 

I am using the Graph API to validate the user's licenses but I can't find a way to validate if the user has access to an existent environment with the maker role assigned.

 

Do you know any APIs that I could use to check this? and what would be the steps? So far, I have been exploring the CDS Web API with no luck.

 

Appreciate your help! 

  • leandrolopez Profile Picture
    leandrolopez 11 on at
    Re: How to get all users on AAD with access to make Power Apps on any Environment?

    Thanks for the help, I have been able to get the list of makers from the admin_makers entity via the Web API using!

     

    Have a good week and thanks again for the help.

     

     

  • Verified answer
    Joel CustomerEffective Profile Picture
    Joel CustomerEffective 3,224 on at
    Re: How to get all users on AAD with access to make Power Apps on any Environment?

    Yes the COE starter kit collects information about your environments users and apps and then you can leverage it in apps and dashboards

  • leandrolopez Profile Picture
    leandrolopez 11 on at
    Re: How to get all users on AAD with access to make Power Apps on any Environment?

    The CoE starter Kit seems to be pulling the makers from all environment into the CDS of the environment where I deployed the started Kit components. On the PowerBI dashboard there is a tab named "Makers" that counts App Makers and Flow Makers. This is currently showing much more people that the people with access to my admin environment where I deployed the kit. 

     

    So, I if pulled the data as PowerBI is doing, wouldn't that be enough? 

     

     

  • Joel CustomerEffective Profile Picture
    Joel CustomerEffective 3,224 on at
    Re: How to get all users on AAD with access to make Power Apps on any Environment?

    It would but you will need to query each cds environment database.

  • leandrolopez Profile Picture
    leandrolopez 11 on at
    Re: How to get all users on AAD with access to make Power Apps on any Environment?

    Thanks for the quick response!

     

    The end goal will be to use AAD security groups as you recommended but at the moment we have a mix. 

     

    I had setup the Power BI Dashboard and I was thinking on querying the entity admin_makers using the CDS Web API and use this as the list of users with effective access. Would that be a complete list? I was not sure if that represent the users that had created at least one application or if it's the complete list of people with maker access to any environment. Could you please confirm? 

     

    Thanks again! 

  • Verified answer
    Joel CustomerEffective Profile Picture
    Joel CustomerEffective 3,224 on at
    Re: How to get all users on AAD with access to make Power Apps on any Environment?

    the recommended way to handle this is to use AAD security groups to control environment access. then it is easy to see what environments a user has access to

     

    also, if your environment has CDS, cds roles control environment access, so it may be different in different environments.

     

    the COE starter kit covers some of this and provides a power BI dashboard that includes what users are environment makers and what environments have the most users 

    https://docs.microsoft.com/en-us/power-platform/guidance/coe/power-bi-monitor

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans