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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SharePoint Multiselect...
Power Apps
Answered

SharePoint Multiselect values won't render in Gallery

(0) ShareShare
ReportReport
Posted on by 91

I have an application that "was" working fine.

However, I was asked to change the IT Owner attribute to include a multiple owner names.

In SharePoint I modified that field to a "Checkbox" field. (Thus allowing multiple values.)

MerPetti_1-1662662229643.png

This field renders properly in my Form, however, after my Gallery I get a red underline in the TEXT fx for that field.  

MerPetti_0-1662662098542.png

If I hover over the "Value" it says it's expecting a "Text" value. When I change it to "Text"  it says that is no recognized. 

MerPetti_3-1662662400172.png

 

How can I get this field to render properly in my Gallery?

Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Mer-Petti 

    Text is not a valid column name for a Choice column record.  It will only have a Value column.

    When it tells you it is expecting text, it means that you are not providing a text value to the property.  In this case, ThisItem.'IT Owner'.Value is a table, not text.

     

    To convert the table to text, you can concatenate the values together.

     

    So, changing your formula to the following will show the values in a comma separated text:

    Concat(ThisItem.'IT Owner', Value & ",")

     

     

    I hope this is helpful for you.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard