PowerPlatform : PowerAutomate – fetch all PowerAutomates and respective connection details used in 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

• Once we added this action we need to select the Environment as

• Complete flow looks like –

• Since we selected an option to “Manually trigger a flow“, we will test the flow using “Test” option available right hand side top corner

• Run the flow as

• 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

• 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

• 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.in/?s=power+platform

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