cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lkaspar
Resolver I
Resolver I

Dataverse trigger for virtual tables (using virtual connector provider)

Hi all

 

I created a virtual table called crd20_dbo_capexregisterazure using the SQL virtual connector provider as described here: Create virtual tables using virtual connectors (Microsoft Dataverse) - Power Apps | Microsoft Docs. I am able to perform CRUD operations on the table in the context of Power Automate and Power Apps. 

 

I then enabled notification APIs for the OnExternalCreated, OnExternalUpdated, and OnExternalDeleted messages as described here: Enable Virtual Tables to support Dataverse events (Microsoft Dataverse) - Power Apps | Microsoft Doc... . I've verified this by inspecting the $metadata document:

 

lkaspar_0-1658214925725.png

 

 

I am now trying to use the When a row is added, modified or deleted Dataverse trigger to be notified about CUD events. However, the trigger is not firing.

 

If I am reading Use the messages to notify Dataverse of changes documentation correctly, I would need to notify Dataverse myself. This is not mentioned anywhere in the Known limitations documentation.

 

Does anyone know if it's possible to use the Power Automate Dataverse trigger to get notified of changes or do we need to cater for this ourselves?

1 REPLY 1
dpoggemann
Super User
Super User

Hi @lkaspar ,

 

If I am not mistaken, since this is an external datasource, that you do not control, you would need to notify Dataverse using the messages defined in the configuration.  The following walks through this:  https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/enable-virtual-... 

 

Might be better off using the SQL Triggers for when an Item is created or an item is modified from the SQL table.  

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (1,308)