question

LszlMarton-9973 avatar image
0 Votes"
LszlMarton-9973 asked ·

Is there any attribute filter for the trigger action "When an item is modified (V2)"?

Hi folks,

our situation is the following: we integrate Dynamics 365 CE with some on-premises SQL DB. This integration is solved using Azure Logic Apps. For several LAs we use the "When an item is modified(V2) trigger.

Unfortunately, in one table there is a field, which is updated frequently, hence, the Logic App triggers always. The desired solution would be, that the Logic App triggers only if the required fields are updated.

I know about the "Attribute Filters" for the "When a record is updated" trigger for Dataverse, however, there is no similar thing for the "When an item is modified(V2)". We tried to include the required columns to the "Select Query", however, this didn't solve our problem.

Could you please suggest some kind of solution?

Thanks in advance,
Laszlo

sql-server-generalazure-logic-appspower-query-connectors
· 1
10 |1000 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.

Hi, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered ·

Hi @LszlMarton-9973,

Welcome to Microsoft Q&A!

SQL server general tag is talking about the issues about SQL server. Your issue is related to Microsoft Flow also, please post your question in Official Microsoft Flow Community.

Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1 ·
10 |1000 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.

Okay, I will ask there and close here. Thank you for the correction!

In the case, somebody could help me, please write your suggestion to the other community: https://powerusers.microsoft.com/t5/Power-Platform-Integrations/Attribute-filter-for-the-trigger-action-quot-When-an-item-is/m-p/866852#M267.

0 Votes 0 ·