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.
Power Platform Specialist | Governance, ALM & Licensing Expert | AI Trainer
4 个月Have you been able to use this table in Power BI?
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"?
Dynamics 365 & Power Platform Consultant p? CRM-Konsulterna
6 个月Christian Palmé l?r ju vara intressant f?r dig
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.
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