web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery from Sharepoin...
Power Apps
Unanswered

Gallery from Sharepoint list with mulit-select lookup column

(0) ShareShare
ReportReport
Posted on by 14

I have created a pretty basic power app to display a gallery from Sharepoint LIST1. The gallery should display first name, last name, cell phone, and Specialty. First name, last name, and cell phone display properly, but Specialty will not. In LIST1, the Specialty column is a multi-select look up column pulling specialty names from LIST2. This works properly in Sharepoint, but when I create the gallery, I cannot display text from the Specialty column in the gallery.

 

I have read many threads and tried many formulas. I believe the formula for "subtitle2" (where the data from LIST1 Specialty column should display) should be something like this: Concat(ThisItem.Specialty.Value, Value & “, “), but I cannot make it work. Any insight would be appreciated.

Categories:
I have the same question (0)
  • turnerj3 Profile Picture
    2,039 on at

    Try using a comma instead of the &

  • DeaMaree Profile Picture
    14 on at

    Nope. Nothing changed.

  • HectorOlivos Profile Picture
    411 on at

    can you try with this: 

     

    Text = Concat(LookUp(LIST2, ID in ThisItem.Specialty), Value & ", ")

  • DeaMaree Profile Picture
    14 on at

    This made the error go away - replaced it with a delegation warning. But, the subtitle2 box still does not display any values at all. The formula hover box also says "Invalid argument type. The function 'Concat' has some invalid arguments."

  • HectorOlivos Profile Picture
    411 on at

    Concat(Lookup(LIST2, ID in ThisItem.Specialty.Value).Specialty, Value & ", ")

  • DeaMaree Profile Picture
    14 on at

    Subtitle2 still empty

  • DeaMaree Profile Picture
    14 on at

    ThisItem.Specialty = This formula uses scope, which is not presently supported for evaluation. Data type: Table

  • HectorOlivos Profile Picture
    411 on at

     Concat(ThisItem.Specialty, Value & ", ").Result

  • DeaMaree Profile Picture
    14 on at

    Just FYI.... this is what works Concat(Filter(colSpec, Value in ThisItem.Specialty.Value), Value & ", ")
    I had to pass it through a collection, but it works now.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard