Displaying data from a column with support for multiple values
I've been struggling with a specific task in a few different areas.
I have a column in my Sharepoint list which is populated from a combo box in the sharepoint list form. This column can have multiple values selected in an entry.
We are taking this list and using it as a data source in Powerapps. I am trying to do multiple things with this data and am struggling.
The problems:
- I cannot figure out how to take the distinct values and show them in a combo box for filtering.
- How do I iteratively display this column in my gallery? (Since there are multiple, it is showing up as a table type).
Sample Data:
What the data looks like (this isn't the data I'm using, but it's easier to describe this way)
| Title | Description | Genre |
| Life is a Highway | By Rascal Flatts | "Pop", "Rock" |
| Through the Wire | By Kanye West | "Rap" |
In this case, I'd want my combo box to display uniquely "Pop", "Rock" and "Rap", and for each item in my gallery to display their respective genres.

Report
All responses (
Answers (