List flow schedules

[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

[DamoBird365]

Try list flows as admin...

Damien

[Thomas_Petersen]

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? 🙂

[Agnius · Accepted solution]

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.

[Gabriel-SC]

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?

[Gabriel-SC]

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.

[Agnius]

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.

[Gabriel-SC]

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

[Agnius]

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.

[Gabriel-SC]

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)

[Agnius]

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.