Skip to main content
Power Automate
    • Connectors
    • Templates
    • Digital process automation
    • Robotic process automation
    • Business process automation
    • Process advisor
    • AI Builder
  • Pricing
  • Partners
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Business process and workflow automation topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Using Connectors
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • Process Advisor
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Connector Development
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Galleries
    • Community Connections & How-To Videos
    • Webinars and Video Gallery
    • Power Automate Cookbook
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Galleries
    • Power Automate Cookbook
    • Get all the Flows connected to a SharePoint List/L...

    Get all the Flows connected to a SharePoint List/Library

    04-29-2021 11:14 AM

    NiloferA
    Solution Supplier
    8602 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    NiloferA
    NiloferA Solution Supplier
    Solution Supplier
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Get all the Flows connected to a SharePoint List/Library

    ‎04-29-2021 11:14 AM

    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. NiloferA_1-1619718036157.png

         

    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. NiloferA_2-1619718168833.png

           

    3. Add "Filter" Array action to keep the Flows which have a SharePoint Connection
      1. NiloferA_3-1619718195577.png

         

    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. NiloferA_4-1619718404637.png
        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. NiloferA_5-1619718517282.png
        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. NiloferA_6-1619718706452.png
      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. NiloferA_7-1619718882361.png
      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!

     

    GetFlowsConnectedtoSPList_20210429181339.zip
    Labels:
    • Labels:
    • Button flows
    Message 1 of 2
    8,602 Views
    5 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    CFlorian
    CFlorian
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-15-2022 02:37 PM

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

    Up to that point it works great! 

    Message 2 of 2
    814 Views
    0 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing

    • © 2023 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices