web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like (0)

Report
Copy link

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

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

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your contribution, but this is not working either.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report
Copy link

Link copied!
Alternatively, you can try:
!IsBlank( Lookup(IncidentFactors, "Faulty equipment" in Value) )

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (3)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (1)

Report
Copy link

Link copied!

Thanks Randy

Was this reply helpful? Yes No
peter_not 50 on at

Like (0)

Report
Copy link

Link copied!

Brilliant!

Was this reply helpful? Yes No

Join the conversation