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
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
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.
Installing the script
You can install the script using the below command
Install-Script -Name New-PowerAppOverview
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”
First you need to authenticate to PowerApps/Flow
It will show you when finished and it will open the .HTML file automatically
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.