Switch Equal expression with multiple values

(0) Share

Report

Posted on by knandez05

146

Hello,

I am using the Switch function and have a Case that can be multiple options. What is the best expression I can use for this?

Can equal either one:

504

525

513

If so, send to Value = email address

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

henkenTech 135 on at

Like (1)

Report

Hey there - to my knowledge, Switch cases can only compare single values using "equals" as a comparator. "Contains" is not supported.

To do this, you could nest test switch case inside one of the branches of a condition. Use the "contains" comparator in the condition to catch the one case with several values and deal with the rest using the switch case.

Max

Was this reply helpful? Yes No
knandez05 146 on at

Like (0)

Report

Thank you for the response @henkenTech

Was this reply helpful? Yes No
henkenTech 135 on at

Like (0)

Report

@knandez05 wrote:
Thank you for the response @henkenTech
Please mark your question is solved if this was your solution. Thank you 😊

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Use this instead of Case:

or(or(equals(variables('numvar'),504),equals(variables('numvar'),525)),equals(variables('numvar'),513))

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
I would personally use a totally different method, especially if the number of conditions is going to grow. I would make a JSON array like this:

[ { "value": "504", "email": "paul@paul.com" }, { "value": "525", "email": "someone@somewhere.net" }, { "value": "513", "email": "jim@enterprise.com" } ]

Filter that array based on the value, and the take the email address. It's just cleaner and more scalable.

Do you get where I am coming from?

Was this reply helpful? Yes No
ozhally 16 on at

Like (0)

Report

I solved this by using an If statement on the switch.
Something like this;

If(And(condition1,condition2), case1,
If(And(condition1,condition3), case2,
If(And(condition2,condition3), case3,
case4)))

Hope that helps someone,
Cheers,
Dan

Was this reply helpful? Yes No