Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to get a list of users and their powerApps plan?

Greetings everyone,


I would like to list all our users having either :

Power Apps for Dynamics 365
Power Apps for Office 365


Similar to what I can get with this powershell command, which will display all users still on a trial license:

Get-MsolUser -All | SORT-OBJECT DisplayName | Where-Object {($_.licenses).AccountSkuId -match "POWERAPPS_VIRAL"} | ft


I can get a list of users on Entreprise E1 and E3 by replacing the "POWERAPPS_VIRAL" code but don't see how I can isolate specifically those who have a powerApps plan activated.




Accepted Solutions

I found a script that exports what I am looking for:


it creates two csvs file with licenses per user and the services.



View solution in original post


Go to or to get a list of licensed users for power apps and power automate

Thanks for the quick reply.


However I do not see their plans, either because I have limited access to the administration or it is not possible from that screen. I seems also that this user lists is for CDS users (we have on ongoing implementation of D365 for Sales by a vendor); I am missing several users who are on a PowerApps for Office365 license. Again it may be  misinterpretation on my behalf of the admin center tool.


Maybe I can give more context to add some perspectives on my question. I am a developper and am sharing a canvas app with users. The administrators switch the license to an Office 365 for the users I am sharing the app for the first time. However we got some lagging in licenses activation and found some users had not been switched - but were not showing up as a trial license. So I'd like to get a clear list of users and their plans so I can help sysadmins get quickly going.




I found a script that exports what I am looking for:


it creates two csvs file with licenses per user and the services.



It's definitely possible, but if you don't see the Tenant option, you don't have the appropriate security to view this information. You need to either have the global admin or power platform service admin role in Microsoft 365. If you don't have this, ask the admin to go there and download it for you. 


Thanks for the specification, you are right, I do not see the tenant submenu.


I will pass this info to the administrators though.



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,842)