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?
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!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!