Announcements
Hi,
I try to filter a gallery on a multivalued column.
I have filled a collection of filters and i'm looking for the right syntax to filter records for which one of the values selected (a table) in a column match a record in my collection of expected values.
Can anybody help me ?
Thank you.
Laurent.
Hi @Laurent_Revel,
Do you want to filter gallery based on multi select values?
Could you please tell me:
1). how you define the values selected (a table) in a column, using a Combo box to select items?
2). what is your data source?
Generally, if you have a Combo Box to select multi items, you could filter the gallery as below
Filter(DataSource,ColumnName.Value in ComboBox.SelectedItem.Value)
>>I try to filter a gallery on a multivalued column.
My 2 cents: I would advise refactoring to avoid use of Multivalued columns. Multivalued columns are 'not a thing' in good data modelling (they do not conform to first normal form) and while they are a quick fix to avoid having to create additional child tables (a properly normalised data model) they frequently cause problems later in development as you are finding 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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 411 Super User 2026 Season 2
Mohsin Ali 338
WarrenBelz 256 Most Valuable Professional
