PowerPlatform : PowerAutomate – fetch all PowerAutomates and respective connection details used in tenant using PowerAutomate

PowerAutomate to fetch all the flows / PowerAutomate from the tenant using PowerAutomate
PowerAutomate to fetch all the flows / PowerAutomate from the tenant using PowerAutomate

Hi All,

Greetings for the day 🙂 LIFE IS BEAUTIFUL 🙂

Background: My management has asked to list all PowerApps / PowerAutomates where SharePoint connection is used in our M365 tenant. This is something new for me so research and then found an option of PowerShell script for listing PowerApps and respective connection details. But for PowerAutomate there is bit different approach which we will discuss in this article

For the similar kind of scenarios we have couple of previous articles please have a look once –

PowerPlatform : PowerApps – PowerShell script to list all PowerApps and respective connections used from the M365 tenant

PowerPlatform : PowerAutomate – fetch all PowerAutomates which are using specific connection (Example – SharePoint) from PowerAutomate user interface

Details / Steps :

  • To fetch all PowerAutomates and respective connection details from our M365 tenant we have an option of PowerAutomate it self
  • There is PowerAutomate action available – “List My Flows”  which returns list of all PowerAutmates and details (properties, connection details) which are accessible to me and output in JSON format
PowerAutomate  - action "List My Flows
Fig : PowerAutomate – action “List My Flows”
  • Once we added this action we need to select the Environment as
PowerAutomate  - action "List My Flows - Selecting the environment
Fig : PowerAutomate – action “List My Flows – Selecting the environment
  • Complete flow looks like –
PowerAutomate  - for getting all the flows and details from the selected environment
Fig : PowerAutomate – for getting all the flows and details from the selected environment
  • Since we selected an option to “Manually trigger a flow“, we will test the flow using “Test” option available right hand side top corner
PowerAutomate  - Manually testing the flow
Fig : PowerAutomate – Manually testing the flow
  • Run the flow as
PowerAutomate  - Running the flow
Fig : PowerAutomate – Running the flow
  • Once flow / PowerAutomate ran successfully we are ready to see output 🙂
  • Please have a look at below fig we have each flow / PowerAutomate properties are available with connection details
PowerAutomate  - Flow / PowerAutomate properties - output of the flow
Fig : PowerAutomate – Flow / PowerAutomate properties – output of the flow
  • As in above snap, please click on “Show raw outputs” which will open pane with details
  • Please have a look below snap – we have “connectionReferences” property having all connection details available
PowerAutomate  - Flow / PowerAutomate properties with connection details- output of the flow
Fig : PowerAutomate – Flow / PowerAutomate properties with connection details- output of the flow
  • With “connectionReferences” properties we get following important connection details / properties which we mostly required:
    • Connection Name
    • Connection ID
    • Connection DisplayName
    • Connection Tier (Standard / Premium)
                        "shared_sql_1": {
                            "connectionName": "shared-sql-a6879bb6-178b-4e19-a7b1-354d-a60151b1",
                            "source": "Embedded",
                            "id": "/providers/Microsoft.PowerApps/apis/shared_sql",
                            "displayName": "SQL Server",
                            "iconUri": "https://connectoricons-prod.azureedge.net/releases/v1.0.1506/1.0.1506.2523/sql/icon.png",
                            "brandColor": "#ba141a",
                            "tier": "Premium"
                        },

                        "shared_sendmail": {
                            "connectionName": "shared-sendmail-b71ff49c-c31d-4d31-a326-057bcb4b883d",
                            "source": "Embedded",
                            "id": "/providers/Microsoft.PowerApps/apis/shared_sendmail",
                            "displayName": "Mail",
                            "iconUri": "https://connectoricons-prod.azureedge.net/master/1.0.1510.2535/sendmail/icon.png",
                            "brandColor": "#008299",
                            "tier": "Standard"
                        }

Knowledge Junction has good series of articles on Power Platform, please have a look once for more details – https://knowledge-junction.com/?s=power+platform

Thanks for reading 🙂 If its worth at least reading once, kindly please like and share 🙂 SHAREING IS CARING 🙂

Prasham Sabadra

LIFE IS VERY BEAUTIFUL :) ENJOY THE WHOLE JOURNEY :) Founder of Knowledge Junction and live-beautiful-life.com, Author, Learner, Passionate Techie, avid reader. Certified Professional Workshop Facilitator / Public Speaker. Scrum Foundation Professional certificated. Motivational, Behavioral , Technical speaker. Speaks in various events including SharePoint Saturdays, Boot camps, Collages / Schools, local chapter. Can reach me for Microsoft 365, Azure, DevOps, SharePoint, Teams, Power Platform, JavaScript.

You may also like...

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: