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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Thanks!

Categories:

Governance & administering

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Joel CustomerEffective 3,224 on at

Like (0)

Report
Copy link

Link copied!

Go to admin.powerapps.com or admin.flow.com to get a list of licensed users for power apps and power automate

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Thanks!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

https://o365reports.com/2018/12/14/export-office-365-user-license-report-powershell/

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

Was this reply helpful? Yes No
Joel CustomerEffective 3,224 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

I will pass this info to the administrators though.

Regards

Was this reply helpful? Yes No