Fetch the actions names used in all flow in each environment using power automate flow

(2) Share

Report

Posted on by svramkuna

167

Microsoft has announced that SQL Server Connector V1 actions will be retired. So, how to list/fetch all the "actions name" and "operationId" for all Flows in each environment that uses this "SQL Server Connector V1 action" and send a list of those 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 (10)

Answers (0)

Suggested answer

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@svramkuna Hi,

Please see below one as your reference, it's easy to add your own version.

list of environments.( Power Platform for admin).

Loop through each environment.

For each environment, list & get flows.

List Flows as Admin (Power Automate Management)

Apply to each to Get Flow (Admin).

Parse / Compose what you want. you can filter only contains SQL Server ones.

Write to a table or a file if you like.

Was this reply helpful? Yes No
Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

@svramkuna

Only to mention one thing (@stampcoin) gave the answer so just adding one small thing.

In the JSON you get back, you can see Triggers and Conditions.

So you can Filter/Select on that part of the JSON.

Depending on how many you have.. you may have to use a Do Until so you don't time out as well

Was this reply helpful? Yes No
svramkuna 167 on at

Like (0)

Report

Hi @stampcoin and @Michael E. Gernaey,

Thank you for your response. But could you please help me with the formula to filter only the SQL server ones whether it is using SQL Server Connector V1 action or not and export them to excel?

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@svramkuna Hi,

Once you follow the screen shot to do that ( there is no tricky or magical inside). you will get more detail in 'Get Flow as Admin', from there you will see the connection reference , and connection name in each actions.

what you only need is filter the information with your connectionName , it might contain 'sql' or 'shared_sql'

This is the journey we can take you so for.

the rest will be on your own.

good luck.

Was this reply helpful? Yes No
svramkuna 167 on at

Like (0)

Report

Hi @stampcoin ,

Thankyou for your help!. I have got the details from 'Get flow as Admin' and fetched 'actions' names.

So the below is the output. But how can I fetch these 'actions names' and 'operationId' from the output of 'keys of parse json' as it is of type object.

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@svramkuna Hi,

do you know for you SQL Server Connector V1， any loop has been used ? if any, is there nest loop？

Was this reply helpful? Yes No
svramkuna 167 on at

Like (0)

Report

Hi @stampcoin,

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
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@svramkuna Hi,

I will try that, meanwhile keep going. Could you please confirm that those two fields is exactly what you want ?

Was this reply helpful? Yes No
svramkuna 167 on at

Like (0)

Report

Hi @stampcoin,

Yes so, I have to list/fetch the 'actions name', 'operationID , 'flowname' and the 'owner name' into an excel which are using V1 actions.

Thanks in advance!!

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@svramkuna Great job.👍

Was this reply helpful? Yes No