Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Dataverse trigger for virtual tables (using virtual connector provider)

(0) ShareShare
ReportReport
Posted on by 186

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 Docs . 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?

Categories:
  • Drew Poggemann Profile Picture
    Drew Poggemann 9,273 on at
    Re: Dataverse trigger for virtual tables (using virtual connector provider)

    Hi @LKS ,

     

    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-table-event-support#use-the-messages-to-notify-dataverse-of-changes 

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics