Power Apps Tutorial: How to get list of Power Automate Flows.

Hello Guys,

In our previous blog, we discussed about polymorphic lookups. Today, we will see how to get list of PA flows.



Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends.

There are many situations where administrators and developers need to retrieve a list of Power Automate flows running in a Power Platform environment. As the number of flows grows over time, it becomes difficult to track which flows are actively used, who owns them, and how they impact overall system performance and scalability.

Having visibility into all flows within an environment is essential for governance, performance monitoring, troubleshooting, licensing optimization, and security compliance. In this blog, we will explore different ways to get a list of Power Automate flows in the Power Platform and understand when and why each approach should be used.

In large organizations, it is common to have hundreds or even thousands of Power Automate flows created by different users and teams. Over time, some flows become unused, misconfigured, or poorly designed, leading to performance issues, unnecessary API calls, and increased licensing costs. Without proper visibility, maintaining and governing these flows becomes a significant challenge for Power Platform administrators.

We can use below methods to retrieve PA flows:

  • Power Platform Admin Center
  • PowerShell (Microsoft.PowerApps.Administration.PowerShell)
  • Power Platform CLI (PAC)
  • Dataverse tables (Flow metadata)

Let's see how to retrieve PA flow list using Dataverse tables.

To retrieve the list of Power Automate flows stored in Dataverse, we will use XRM Toolbox, which is a commonly used tool for administration and analysis in Dataverse environments.

Step 1: Connect to the Environment

  • Launch XRM Toolbox
  • Click Connect
  • Select or create a connection to the required Power Platform environment

Once connected successfully, proceed to the tool library



Step 2: Install SQL4CDS Tool

  • Open Tool Library in XRM Toolbox
  • Search for SQL4CDS
  • Download and install the tool

After installation, open SQL4CDS



Step 3: Open Query Editor

  • Once SQL4CDS is opened:
  • Select the connected Dataverse environment
  • Open the Query Editor

Paste the SQL query provided below



Power Automate flows are stored in the workflow table in Dataverse. The following query retrieves a list of cloud flows along with basic details.

SELECT

    name AS FlowName,

    createdon AS CreatedOn,

    modifiedon AS ModifiedOn,

    statecode AS StateCode,

    statuscode AS StatusCode,

    owneridname AS Owner,

    category,

    mode

FROM workflow

WHERE category = 5

ORDER BY modifiedon DESC


category = 5 is used to filter Power Automate cloud flows

You can add or remove columns as per your reporting or governance requirements.

Hope it helps...




Comments

Post a Comment

Popular posts from this blog

Creating Custom API in D365.

Image
Hello Guys, In our previous blog  we have seen how to retrieve and use GUID of logged in user in canvas application. Today we are going to create custom API which is nothing but the custom action in old version of the CRM. But before d o follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Custom API is a new way of creating Custom Action messages in D365. We were used to create a custom action for custom messages in previous version of the CRM for many years. Below image shows the example of custom action. But now Microsoft has introduced an extension for Custom Action called Custom API  which has more controls like creating Private Custom API which means API can be used by owner of the API or by users with whom API is shared. We can create Custom API as web method which means we can use GET and POST method to use this API. Custom API does not require us to create custom messages which w...
Read more

JavaScript in Power Platform – Frequently Asked Interview Questions.

Image
Hello Guys, In our previous blog , we discussed some useful tips to prepare for interviews on Business Rules. Today, we will look at some important JavaScript tips and interview questions related to Dynamics 365 CRM. Do follow us to know more about Dynamics and Power Platform.  Also if you like our blog then please comment and share this blog with your friends. The client API object model for model driven apps provides you objects and methods that you can use to apply custom business logic in model driven app using JavaScript. These includes: Gets or sets attribute value. Show and hide user interface elements. Reference multiple controls per attribute. Access multiple forms per entity. Manipulate form navigation items. Interact with the business process flow control. Let's see what questions can be asked by interviewers. 1. How do we start using JavaScript in Dynamics 365 CRM? The First Step to Use JavaScript in Dynamics 365 CRM (Dataverse) JavaScript cannot run directly in Dy...
Read more

Read Only Sub Grid & Editable Sub grid in Dynamics 365

Image
Hello Guys, In my previous blogs we have seen Duplicate Detection in Dynamics 365 where we covered how you can use OOB feature of D365 to detect duplicate records. Today we will see how we can implement editable sub grid.  But before if you are new to our blog then do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. In Dynamics CRM we have seen many entities sharing parent child relationships and we can create records of child from the parent page. For example Account and Contact Entity. We can create a new contact entity from the Account Form with the help of Sub Grid control. We can also create sub grid for custom entity and can utilize it in our own way. We will be using Department and Employee Entity for demonstration. Below are the steps: Step 1:- Login to Dynamics 365 with credentials. Step 2:- Click on Advance Settings Gear icon. Navigate to Settings -> Solution -...
Read more