News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps See if a value exists ...

Power Apps - Building Power Apps

Answered

See if a value exists in single column collection

(0) Share

Report

Report

Posted on by R Bakker

725

Hi everyone

So I want a field to be visible if "Faulty equipment" is in the collection, and I have tried this and many other things but no luck.

!isBlank(Lookup(IncidentFactors.Value="Faulty equipment"))

I feel I am over thinking this and it must be super simple.

Categories:

General Questions

All responses Img

All responses (6)

Answers Img

Answers (1)

peter_not 50 on at

Like (0)

Report

Re: See if a value exists in single column collection

Brilliant!
R Bakker 725 on at

Like (1)

Report

Re: See if a value exists in single column collection

Thanks Randy
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (3)

Report

Re: See if a value exists in single column collection

@Corissandageri

You can use the following formula:

LookUp(IncidentFactors, Value="Faulty Equipment", true)

This will return true if the value exists in the source.

You can also use the following formula:

"Faulty Equipment" in IncidentFactors.Value

This also will return true if the value exists.

I hope this is helpful for you.
BCLS776 8,988 Super User 2025 Season 1 on at

Like (0)

Report
Re: See if a value exists in single column collection

Alternatively, you can try:
!IsBlank( Lookup(IncidentFactors, "Faulty equipment" in Value) )
R Bakker 725 on at

Like (0)

Report

Re: See if a value exists in single column collection

Thank you for your contribution, but this is not working either.
BCLS776 8,988 Super User 2025 Season 1 on at

Like (0)

Report
Re: See if a value exists in single column collection

Assuming IncidentFactors is your collection and Value is the name of the single column within it, try:

!IsBlank( Lookup(IncidentFactors, Value="Faulty equipment") )