Get all the Flows connected to a SharePoint List/Library 04-29-2021 11:14 AM

[NiloferA]

There are times when it would be great to have a List of all the Flows deployed on a SharePoint List/Library. It's not pretty straight forward, but it's definitely possible.

I am creating a Flow with manual trigger here which will get you a list of all the Flows deployed on a SharePoint List with the 'when an item is created' trigger.

1. Add an action "List Flows as Admin" or if you only want to get Flows created by you, you can add "List My Flows" action. Both these actions fall under "Power Automate Management" Connectors. 
   1. ** Please note that I am using List My Flows actions which gives different output as compared to List Flows as Admins and will change the dependent parameters later in the Flow 
   2. 
2. Add "Select" action to get only the necessary fields from the output array
   1. Mapping Expressions:
      1. Name - item()['properties']['displayName']
      2. InternalName - item()['properties']['connectionReferences']
      3. Connections - item()['properties']['name']
      4. 
3. Add "Filter" Array action to keep the Flows which have a SharePoint Connection
   1. 
4. Initialize an Array Variable, we will need this in the next steps
5. Add an "Apply to Each" action and pass Body from Select action as an input, add the following actions within Apply to Each
   1. Add "Get Flow" action, select the Environment and configure the Flow input field as follows
      1. add the Expression - item()['InternalName']
      2. 

      3. **We need this step to get the Definition of the flow which contains detailed information about trigger and actions used in the Flow

   2. Add "Append to Array Variable" action and configure it as follows
      1. {
      2. "Name": "item()['Name']",
      3. "Definition": Flow Definition from Dynamic Content 
      4. }
      5. 

      6. ** We need this step to populate the Array with all the Flow Definitions for further processing

6. Add "Filter Array" action and pass the Array Variable as input and configure it as follows
   1.  Choose a value = add expression item()['Definition']['triggers']
   2. Condition = contains
   3. Value = When_an_item_is_created
   4. 

   5. ** We need this step to filter Flows with "When an Item is created" trigger

7. Add another "Filter Array" action and pass the Body from the Filter Array above as input and configure it as follows
   
   1. Choose a value = add expression item()['Definition']['triggers']['When_an_item_is_created']['inputs']['parameters']['table']
   2. Condition = contains
   3. Value = GUID of the List/Library
   4. 

   5. ** I am passing the GUID manually here but you can add another action to get the GUID of the List/Library by sending a rest query to SharePoint

There you go, you now have a list of all the Flows created by you and deployed on a SharePoint List/Library!

Hope this was helpful!

[CFlorian]

The operation "Get Flow" is not listed in the Choose an Operation list.

Up to that point it works great! 

[mattaroon]

I know this is older but do you know of a way to go the other way? I have a list of all workflows through the CoE but I'm struggling with the logic to get all the SharePoint lists/libraries that are affected by the workflows.