Administration of Microsoft PowerApps can be done using the browser or you can use the new Power Modules from Microsoft to get, set or remove Microsoft PowerApps. Users can easily create PowerApps in SharePoint and in their OneDrive so as a company you want to monitor and manage this behaviour. With PowerShell you can generate a list all PowerApps that have been created and who created it. This way you can keep track on who’s building PowerApps, which list is connected with the PowerApp and who is the owner. Company’s can create environments in Microsoft PowerApps. We will also show in which PowerApps environment the app is located and how many environments there are. This script will generate an HTML file with the results. You can also go to here to create an overview of Microsoft Flows. The HTML file includes two lists:

  • List of all PowerApps environments
  • List of all PowerApps

image

Script dependencies

The script uses only the PowerApp modules (the flow report also uses the MSOnline Module).
Flow and PowerApps share the same modules where you can find the installation guide at https://powerapps.microsoft.com/en-us/blog/gdpr-admin-powershell-cmdlets/

Creating the PowerApps overview

PowerShell Gallery

The PowerShell Gallery is a perfect solution to store your own scripts which you use on a regular basis where other people can also use them. The script can be found at  https://www.powershellgallery.com/packages/New-PowerAppOverview/1.0. I always recommend reading the code first as this is a script from the internet which can be found after clicking on “Show” at “FileList”. You can also copy the script and edit it to suit your needs.

image

Installing the script

You can install the script using the below command

Install-Script -Name New-PowerAppOverview

image
Press Y if you want to install the script from the PSGallery.

Running the script

An example has been provided in the script info section where we will be using this same example.

Run the following command in PowerShell

New-PowerAppOverview -LogPath “C:\Install”

image

First you need to authenticate to PowerApps/Flow

image

It will show you when finished and it will open the .HTML file automatically

image

Requests

Please let me know if you want to see more information that should be valid for a PowerApps overview report in the comment section and I’ll add this to the PowerShell Gallery script. Please also let me know if you edited the script yourself and what you added or removed as I can learn from you in making this overview better.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.