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
Responsive Resident
Responsive Resident

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

Responsive Resident
Responsive Resident

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
Responsive Resident
Responsive Resident

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

Responsive Resident
Responsive Resident

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
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,151)