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

[dave8]

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,

[v-siky-msft]

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

[dave8]

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]

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]

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