Answered

switch for a sharepoint list Choice thinks it's a boolean while it's a string

(0) Share

Report

Posted on by Erdem

hi,

I have a list with a choice in it. These choices are just text. When I create a switch case statement in Microsoft flow. I get the following exception:

ExpressionEvaluationFailed. De uitvoering van de sjabloonactie Schakeloptie is mislukt. Het resultaat van de evaluatie van de scope-actie voor de expressie @triggerBody()?['thechoice'] is ongeldig. Dit is van het type Boolean, maar er wordt een waarde van het type String, Integer verwacht.

=> Microsoft flow thinks my choice field is a boolean.

Strangly enough in the following post it is being said that this should just work:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Switch-case-based-on-SharePoint-choice-Field/td-p/40865

Thank you !

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Erdem 20 on at

Like (0)

Report
Copy link

Link copied!

Sorry.. It was a boolean... 2 columns had almost the same name with one being a choice and the other being a boolean.

STILL a Problem though: now it's giving following error message:

ExpressionEvaluationFailed. De uitvoering van de sjabloonactie Schakeloptie is mislukt. Het resultaat van de evaluatie van de scope-actie voor de expressie @triggerBody()?['thechoice'] is ongeldig. Dit is van het type Object, maar er wordt een waarde van het type String, Integer verwacht.

It thinks it's an Object instead of a string

Was this reply helpful? Yes No
Verified answer

Erdem 20 on at

Like (1)

Report
Copy link

Link copied!

Okey, I see now that I have to take the VALUE .... so if you have a choice field that is called "MyChoice"... you'll have to fill the Switch option with "MyChoice Value"

Was this reply helpful? Yes No