Hello--I'm trying to use the switch control to do conditional branching. I need the V3 email to route to a different person depending on the options selected in the form. The flow is working, except the CASES aren't working. I only get an email from the default CASE. What are some things that might cause this to occur?
Solved! Go to Solution.
Hey @Ciarlies
The output of the Choice type answer for MS Form will be string, To parse the string to an array use the JSON expression:
My Form -
Power Automate Solution - Is to use the Join and pass the choice column as JSON -
json(<choice Column>)
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @Ciarlies
Is the question that you are trying to switch on, a multi select choice type? Can you please check that once?
For single select choice questions, you can directly type in the choice to compare in the switch case. For multiple select choice type, you will have to type in the choice along with the [""].
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
@yashag2255 Hello, thank you so much! Yes, the options on the form ARE multiple select choice types.
Perhaps I am not following your instruction properly -- When adding ["Choice"] the error is **Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The template action 'Switch' at line '1' and column '3898' is not valid: the value '[ "Back-Up Care Program" ]' specified for 'case' property in switch case 'Case' is not allowed. Only values of types string, number or a '@parameters()' expression that evaluates to a number or a string is allowed.'.'.**
When adding [Choice] the flow runs but Action Branching Condition Not Satisfied.
Hey @Ciarlies
The output of the Choice type answer for MS Form will be string, To parse the string to an array use the JSON expression:
My Form -
Power Automate Solution - Is to use the Join and pass the choice column as JSON -
json(<choice Column>)
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hello @CFernandes @yashag2255
It worked! I used the join operation with the expression json(<choice Column>) in the From: field along with the separator [""] in the Join with: field.
The email was received as expected! Thank you both 😊
Wohoo 😁 I am glad the solution worked...