Forum Discussion
Using the combobox to search for multiple terms from a lookUp-column in a SharePoint list.
Collab-Constructor_93 your example doesn't make sense to me:
- If "Beta" is selected in the combo box, ListItems 2 and ListItem3 appear
- If "Beta" and "Gamma" are selected in the combo box, only ListItem 2 appears
Because if Beta is selected then ListItems 2 and 3 should appear and also whatever Gamma is supposed to display as you are wanting it like an AND search. Your logic doesn't seem quite right.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Hi Rob Elliott
and thanks for your reply!
Basically i want it to work like this way:
Show me all records from the List to be filtered, which contain at minimum the selected items from the combobox.
So if I only select „Beta“ Show me all records, which contain „Beta“ in the corresponding column.
If I select Beta And Gamma show me only records, which contain both entries in the corresponding column.
Sorry if my example didn‘t reflect this idea. Whirh And search i tried to refer to the case, when I set multiple Filters in an Excel Sheet.
