Having problem with IF statement on true/false

(0) Share

Report

Posted on by sienna28

514

I did a GetItems to pull in values from my SharePoint list.

One of the values has true/false.

I want to say if it is true then display Pass otherwise display Fail.

Please advise

Thank you

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (2)

ccc333ab 1,144 on at

Like (0)

Report

Going to guess you need to use an expression for true/false (i.e., don't just type in true/false into the condition box, use expression)...see below.
IF this isn't the issue, can you paste in a screenshot of what you are trying to do, and indicate what is the data type on your SharePoint list for this true/false column.

Was this reply helpful? Yes No
powercorner 477 on at

Like (0)

Report

Hello @sienna28 ,

one little advice, when you want to get helped quickly here in the board.
Please screenshot your problems so it is much easier for us to understand what you people out there trying to accomplish.

I totally agree with @ccc333ab . This is the way it should be done.

With regards
Kevin

Was this reply helpful? Yes No
sienna28 514 on at

Like (0)

Report

Thank you for replying.
I have attached a screenshot to explain a little more.
Thanks

Was this reply helpful? Yes No
Verified answer

ccc333ab 1,144 on at

Like (1)

Report

Can you also show a screenshot of your condition action that shows where you are comparing.

As an alternative solution to even using a condition, you can create an expression instead at the time of inserting the SteeringWheel column into your template. What you can do is create an expression with something like:
if(equals([SteeringWheel], true), 'Pass', 'Fail')

Was this reply helpful? Yes No
sienna28 514 on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

powercorner 477 on at

Like (1)

Report

hey @sienna28 ,

I think @ccc333ab would appreciate a "Solution" and a "Kudoe/Thumbs Up" 🙂

With regards
Kevin

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution”. This will help the whole community. If I could help you out please give my post a Thumbs Up. 🙂

Was this reply helpful? Yes No
sienna28 514 on at

Like (0)

Report

Done - many thanks

Was this reply helpful? Yes No
sienna28 514 on at

Like (0)

Report

Hi

Just tested this a bit more and I am finding my records are all coming out as showing Fail.
The statement used in the expression is:
if(equals(outputs('Get_item')?['body/WipersWashers'], 1), 'Pass', 'Fail')

I also tried with
if(equals(outputs('Get_item')?['body/WipersWashers'], 'Yes'), 'Pass', 'Fail')
if(equals(outputs('Get_item')?['body/WipersWashers'], true), 'Pass', 'Fail')

Please advise

Thank you

Was this reply helpful? Yes No
sienna28 514 on at

Like (0)

Report

Tried the solution above and seems to work now so can close this thread again.

Was this reply helpful? Yes No