Hi,
I have recently created a flow which is set to trigger on "When a row is added, modified or deleted" in Microsoft Dataverse. I've been able to select the table I want the trigger to listen to "Bevilgningsanmodninger" with table name: cr26b_bevilgningsanmodninger".
As this is just to test the functionality, I simply want to test that the flow is able to detect changes in the Virtual Entity Table.
The Virtual Entity Table is created with a connection to a Sharepoint List called "Bevilgningsanmodninger". Whenever I make changes in the Sharepoint List, these changes are indeed reflected in the Virtual Entity Table. In my mind, these changes in the Virtual Entity Table should then be registered and "picked up" by the trigger I have configured in the Power Automate Flow. However, no flows have been initiated.
Earlier, the "Flow Checker" stated the following:
Data events are not enabled for this virtual table. VirtualEntityMetadata configuration is missing.
That lead me to the following post: Power Automate flow error: Data events are not ena... - Power Platform Community (microsoft.com) which again led me to this guide on how to "enable virtual tables to support dataverse events": https://learn.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/enable-virtual-table-event-support
From that guide, I went on to create a separate solution, copy the existing Virtual Entity Table (Bevilgningsanmodninger) with table name: "cr26b_bevilgningsanmodninger" into the new solution. I also created the "metadata table for virtual entities" in that solution, and activated the signals to create external "create/update/delete" messages. I also added the Power Automate Flow into the same solution in the Power Platform.
However, still no flows are being run when I add new rows to the list in Sharepoint (which in turn ensures that new rows are created in the Virtual Entity Table linked to the Power Automate Flow).
Does anyone know why my flow is unable to detect the changes that indeed occur in the Virtual Entity Table?
Regards
Short update,
I tried the same approach, only this time by activating a table from Dynamics Fin&Ops as a Virtual Entity Table.
I got the trigger to work when I gave myself the "System Admin" role in Fin&Ops. However, this is not optimal. I want other users with Fin&Ops licenses to be able to create their own Power Automate Flows which listens for changes in the same Virtual Entity Tables without having to give them "System Admin" roles.
Which roles/access levels are required within Dynamics Fin&Ops and Power Automate in order for users to be able to detect "When a row is added, modified or deleted" from a dataverse virtual entity table that is linked to a Dynamics Fin&Ops table?