Listing all solution and non-solution flows in a tenant

A good Power Platform strategy requires an overview of all the available resources in the tenant. This includes also Power Automate flows. For flows within solutions, this is relatively straightforward. However, personal flows of users are another topic…

This blog post explains how to build a Power Automate flow to list all existing flows in the tenant.

Note: For personal flows, it is required that an admin or service account is added as second owner to be listed in this solution!

Table of contents

• Initial actions
• Looping through environments
• Processing the filtered arrays
• Appending the contents of the variables to Excel

Further Articles on Governance

• With the Center of Excellence, there is a great starting point for a Power Platform strategy in your organization. This video helps you to get started:Overview of CoE Starter Kit (Center of Excellence)
• Micheal Roth has a series of articles on Power Platform governance, whcih can be found here:
• Power Platform governance 01 - Setting the scene
• Power Platform governance 02 - About limiting environment creation
• Power Platform governance 03 - Take care about your default environment
• Power Platform governance 04 - Think about a minimal set of environments
• Power Platform governance 05 - Set up security groups for your environments
• Power Platform governance 06 - Consider a data loss prevention strategy

What is a Power Platform solution?

The Microsoft Power Platform is a collection of business productivity tools that allow users to analyze data, create and publish custom apps, automate processes, and manage projects. It consists of four main components:

1. Power BI: A business analytics tool that allows users to create interactive reports and dashboards from various data sources.
2. Power Apps: A platform for creating custom business applications without writing code. Power Apps allows users to build apps that can be accessed from a web browser or mobile device.
3. Power Automate: A tool for automating workflows and business processes. Power Automate allows users to create automated flows that can be triggered by events or data changes and can integrate with other applications and services.
4. Power Virtual Agents: A tool for creating chatbots that can assist with customer support, answer frequently asked questions, and provide information to users.

A Power Platform solution is a custom application or workflow created using one or more of these tools, designed to solve a specific business problem or need. Solutions can be created by individuals or teams, and can be shared and reused within an organization.