Solution: Using a Yes/No checkbox in a Microsoft Flow condition statement

2017-09-17_13-59-37

It’s not uncommon to want to use yes/no checkboxes when building Microsoft Flow conditions. [Field] is equal to “Yes” or [Field] is equal to true won’t work because it reads the Yes or true as a string rather than a value. So when the flow runs, even if the checkbox is checked (true), the run history says the expression result was false.

Fortunately it’s a simple two-step fix. Follow these steps to be able to use yes/no checkboxes as conditions in your flows:

  1. Type a lowercase “true” or “false” in the last field of the condition statement and click “Edit in advanced mode
    yesno2.PNG
  2. Remove the single quotation marks (‘) around the word true or false. You can click edit in basic mode again to see the difference if you wish.
    yesno3.PNG

That’s it! Your flow should now run properly when the box is checked or unchecked based on your condition.
yesno1

 

Advertisements