cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drhorg
Helper II
Helper II

Query Dataverse table and column for cloud flow run status (or API call)

on a PowerApps/Dynamics 365/Dataverse environment I would like to find for a cloud flow the status and info for each run.

1. Can you please let me know which are the DV tables/columns containing this?

2. Alternatively can you please let me know the API call?

 

Much appreciated,

6 REPLIES 6
Mira_Ghaly
Dual Super User
Dual Super User

@drhorg 

You can open the flow and check the flow run history from there you can check the status whether it failed or succeeded but I am not aware of a way to determine your API calls on the flow automatically.

There is an analytics tab on the Edit flow screen this gets the number of API calls for all runs per day, so you can get the number of runs of it easy from the flow run history and then divide the total per day to the number of runs so you can get an idea.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
drhorg
Helper II
Helper II

@Mira_Ghaly thank you for your reply, unfortunately this is not what I mentioned in my original post. 

Hi everyone, I would very much appreciate if can help me with my original questions: 

" 1. Can you please let me know which are the DV tables/columns containing this?

2. Alternatively can you please let me know the API call?"

 

Thank you so much for input!

AhmedSalih
Super User
Super User

Hello, @drhorg, The Flow Session entity in your Default Solution in the Dataverse will be blank. According to Microsoft the data are not available as of July 2021. I checked for any updates and I found nothing.

However, I use the https://flowstudio.app/about tool to track my flows.  You only need the free features:

 

AhmedSalih_0-1658203894592.png

 

Here an example:

FlowStudio.gif

 

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.

drhorg
Helper II
Helper II

Hi Ahmed, Thank you for reply. but will not able to install third party, it has to be MS product.

Hi Everyone, is there any reply to my original post? 

" 1. Can you please let me know which are the DV tables/columns containing this?

2. Alternatively can you please let me know the API call? "

 

I am hopeful that this data is stored in one of the Dataverse tables (APIs), even if will need some parsing.

Thank you so much!

drhorg
Helper II
Helper II

Hi everyone, is there no answer for my original question? Many of us would benefit from knowing this and could use in flows monitoring. as mentioned I need to find quickly by quering either an api or Dataverse/dynamics and unfortunately I cannot add a third party into the system, and also the idea to checking each flow one by one from many dozens is not feasible

 

Please let me know if you know the answer to my original post.

@drhorg 

 

You can explore the API for the flow runs history please check my below blog post if it helps:

https://onlinemgblog.wordpress.com/2021/05/08/custom-connectors-get-flow-runs-history/

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,140)