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 / Populating Data Table ...
Power Apps
Unanswered

Populating Data Table Column where data source is a Collection and desired column in collection table is Complex/MultiSelect.

(0) ShareShare
ReportReport
Posted on by

I am learning power apps on my own and haven't had training, so pardon me if I don't sound like I know what I'm asking.  However, I have an app where I have collected selected gallery records/items (not sure what to call them) and I am using the items in the collection to populate a data table.  I have been able to create the table as I desire except for populating one column which continually throws errors where some variation of the formula "ThisItem['Sidebar/Links'].value" or "ThisItem.'Sidebar/Links'.Value" is used.  The version w/ ['Sidebar/Links'] sees that syntax as a record, but says I'm using unexpected characters.  The version w/ 'Sidebar/Links' sees that syntax as a Table and says its expecting a Text value.  I have used chatgpt and tried numerous variations using Concatenate, Lookup, ForAll, etc.. but I always get an error expecting a Text value.  The column giving me problems is a Choice column that allows multiple selections.  What other information can I provide to get help with this?

Categories:
I have the same question (0)
  • Ami K Profile Picture
    15,689 Super User 2024 Season 1 on at

    @Gabe_L - as I understand it, you have a Gallery connected to a data source (let's assume SharePoint).

    You have created a Collection from this Gallery.

    You have a Data Table control. The Items property for this control is your Collection.

    One of the columns in your Data Table is a SharePoint Multi-Choice field.

    Try selecting the Text property of that column in your Data Table, and enter:

     

    Concat(ThisItem.'Your Multi Choice Field', Value & ",")

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard