Unanswered

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

(0) Share

Report

Posted on by 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,

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (9)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
drhorg 45 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
drhorg 45 on at

Like (0)

Report

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

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!

Was this reply helpful? Yes No
drhorg 45 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
asoguero 15 on at

Like (0)

Report

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

Hi @drhorg, hope you are well

Did you find the solution?

I'm trying to find exactly the same.
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?

I'm able to get all the information related to Desktop flows but not to Cloud flows.

Thanks!!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Hi @drhorg ,

Did you find any solution for the same?

Thanks

Was this reply helpful? Yes No
asoguero 15 on at

Like (0)

Report

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

Hi @drhorg @Anonymous

I think I've found the response to this. The Power Platform components that want to be accessed via Dataverse API should belong to a Power Platform Solution. Then by using the name of the tables you can access Dataverse content via API. See screenshots below:

Screenshot_2.png

Screenshot_1.png

Was this reply helpful? Yes No