I am creating a relatively straight forward app using a Sharepoint List. On this app is a gallery that I need to be able to filter off several columns in sharepoint. I have figured out how to filter using several drop downs. The problem I am running into is one of the columns in the sharepoint list is a text field but could have multiple results seperated by a comma. for Example:
Number | Color |
1 | Red |
2 | Blue |
3 | Green |
4 | Yellow |
5 | Red, yellow |
6 | Red, Blue |
7 | White |
I need to have a drop down that will allow me to filter any row that contains the color selected in the drop down. For example if i select Red on my drop down i want rows 1,5,and 7 to return.
I tried Filter(SharepointList,Color in dropdownColor.Selected.Value) and that gets me all the rows that has that color but the rows that contains more than one color does not display. What am i missing??
Or better yet could I have a combo box where I could select the colors I was interested in
