Answered

Triggers condition - depending on value in a related entity

(2) Share

Report

Posted on by simonsnell

Hi folks,

I am trying to create trigger conditions which fire when a related Campaign on a related entity meets criteria. I have tried putting the odata query into the "filter rows" but can't get it to work, so wondered if I can put this in the Trigger Conditions (under Settings) for the trigger?

Basically, on creation of a new Income Line, I only want it to trigger when the related Income record has a certain related Campaign. Is this even possible?

Here's the odata filter query I attempted to use in the filter rows query:-

(nfp_incomeid/_nfp_campaignid_value eq 1c1d0ad7-48a0-4b17-a548-5e764ec3be00)

The nfp_incomeid is the related income record attached to the Income Line.

Hope this makes sense!

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

slemale 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi simonsnell,

Did you find a solution to this problem ?
I am also interested to know how to do that.
Thanks.

Sébastien.

Was this reply helpful? Yes No
Verified answer

OliverR-82 623 on at

Like
a
(1)

Report
Copy link

Link copied!

Trigger conditions can only reference fields that are part of the trigger body. If the field that defines whether or not a flow should run is not part of the trigger body, then it's not possible to use it to configure a trigger condition. So, in short: no, what OP wants to accomplish is not possible. You would need to build the logic that checks for the condition into your flow.

Was this reply helpful? Yes No
slemale 13 on at

Like
a
(2)

Report
Copy link

Link copied!

Thanks OliverR-82.
I was not able to find this clear information. Too bad... 90% of my triggered flows will end without doing anything. It would have been great to have this possibility to reduce number of triggered flows.

Was this reply helpful? Yes No
Shap1 144 on at

Like
a
(0)

Report
Copy link

Link copied!

@OliverR-82 @simonsnell @slemale - Just checking in, since it's been a couple years, if there's a possible solution to this. I am running into the same issue where I need to check a related entity as part of the trigger. This would reduce my run rate by roughly 99%.

Was this reply helpful? Yes No
simonsnell 24 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi - no update from me, sorry.

Was this reply helpful? Yes No