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)
Solved! Go to Solution.
The IsBlank function or Coalesce may be better - check the documentation here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty
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)
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
The IsBlank function or Coalesce may be better - check the documentation here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty
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)
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
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
197 | |
174 | |
62 | |
33 | |
32 |
User | Count |
---|---|
340 | |
270 | |
109 | |
72 | |
58 |