web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : ycgwyGmzN1QifnHqxtJ4+d
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?

Like (0) ShareShare
ReportReport
Posted on 27 Jun 2020 23:24:43 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! 

I have the same question (0)
  • leandrolopez Profile Picture
    leandrolopez 11 on 29 Jun 2020 at 03:41:49
    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 28 Jun 2020 at 02:19:22
    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 28 Jun 2020 at 01:58:37
    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 28 Jun 2020 at 01:34:55
    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 28 Jun 2020 at 00:40:12
    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 27 Jun 2020 at 23:55:00
    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
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans