Answered

IF Yes/No conditions

(0) Share

Report

Posted on by Torque

I've been unsuccessfully trying to figure out the syntax for an IF condition based on the value of a Yes/No feild. I cant figure it out how to adapt the examples I see online to what I am working on, I am hoping someone might be able to explain how Yes/No conditions work?

The current example I'm working on:

Table name: CreditLimitChanges

Columns:

'AccountName' -Text column

'Done' -Yes/No column

Gallery: ListGallery

I have created a label, and I want the fill of the label to be Red if Done = No, and White if Done = Yes

I can get it to work with the text column. E.g. this does work:

If(LookUp(CreditLimitChanges, AccountName= ListGallery.Selected.AccountName, AccountName) = "Pfeffer LLC", Red, White)

But I can't figure out how to do this with the yes/no column. The help text says value types being compared are not the same but I don't understand what it needs E.g.:

If(LookUp(CreditLimitChanges, AccountName= ListGallery.Selected.AccountName, Done) = true, Red, White)

I would appreciate any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
HI @Torque ,

Your example actually only needs

If( ListGallery.Selected.AccountName = "Pfeffer LLC", Red, White )

and assuming the Done field is somewhere in the Gallery content

If( ListGallery.Selected.Done, White, Red )

or the reverse with the same result

If( !ListGallery.Selected.Done, Red, White )

Boolean (Yes/No) fields just need to be referred to as per this blog of mine. ! simply means Not()

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Torque 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you!

Edit: @WarrenBelz your blog post clarified many aspects of using boolean values that were tripping me up, thank you, I really appreciate it.

Was this reply helpful? Yes No