Answered

Hide a button if field in collection empty

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I have a collection which will only ever have 1 record in it. I'd like to hide a button if one of fields in the collection is empty

I have tried this :

Visible: 
If(
 IsEmpty(MyCollection.Field1) ||
 IsEmpty(MyCollection.Field2) ||
 IsEmpty(MyCollection.Field3) ||
 IsEmpty(MyCollection.Field4) ||
 IsEmpty(MyCollection.Field5) ||
 IsEmpty(MyCollection.Field6),
 false,
 true
)

and this

Visible: 
If(
 IsEmpty(MyCollection.Field1) &&
 IsEmpty(MyCollection.Field2) &&
 IsEmpty(MyCollection.Field3) &&
 IsEmpty(MyCollection.Field4) &&
 IsEmpty(MyCollection.Field5) &&
 IsEmpty(MyCollection.Field6),
 false,
 true
)

but button still invisible even if all those fields have data in them. Have also tried IsBlank instead of IsEmpty

Any ideas?

TIA

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vffdd ,

The below should do the trick:

Not( IsBlank(MyCollection.Field1) || IsBlank(MyCollection.Field2) || IsBlank(MyCollection.Field3) || IsBlank(MyCollection.Field4) || IsBlank(MyCollection.Field5) || IsBlank(MyCollection.Field6) )
Verified answer

Forbs 35 on at

Like
a
(2)

Report
Copy link

Link copied!
As you only ever have one item in your collection you may want to use the 'First' function to access it. Then use a similar function as in your first image but you need to be using IsBlank(). I think a function like this may work:

Visible: If( IsBlank(First(MyCollection).Field1) || IsBlank(First(MyCollection).Field2) || IsBlank(First(MyCollection).Field3) || IsBlank(First(MyCollection).Field4) || IsBlank(First(MyCollection).Field5) || IsBlank(First(MyCollection).Field6), false, true )
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

thanks @Forbs that worked perfectly