I am using Flow to watch 5 columns in a Sharepoint list ("Person 1", "Person 2", etc). I have 1 switch per column, and everything works great unless a Switch is not activated. If there switch doesn't find a "true" it fails - but I would like it to just skip to the next switch/evaluation. I see the Default action in the switch, but I don't know how to set Default = skip to next step.
Solved! Go to Solution.
Can you explain a bit more what you are trying to accomplish? If none of the other cases match in a switch it will automatically use default, which will drop through to the next action if you don't put anything in it.
Are you actually testing 5 different variables using the switches? Can you expand them and show the cases inside the switch?
Thanks for the prompt reply @Pstork1 !
The 5 columns are "Choice" columns, and the choices are peoples' names. This is a way to designate technicians that are working on a project. I have PowerAutomate sending an email to each person if they're specified from the drop down. So:
Unfortunately if only column 1 is specified, the flow fails at Switch 2, saying it is Null. It doesn't continue through Switch 2 to Switch 3.
When you put the value to be evaluated in each switch put it inside a coalesce() function. Taht way if the value is null it will substitute the alternate value. For example lets say Tech 2 is null
will then evalutate the switch using 'default' not the null value for Tech2. You can supply any default value you want. Since there isn't a case for default it will fall through the default case.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks