Answered

List flow schedules

(1) Share

Report

Posted on by Thomas_Petersen

Hi guys

I want to make a cloud flow that returns all the recurrence trigger details. The plan is to make a model driven app to help govern the flows and especially make some sort of scheduler!

I tried the "List My Flows" action in the "Power Automate Management" category, but the information I need isn't available.

You guys know how to get it?

Sincerely

Thomas H. Petersen

Droids Agency

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Try list flows as admin...

Damien

Was this reply helpful? Yes No
Thomas_Petersen 86 on at

Like (0)

Report

Hey Damien

Thanks for replying, trying the "as admin" action is a good shot, unfortunately I still don't get any info about the recurrence:

Do you have something else up your sleeve? 🙂

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report
When you have a list of flows, you can pass the name of the flow into the "Get flow" action (cannot really give you a screenshot of that, as it's localized on my end). This will return the whole payload for the specific flow. And for instance, when I ran it on one of mine, the payload included this:
"triggers":{"Recurrence":{"recurrence":{"frequency":"Day","interval":1,"startTime":"2021-01-28T09:00:00Z"},"type":"Recurrence"}}
This was a sample flow that has, as you can see, a recurring daily schedule. But you can obviously see all of the data you need there. It's just that you can't really get this in a list of all flows, but you can loop through your list and use this.

Was this reply helpful? Yes No
Gabriel-SC 11 on at

Like (0)

Report

When I try to do exactly as "AgniusBartninka" explained, I can't retrieve that same line as him, it just appears ([{"type":"Request","kind":"Button","metadata":{"operationMetadataId ":"xxxxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxxxx"}}]) with the MetaDataId, can someone explain to me better how I can rescue the Flow schedule and write it in Excel?

Was this reply helpful? Yes No
Gabriel-SC 11 on at

Like (0)

Report

I want to make a flow that lists the other flows and captures the schedules and writes them in excel, pls someone help me, i'm new using PA.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

This is because this flow is not scheduled. It is an automated flow that runs when you press a button. You can only see schedule details on flows that are in fact scheduled.

Was this reply helpful? Yes No
Gabriel-SC 11 on at

Like (0)

Report

Yes, that's true, but even the ones that are scheduled don't appear exactly what I wanted them to appear, when I use the function to write the "Triggers" in Excel it still appears like this: [{"type":"Recurrence","metadata":{"operationMetadataId":xxxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"}}] But not with the time as in your example, is there any function missing?

I'm using this flow:
Among the flows listed there are flows that are repeated every 1 month, 1 week, 1 day, 1 hour and 1 minute

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

Well, it might be that the output of the action has changed. What I suggested above was posted 2 years ago. I haven't tested this myself since. It may be different by now. If you have the sample outputs, you would need to adjust your flow to work with what you get.

Was this reply helpful? Yes No
Gabriel-SC 11 on at

Like (0)

Report

The solution for this that I found and it's working well, was after "Get Flow" used this "Parse JSON" passing the "Flow Definition" as a parameter for me to use its variables, the schedule I want, in this case the time, I'm using this expression
"@{body('Parse_JSON')?['triggers']?['Recurrence']?['recurrence']?['startTime']}"

It returns exactly the time that was scheduled to run in my flow, and with this same syntax it is possible to retrieve any JSON value just by changing the keys, (I don't understand much about JSON but it's working)

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

Well, that is exactly the same payload that I showed in the sample in my original reply. Of course you would need to use Parse JSON. But the important thing is that the schema is still the same, unlike what it seemed like from your previous messages.

Was this reply helpful? Yes No