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.

2 Comments

  • Hi Maarten,
    I’m not a PowerShell expert then I find your script very useful. However, most of the cmdlets require the flow Id and it is not in the html result. I could find a way to get the id of a specific Flow, knowing its name but it could be interesting to have a column with the ids.

    Best regards,
    Franck

  • Thanks for sharing, Maarten! Saved me a bunch of time.

    Amen on wantig the output to include the names of the connectors used in the Flow. I haven’t run this script yet so I’m hoping I’ll get surprised and the commandlet now includes that info. But even if not, your scripts are very helpful.

    One thing to note, I got to this page from the matching one for the PApps script. But this page (the Flow report script) refers to another page for Flow instead of referring to the proper matching Apps script. That could be confusing to people who start here and then don’t realize you have made TWO great scripts for Flow AND for Apps.

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.