Unanswered

Trouble with Control Condition with multiple criteria

(1) Share

Report

Posted on by tcourter

Hello,

I've got a flow that is triggered by responses to a Form. What happens after the Form response is recorded is a fairly complex web of If "this" is true, then do "that."

To keep it more simple for the sake of my example, let's say there are 3 boxes - one that says "Type," one that says "Location," and one that says "Position." There are many options for each of those boxes, so let's use this table as an example:

Now let's say my goal is to make it so that IF Type = Verbal, AND Location = Philly OR NYC, AND Position = Associate OR Manager OR Assistant Manager, THEN send an email to PERSON1. But if IF Type = Verbal, AND Location = LA OR Chicago, AND Position = Associate OR Manager OR Assistant Manager, THEN send an email to PERSON2.

Below is a screenshot of how I have it setup now. It does trigger now, but not exactly the way it should.

Before, I had all 3 And/Or boxes set to AND, but it wouldn't trigger at all. Once I set them to Or, it triggers, but it's not checking that all the statements are true, only the first "Type" statement. So, since there's 4 similar scenarios, it's triggering all 4 of them instead of just the one.

I hope this makes sense and someone has encountered this before and can help, as it would be greatly appreciated!

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

Hi @tcourter

Based on the description your flow mapping is not quite right.

This is your requirement.

IF Type = Verbal
AND Location = Phily OR NYC
AND Position = Associate OR Manager OR Assistant Manager Then Email Person 1

IF Type = Verbal
AND Location = LA OR Chicago
AND Position = Associate OR Manager OR Assistant Manager Then Email Person 2

Based on the above I have normalised the IF statements. The below highlighted conditions are same for both scenarios.

IF Type = Verbal

AND Position = Associate OR Manager OR Assistant Manager
IF Location = Phily OR NYC Then
Email Person 1
ELSE IF Location = LA OR Chicago
Email Person 2

This is the IF condition you want in Flow. Here I have declared three variables Type, Position and Location.

Was this reply helpful? Yes No
tcourter 17 on at

Like (1)

Report

I think your 2nd picture put it into perspective for me. I've got to nest my Control Conditions within the "If yes" statements to create multi-conditional checks. That makes sense! I will give it a try and respond back if that works!

Was this reply helpful? Yes No