Answered

Fetch each Flow, service accounts and connectors for an Environment

(2) Share

Report

Posted on by AH-02011058-0

169

Is there a way to get the name of each Flow which is mine or has been shared with me? I also want to know which connectors its using and which account it uses to use the connectors.

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

Sort by

Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AH-02011058-0,

PowerAutomate admin apis and Microsoft.PowerApps.PowerShell are your friends.

Please let me know if this tharead helps.

We have a community thread here. Additinally, you have knowlege surfing this.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
AH-02011058-0 169 on at

Like
a
(1)

Report
Copy link

Link copied!

I put this code at the top of the script to make it run.

Install-Module -Name Microsoft.PowerApps.Administration.PowerShell

How do I get the name of the account eg a service account using each connector?

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AH-02011058-0,

You can try this command:

Get-AdminFlow -EnvironmentName "Default-<GUID>" | Select DisplayName, @{Name="Connectors";Expression={$_.Properties.connectionReferences.Keys}}

This shows which connectors (e.g., SharePoint, Outlook, Dataverse) are used.

Get-AdminConnection

This returns:

Connector type (e.g., shared_sharepointonline, shared_office365)

User principal (the account used for authentication)

Environment

Was this reply helpful? Yes No
AH-02011058-0 169 on at

Like
a
(1)

Report
Copy link

Link copied!
How does that fit in with the Powershell script you mentioned earlier. This is what I've tried. AccountDetails is blank.

$FilePath = "C:\FlowConnectorsAndAccounts\FlowsExport.csv" $Flows = Get-AdminFlow "Name" + "," + "Enabled" + "," + "Connectors" | Out-File $FilePath ForEach ($Flow in $Flows) { $FlowInfo = Get-AdminFlow -FlowName $Flow.FlowName -EnvironmentName $Flow.EnvironmentName $Connectors = $FlowInfo.Internal.properties.connectionReferences $ConnectorDetails = "" $Connectors.PSObject.Properties | ForEach { $ConnectorDetails += $_.Value.DisplayName + " | " } $AccountDetails = "" $Connectors.PSObject.Properties.connectionReferences.Keys | ForEach { $AccountDetails += $_.Value.DisplayName + " | " } ($Flow.DisplayName.Replace(","," ")) + "," + $Flow.Enabled + "," + $ConnectorDetails + "," + $AccountDetails | Out-File $FilePath -Append }

Was this reply helpful? Yes No
AH-02011058-0 169 on at

Like
a
(0)

Report
Copy link

Link copied!
I can run
Get-AdminFlow

However when I try Get-AdminConnection I get this error message.

Get-AdminConnection : The term 'Get-AdminConnection' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the
name, or if a path was included, verify that the path is correct and try again.

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Instead of Get-AdminConnection, you should use:

Get-AdminConnectionReference -EnvironmentName "Default-<GUID>"

Was this reply helpful? Yes No
AH-02011058-0 169 on at

Like
a
(0)

Report
Copy link

Link copied!

I typed Get-AdminConnectionReference -EnvironmentName "Default-xxx". I also tried without Default-.

Still saying

The term 'Get-AdminConnectionReference' is not recognized as the name of a cmdlet

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Did you import mdoule like this?

Import-Module Microsoft.PowerApps.Administration.PowerShell

Can you please do some study on this item: Get-AdminPowerAppConnectionReferences

Was this reply helpful? Yes No
AH-02011058-0 169 on at

Like
a
(1)

Report
Copy link

Link copied!

AdminPowerAppConnectionReferences pertains to powerapps rather than Flows.

We're trying to keep track of which Flows use which Service accounts and for what purpose. This will help us track where we're spending money and avoid our Flows being throttled.

Thanks for taking the time to respond to my questions, but I don't think I have what I need.

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

We have to find a way! How urgent it is? Are you up for use PowerAutomate to acheive the same?

Was this reply helpful? Yes No