question

LszlMarton-9973 avatar image
0 Votes"
LszlMarton-9973 asked JayaC-MSFT answered

Logic App SQL Connector attribute filter

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-appspower-query-not-supported
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@LszlMarton-9973 Thank you for the question. We will review and update at the earliest.

0 Votes 0 ·

1 Answer

JayaC-MSFT avatar image
0 Votes"
JayaC-MSFT answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.