cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power Participant
Power Participant

Show item if LookUp column contains data

Hi

 

I have a lookup column with multiple values in SharePoint.

In my powerapps gallery i use the following to display it in text on the gallery item

 

Text("My text") & Concat(ThisItem.'LookUpColumn', Value,", ")

Now i only  wish for that to be visible if the column contains any data.

The below works but I'm not sure it is the correct way of doing it.

If(Concat(ThisItem.'LookUpColumn', Value,"") = "", false, true)

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Thank you for answering @BrianS 
I ended up using IsEmpty as it is a table from the LookUp column.

 

If(IsEmpty(ThisItem.'LookUpColumn'.Value), false, true)

View solution in original post

Don't forget the Visible property only needs a Boolean so you can simplify to:

 !IsEmpty(ThisItem.LookupColumn.Value)

the If statement isn't needed - it will just save a little typing and make things easier to read

 

View solution in original post

3 REPLIES 3
Super User
Super User

Thank you for answering @BrianS 
I ended up using IsEmpty as it is a table from the LookUp column.

 

If(IsEmpty(ThisItem.'LookUpColumn'.Value), false, true)

View solution in original post

Don't forget the Visible property only needs a Boolean so you can simplify to:

 !IsEmpty(ThisItem.LookupColumn.Value)

the If statement isn't needed - it will just save a little typing and make things easier to read

 

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (19,084)