Listing flows and their owners across a tenant

[deacaroo]

Hi there,

I'm looking to introduce a bit of discipline into our flow creation/management and want to coordinate this using a SharePoint list. The idea is to populate all Flows across all environments on the list and then add the owners to a multi-person field.

I've managed to list all the flows and write these to the list but I stuck at listing the owners!

- I've tried the 'List Flow Owners' action, but this only returns flows which the connection is named as an owner (I need to list ALL owners for ALL flows in our tenant!).

- I've also looked into the 'Get Flow Owner Rols as Admin (preview)' action - but again, I can't see any easy way to access owners from that and the documentation is sparse to say the least.

Any help greatly appreciated!

Thanks

Ben

[RezaDorrani]

Hi @deacaroo 

You can use the List Flows as admin action  to list all the Flows within that envrionment

and then for each loop of the previous action - use the List Flow Owners to get the owners per flow

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[deacaroo]

Thanks for the response Reza - how do i extract the name from the resultant array then resolve it to an email address? Presumably it's best to load it into an array then pass direct to the multi-person field on sharepoint? Apologies - definitely at the edge of my capabilities here! Thanks,

Ben

List Owners response:

[

  {

    "name": "xyz",

    "id": abc",

    "type": "/providers/Microsoft.Flow/environments/flows/owners",

    "properties": {

      "permissionType": "Principal",

      "principal": {

        "id": "xyz",

        "type": "User"

      }

    }

  },

  {

    "name": "xyz",

    "id": abc",

    "type": "/prov...

[RezaDorrani]

Hi @deacaroo 

For loop the List Owners response

and within the loop use expressions to get the name use 

item()?['Name'] - expression

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[varietygrant]

So, in order to get a list of flows in an environment I need to either build a flow that creates an output file or dive into PowerApps to script the solution? There's no UI way to extract a list of flows? Trying to manage this in a business that has a significant number of flows is really hard. I'd be keen to hear how others prevent the proliferation of flows without locking it all down and doing strict change management on every flow in the organisation. 

[varietygrant]

How do you all keep track of all of this and prevent a huge mess as people join and leave the company?

 

[PPUser5]

Hello Ben,
Have you been able to acheive this? If yes, could you please let me know what step you used to fetch owner details of each flow?