Please note that our forum is a public platform, and we will modify your question to hide your personal information in the description. Kindly ensure that you hide any personal or organizational information the next time you post an error or other details to protect personal data.
Dear Gizeh Triana Cardenas
Welcome and thank you for sharing your issue in the Q&A forum.
Based on the information you described, I understand that you're experiencing inconsistent behavior with the FlowRun and FlowEvent tables in Dataverse. You noticed that they are not displaying any rows, even though you have numerous Cloud flows running daily and the 'Cloud flow run history in Dataverse' feature is enabled.
Based on my research, the issue could stem from several reasons related to environment configuration, flow type, or licensing. The FlowRun and FlowEvent tables are specifically used to store the run history of Cloud flows (Power Automate) in Dataverse when the feature is enabled.
Here are the potential causes:
- Flow Type: Not all Cloud flows record their run history into Dataverse.
- Environment Scope: The history is only recorded for flows created within or belonging to that specific Dataverse environment.
- Solution-Aware Status: Although the flows are solution-aware, there might be specific licensing or connection requirements.
- Licensing: Recording data into Dataverse may require a Dataverse license or Power Automate Premium (formerly Per User/Per Flow) license. Developer/Trial environments may have limitations.
- Delay: There might be a slight delay between when the flow runs and when the data is written to Dataverse.
Please try a couple of workarounds to confirm this:
- Ensure the flow is in a solution and run it after enabling the feature.
- Re-check the TTL (Time to Live) setting (14 days or 28 days).
- Create a simple flow within a solution, test run it and then check the tables.
Reference: https://community.dynamics.com/blogs/post/?postid=af89fe6a-cb1d-ef11-9f89-000d3a1376b8
However, while we are always ready to help on this forum, your question is specific to a Power Platform/Dynamics 365 product. For the best and most in-depth support, I would highly recommend posting your question on the official Dynamics 365 Community. The experts and MVPs there specialize in these product-specific issues and will be better equipped to help you.
I hope this explanation helps!
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.