web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Can't filter by a Yes/...
Power Apps
Answered

Can't filter by a Yes/No Column for LookUp query

(0) ShareShare
ReportReport
Posted on by 2

Critical_0-1700199876214.png

This code is for a text box and is meant to filter the displayed text based on if requirement check is set to yes. The data type for Requirement Check is yes/no. It currently gives me the following errors:

Critical_1-1700200265029.png

If I remove the if-lookup function for requirement check it works as intended minus filtering out unrequired info. Is there a way to filter the text based on the Requirement Check value?

Categories:
I have the same question (0)
  • Verified answer
    VasileR Profile Picture
    298 Super User 2024 Season 1 on at

    Hei @Critical ,

     

    The problem is with first LookUp, which returns an entire record (an entire line from the table if you want). I assume that if you find a record with the check set, you want to perform the 2nd lookUp.

    You have the following option:

     

    If( 
     !IsBlank( LookUp('2016 News', 'Requirements Check' = true),
     LookUp('2016 News', ID=Counter).'Source Text'
    )

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard