Filter row on dataverse trigger

[RK2021]

Hi All

I am building a flow which should trigger when a standard yes/no column is Yes.

I have the Dataverse added/modified trigger but can't seem to get the right row filter.

The column is can_sendemail but can't get the right eq value afterwards. Have tried in quotes, using 1 instead of Yes, true, True etc.

Would appreciate some help

Thanks 

[MarconettiMarco]

Hello @RK2021 ,

please add the following expression in the Trigger Conditions Settings:

@equals(triggerOutputs()?['body/can_sendemail'], false)

put false or true based on your needs.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[RK2021]

Hi @MarconettiMarco - thanks for your reply

I used your condition in the settings, changing from false to true as per my requirements. However, the flow failed to trigger. The same happens without a condition but only when specifying can_sendemail as the column change to run on. 

The flow only seems to run without conditions on the trigger. I added a condition step within the flow on similar logic and this works as expected. Its acceptable but leads to needless flow runs that are then cancelled when condition isn't met.

[MarconettiMarco · Accepted solution]

Hello @RK2021 ,

please try to build the expression adding a "Do until" loop like below:

Then select "Edit in advanced mode:

Copy the expression in the Trigger Conditions, it must work.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco