cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MilanGross
New Member

Extract a list of all PowerApps for an organisation

We have a need to programmatically extract details on all the PowerApp forms built for our organisation. Is there any API method to get this?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @MilanGross ,

Do you want to get a list of all the apps in your talent?
Yes, you could use the two ways that he @HSheild  listed.

Now let me explain them in details.

Firstly, you need to be the talent's admin or else you do not have permission to use both of the two solutions.

 

1)use PowerApps for Admins connector (in this solution, you also need to connect with PowerPlatform for Admins connector)

You could use this function to get all the apps of the environments:

 

PowerAppsforAdmins.GetAdminApps(Environment Name)

 

You could use this function to get all environment names:

PowerPlatformforAdmins.GetAdminEnvironment()

 So combine them together, you could save all apps details to a collection by using this formula:

Clear(applist);ForAll(PowerPlatformforAdmins.GetAdminEnvironment().value,Collect(applist,PowerAppsforAdmins.GetAdminApps(name).value))

Please notice, since some environments are invalid, so using this function will get error message like "the environment could not be found....". But the collection has collected data successfully.

Also, you can not get all the apps by using these two connectors.

By default, the limit is 250 app.

Here are docs about these two connectors for your reference:

https://docs.microsoft.com/en-us/connectors/powerappsforadmins/

https://docs.microsoft.com/en-us/connectors/powerplatformforadmins/

 

2)use powershell:

You could use "Get-AdminPowerAppEnvironment" to get app lists of an environment.

You could use "Get-PowerAppEnvironment" to get environment name.

Here's a blog about this for your reference:

https://powerapps.microsoft.com/en-us/blog/gdpr-admin-powershell-cmdlets/

Please notice that you could get more apps by using this solution.

 

Here's an issue about comparing these two solutions for your reference:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Powershell-vs-PowerApps-Admin-Connections/m-...

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
HSheild
Super User
Super User

Hi @MilanGross 

 

Have you seen the Power Apps for Admins connector?   You can create your own Power App to get a list of your Power Apps with the Get Apps as Admin action.

 

https://docs.microsoft.com/en-us/connectors/powerappsforadmins/

 

There is also a PowerShell Cmdlet available too which pretty much does the same things as the admin connector

https://docs.microsoft.com/en-us/power-platform/admin/powerapps-powershell

 

-----
 
If this post has answered your question please consider it for "Accept as Solution" or if it has been helpful give it a "Thumbs Up".

v-yutliu-msft
Community Support
Community Support

Hi @MilanGross ,

Do you want to get a list of all the apps in your talent?
Yes, you could use the two ways that he @HSheild  listed.

Now let me explain them in details.

Firstly, you need to be the talent's admin or else you do not have permission to use both of the two solutions.

 

1)use PowerApps for Admins connector (in this solution, you also need to connect with PowerPlatform for Admins connector)

You could use this function to get all the apps of the environments:

 

PowerAppsforAdmins.GetAdminApps(Environment Name)

 

You could use this function to get all environment names:

PowerPlatformforAdmins.GetAdminEnvironment()

 So combine them together, you could save all apps details to a collection by using this formula:

Clear(applist);ForAll(PowerPlatformforAdmins.GetAdminEnvironment().value,Collect(applist,PowerAppsforAdmins.GetAdminApps(name).value))

Please notice, since some environments are invalid, so using this function will get error message like "the environment could not be found....". But the collection has collected data successfully.

Also, you can not get all the apps by using these two connectors.

By default, the limit is 250 app.

Here are docs about these two connectors for your reference:

https://docs.microsoft.com/en-us/connectors/powerappsforadmins/

https://docs.microsoft.com/en-us/connectors/powerplatformforadmins/

 

2)use powershell:

You could use "Get-AdminPowerAppEnvironment" to get app lists of an environment.

You could use "Get-PowerAppEnvironment" to get environment name.

Here's a blog about this for your reference:

https://powerapps.microsoft.com/en-us/blog/gdpr-admin-powershell-cmdlets/

Please notice that you could get more apps by using this solution.

 

Here's an issue about comparing these two solutions for your reference:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Powershell-vs-PowerApps-Admin-Connections/m-...

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Users online (4,874)