Create a power automate to fetch all the actions used in all flows in each environment.

(0) Share

Report

Posted on by svramkuna

167

Microsoft has announced that SQL Server Connector V1 actions will be retired.

So, using flow how to list/fetch all the "actions name" and "operationId"(check the host.operationId value) for all Flows in each environment & check if the action contains V1 action and send a list of those in email or export to excel using power automate flows.

Need help in creating the flow for this.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

narayan225 2,547 Super User 2025 Season 2 on at

Like (0)

Report

@svramkuna

You can use two actions to get that.

1. List flows as admin action

2. Get flow as admin action under apply to each of the results of above action.

This will give you all the flows and all the actions for each of the flow.

Power Automate Management - Connectors | Microsoft Learn

This is what CoE Starter Kit uses as well. If you have CoE Starter Kit, you should already have this data.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
svramkuna 167 on at

Like (0)

Report

Hi @narayan225 ,

Thankyou for the response. The below is the step by step flow creation:

Could you help here. Thankyou in advance for your help!!

Was this reply helpful? Yes No
narayan225 2,547 Super User 2025 Season 2 on at

Like (0)

Report
Hi There,

What I recommend you do is:

Get all flows as admin

Parse the triggers and action.

Then loop through all the actions and store them in a list or a file.

Reference: CoE Starter Kit

Hope this helps.

Cheers!

Was this reply helpful? Yes No