Cloud flow run history in Dataverse

Cloud flow run history in Dataverse


Official Microsoft documentation: https://learn.microsoft.com/en-us/power-automate/dataverse/cloud-flow-run-metadata

?

Your Cloud flow runs are only saved if Cloud flows are part of the solution!

?

Create cloud flow in a solution: https://www.dhirubhai.net/posts/jakubhomola_dataverse-powerplatform-powerautomate-activity-7179938628834316288-FCn8?utm_source=share&utm_medium=member_desktop

Add an existing cloud flow into a solution: https://www.youtube.com/watch?v=FIsm7L9XWoU

Add cloud flows to a solution by default: https://youtu.be/hBjwuFwM88Q


You enable the functionality in your instance settings https://admin.powerplatform.microsoft.com/

.
.

When enabled, every new cloud flow execution will have an entry in the "FlowRun" table to store the cloud flow run metadata. you can adjust the duration of how long the execution records are stored depending on your storage capacity needs.

.

The history of individual runs of your Cloud Flows is saved in the "Flow Runs" table.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="flowrun">
<attribute name="flowrunid"/>
<attribute name="name"/>
<attribute name="createdon"/>
<attribute name="workflow"/>
<attribute name="status"/>
<attribute name="starttime"/>
<attribute name="endtime"/>
<attribute name="duration"/>
<attribute name="errormessage"/>
<attribute name="errorcode"/>
<attribute name="triggertype"/>
<attribute name="ttlinseconds"/>
<attribute name="overriddencreatedon"/>
<attribute name="partitionid"/>
<attribute name="isprimary"/>
<attribute name="owningbusinessunit"/>
<attribute name="ownerid"/>
<attribute name="modifiedon"/>
<attribute name="modifiedonbehalfby"/>
<attribute name="modifiedby"/>
<attribute name="createdonbehalfby"/>
<attribute name="createdby"/>
<order attribute="name" descending="false"/>
</entity>
</fetch>        

According to the documentation, in the table, you will find the following information.

.

We can view the data through Advanced Find or by using the View option https://make.powerapps.com/

.

During tests, I experienced that the error message from Cloud Flow contained a more detailed description than the error in the "Error message" field. However, overall, the functionality works great.

.

Currently we can't modify the table, we can't edit the form either.

.
.


Lucas Carvalho Xavier

Power Platform Specialist | Governance, ALM & Licensing Expert | AI Trainer

4 个月

Have you been able to use this table in Power BI?

回复
Srikanth Reddy Singapuram

Enterprise Cloud Solution Architect || Dynamics 365 || Power Platform || Azure || Azure DevOps || Copilot || AI & Data

5 个月

It's an amazing feature. Is it possible to create a Dashboards by configuring the FlowRun table in the same manner as the "Power Automate Telemetry Integration with Application Insights"?

回复
Johan Weijden

Dynamics 365 & Power Platform Consultant p? CRM-Konsulterna

6 个月

Christian Palmé l?r ju vara intressant f?r dig

回复
Chris V.

Managing Director | Principal Consultant - Dynamics 365 & Power Platform Specialist | 0416 672 496

6 个月

I suspect this will be records stored against DB Storage (rather than log storage) ??. I love the idea of it, however if it is going to incurr significant costs for seeing logs then we would stick with our own solution for error handling etc.

回复
Paul Murphy

Microsoft 365 and Power Platform specialist, helping customers to collaborate, communicate and streamline processes

6 个月

Daniel Kerridge this could come in handy at the moment

要查看或添加评论,请登录

社区洞察

其他会员也浏览了