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!
C
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
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:
Share
Report
All responses (
Answers (
[
{
"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?
Use this instead of Case:
or(or(equals(variables('numvar'),504),equals(variables('numvar'),525)),equals(variables('numvar'),513))
@knandez05 wrote:Thank you for the response @henkenTech
Please mark your question is solved if this was your solution. Thank you 😊
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
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
