Unanswered

How to test SharePoint Yes/No (boolean) field in condition

(3) Share

Report

Posted on by EdBenton

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?

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (0)

efialtes 350 on at

Like (0)

Report
Copy link

Link copied!

@EdBenton
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.

@and(not(triggerBody()['Permanent']), triggerBody()['Notify'])

Hope this helps

Was this reply helpful? Yes No
arbangara99 32 on at

Like (0)

Report
Copy link

Link copied!

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?

@equals(triggerBody()?['Submit'], 'True')

Was this reply helpful? Yes No
I_like_PI 39 on at

Like (0)

Report
Copy link

Link copied!

I'm a newb so my apologies, but just to confirm, did you try =1 or ="1"

Was this reply helpful? Yes No
arbangara99 32 on at

Like (0)

Report
Copy link

Link copied!

I didn't. However as stated in the first post ont his thread, EdBenton has tried that already it seems.

Was this reply helpful? Yes No
I_like_PI 39 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
arbangara99 32 on at

Like (0)

Report
Copy link

Link copied!

that didnt work either!

Was this reply helpful? Yes No
I_like_PI 39 on at

Like (0)

Report
Copy link

Link copied!

@efialtespointed out you refer to the item directly where you have:
     @equals(triggerBody()?['Submit'], 'True')
have you tried
    @triggerBody()['Submit']
or
  @and(triggerBody()['Submit'])
with no second arguement?

Good luck

Was this reply helpful? Yes No
arbangara99 32 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
I_like_PI 39 on at

Like (0)

Report
Copy link

Link copied!

It doesn't look like anyone else is weighing in so.
@equals(triggerBody()?['Submit']*1, 1)

Sometimes if you force the math true false items will give you what you want.
& that's the last of my bag o tricks.

Was this reply helpful? Yes No
arbangara99 32 on at

Like (0)

Report
Copy link

Link copied!

Flow doesnt accept this as a vlid syntax. '*' is not expected they say..

Was this reply helpful? Yes No