web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 45

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:
I have the same question (0)
  • Mira Ghaly Profile Picture
    11,413 Moderator on at
    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.

     

  • drhorg Profile Picture
    45 on at
    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!

  • AhmedSalih Profile Picture
    6,678 Moderator on at
    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:

     

    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 Profile Picture
    45 on at
    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!

  • drhorg Profile Picture
    45 on at
    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.

  • Mira Ghaly Profile Picture
    11,413 Moderator on at
    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/

     

  • asoguero Profile Picture
    15 on at
    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!!

  • Community Power Platform Member Profile Picture
    on at
    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

  • asoguero Profile Picture
    15 on at
    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: 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics