I am trying to check a SharePoint Yes/No (boolean) field for a true condition. The condition always fails. I have tried to see it it is equal to "Yes", "True" and "1" with no success. Can someone assist with how to use a condition to test a SharePoint Yes/No field?
Not sure how to do it in normal mode, but I succeded when switched to advanced mode.
This is an example of a condition that evaluates two boolean fields from a Sharepoint Item. This condition only succeeds if "Permanent" equals false and "Notify" equals true.
Hope this helps
I am also trying to get the boolean condition check working on Flow. This is my logic as in advance mode where "Submit" is the boolean column name, any idea why it is not working?
Sorry for the distraction, I was trying to point out the quotes. The boolean state shouldn't be compared to the literal 1 character but the numeric. His original post has the 1 character in quotes. So if it has been tried great but I didn't see it in his text.
@efialtespointed out you refer to the item directly where you have:
have you tried
with no second arguement?
@triggerBody()['Submit'] works first time. But when I edit my flow after this, I am not able to save it as the condition fields are empty.
It doesn't look like anyone else is weighing in so.
Sometimes if you force the math true false items will give you what you want.
& that's the last of my bag o tricks.
I just had success using this conditional formula (in advanced mode) to read in a Yes/No boolean checkbox from SharePoint:
Even in Advanced mode the code reverts to testing for a string. This had me confused for a long time until I applied some 'logic' and in a moment of inspiration edited the default syntax.
See the post here
Removing the single quotes from the string 'true' turned it into the boolean true I was after.
@equals(triggerBody()?['value'], 'true') fails
@equals(triggerBody()?['value'], true) works
Hope this helps!
This is an alternative to display a Yes or No based on a Sharepoint boolean value,
or paste in Expression as:
Reminder for me as well for the near future 🙂
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!