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

(0) Share

Report

Posted on by Critical

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:

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:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

VasileR 298 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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' )

Was this reply helpful? Yes No