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

[drhorg]

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,

[Mira_Ghaly]

@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.

[drhorg]

@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]

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:

Here an example:

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]

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]

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.

[Mira_Ghaly]

@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/