Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

How can I achieve retrieving list of all available apps in all environments with thier user details?



I require  a list of all apps from all environments with their owner and users with whom app is shared details.


I assume COE Apps don't have such information, Is there any readymade script available to get such reports?


I see Get-AdminPowerAppsUserDetails/Get-AdminPowerApps, however it only shows it's owner details and not their user details with whom app is shared.


Moreover it only seems to be listing down the canvas apps and not other types of apps.


Can anyone please guide on this?



Community Support
Community Support

Hi @dave8 .


Please try with the following command to get a list of PowerApp app owners and users


Get-PowerAppRoleAssignment -AppName "AppID of PowerApp"

For more reference: PowerShell Cmdlets for PowerApps and Flow creators and administrators 

Hope this helps.


Impactful Individual
Impactful Individual

Thank you, I see that this is useful for PowerApps Canvas Application, Can you please share how can I retrieve details for "Model Driven Apps" OR Any other types of apps in the power platform?



Hi @dave8 ,


The PowerShell cmdlet can only retrieve Canvas App and flow. 

In my opinion, there is no way to get the shared users for Model-driven App.




Hi @dave8 ,


I just found that If you configure a specific security role for Model-driven App, All users that related to that specific security roles is the shared user you want. 

Security Role Entity has Many to Many relationship with User Entity, so you can use a basic LookUp formula to get all related users.

LookUp('Security Role', Name="The Role Name").Users //Gallery.Items property


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (5,293)