How to configure Logic App MS SQL trigger for Built-in connector

Aubrey Price 0 Reputation points
2023-03-14T21:32:03.6+00:00

We're migration ISE to ASE model due to deprecation of ISE. Trying to configure MS SQL workflow trigger to migrate from ApiConnector / Managed SQL Server connector to Logic App built-in connector. According to this article, SQL workflow triggers are supported:

https://learn.microsoft.com/en-us/azure/logic-apps/connectors/built-in/reference/sql/#triggers

Have tried both "When a row is modified" and "When a row is updated" but cannot get these to work. The Managed / Api connectors had a configuration for "How often do you want to check for items" but these new triggers do not seem to have this configuration element.

Has anyone had any success using SQL triggers with built-in connector model?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,972 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 53,026 Reputation points
    2023-03-20T08:16:46.74+00:00

    @Aubrey Price Thanks for reaching out. The SQL trigger requires change tracking to be enabled not with change data capture.

    The SQL trigger uses SQL change tracking functionality to monitor a SQL table for changes and trigger a function when a row is created, updated, or deleted. Internally it used the same as azure function as documented here.

    Therefor there is no configuration "How often do you want to check for items" as it uses the SQL change tracking.