A switch inside of a condition inside of a apply to each

[schuess3]

Have you ever come across this or do you have some insight for me?

Background

I have an apply to each evaluating rows of an excel table.

I have a condition inside of that apply to each that checks if a date column equals today

If the condition is met, there is a switch condition that looks at a status value and then performs an action

Problem

No matter what i put in a switch case, it fails with the following error message

"ActionConditionFailed. The execution of template action '[ACTION NAME HERE]' failed: an unexpected exception encountered when evaluating branching condition."

Again, no matter what i put under the switch case it fails. 

THoughts? @faustocapellanj @Pstork1 @Flownaut @RezaDorrani @Shanescows 

[Pstork1 · Accepted solution]

I have nested switches inside conditions inside Apply to Each loops so its definitely possible.  Looking at your screen shot I suspect the problem may be your evaluation condition.  Switch is built to work by evaluating a string, but it looks like the value comes out as an integer.  Have you tried making sure that you end up with a string and not a number?

[schuess3]

Well @Pstork1 you pretty much nailed it. I guess it is too much to ask for a message that says "expecting string, but received integer instead" 🙂

As a recap, if you are using a switch condition, and you want to put a numeric character like 1, 2, or 3, the switch condition seems to evaluate down the correct path, but then throws an error. Apparently, you need to put a text string in the case.

Thanks for your help.