web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How can I achieve retr...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

Hello,

 

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?

 

Thanks,

I have the same question (0)
  • v-siky-msft Profile Picture
    on at

    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.

    Sik

  • Dave Wi Profile Picture
    on at

    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?

     

    Thanks,

  • v-siky-msft Profile Picture
    on at

    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.

    Sik

     

     

  • v-siky-msft Profile Picture
    on at

    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

    Sik 

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard