Logic App SQL Connector attribute filter

László Marton 21 Reputation points
2021-03-17T10:21:14.867+00:00

Hi folks,

I am facing the following situation: we use Logic Apps to integrate Dynamics 365 CE (Field Service) with on-premises SQL DB. The "When an item is modified (V2)" trigger is used to synchronize the row updates from the SQL DB to D365. In most of the cases it works fine, however, in one table there is a field which is updated frequently. This leads to trigger the flow unnecessarily.

I know that for "When a record is updated" Common Data Service (now called Dataverse) connector there is the configuration "Filter Attributes" with which you can select the fields to trigger the Logic App. I am looking for a similar solution to the trigger "When an item is modified (V2)". Could you suggest some kind of solution?

Thank you very much,
Laci

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,969 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,536 questions
{count} votes