Hello everyone,
i have search and filter function using combobox , but when i try to select more than one , the gallery will only show 1 list(it will override the exisiting list). how to ensure that the gallery will display all value that i searched. below is the interface.
it is shown at the combobox that there are 2 items being chosen but in the gallery, there's only one value being displayed.
this is the code that i used in gallery item data field
SortByColumns(
Filter(
[@'HEO Lesson Learn'],
IsBlank(ComboBox.Selected.'What happened') || ComboBox.Selected.'What happened' ='What happened'
),
"Title",
If(
SortDescending1,
SortOrder.Descending,
SortOrder.Ascending
)
)
Thank you in advance for your assistance
