Post

Generate an overview of all Microsoft Flows with PowerShell
Administration of Microsoft Flow can be done using the browser or you can use the new Power Modules from Microsoft to get, set or remove Microsoft Flows. Users can easily create flows in SharePoint and in their OneDrive so as a company you want to monitor and manage this behaviour. With PowerShell you can generate […]

Administration of Microsoft Flow can be done using the browser or you can use the new Power Modules from Microsoft to get, set or remove Microsoft Flows. Users can easily create flows 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 flows that have been created and who created it. This way you can keep track on who’s building flows, which triggers and actions are users using and the current state of the flow. Company’s can create environments in Microsoft Flow and you can enforce DLP with Flow plan 2. We will also show in which Flow environment the workflow 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 Flow environments
  • List of all Flows

image

Script dependencies

The script uses the MSOnline and PowerApp modules. We use MSOnline because you get only the user-id of the user who created the flow. We will match this user-id with the GUID of the user to retrieve the User Principal Name.
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 Flow 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-FlowOverview. 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-FlowOverview

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-FlowOverview.ps1 -LogPath “C:\Install”

image

First you need to authenticate to Office 365 and then you will need to authenticate again to PowerApps/Flow

image

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

image

You can scroll down to see all the Flows and their information.

image

Requests

Please let me know if you want to see more information that should be valid for a Flows 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. Personally I’m waiting for the connector information to show exactly which connector is being used so you can find out with the Office 365 license if users are using for example Gmail as a connector.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Archive