# MultiSelect Dropdown filtering **URL:** \ **Category:** Get Help\ **Created:** [November 24, 2021, 2:03pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049 "2021-11-24T14:03:43Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 2:03pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/1 "2021-11-24T14:03:43Z")
Hello there, I’m having an issue with **filtering a list of products based on multiple criteria with multiselect dropdown** and especially on brand, color, material selection . 😐 For example with the brands : - A collection of “Brands” with a relationship with products on many to one. - A second collection called “Selected brands” related in many to many to users. When filtering, I update the “Selected brands” of logged in user with : - add a selected brand “Every time any item is selected” and - remove it “Every time any item is deselected” Then the click on the button at the bottom of filter page leads to an other page with filtered results. When I want to filter results I tried to set : Products \> Brand \> Name “contains” Logged in user\> Selected Brands\>Name except the magic text selection doesn’t let me to choose Selected Brands \> Name but gets only to Selected Brands\>Brands ou Selected Brands \> User etc… In other components, there is neither Multiselectropdown as an option. This way, I can’t filter the results list… I’m kind of worried because user on the app should manage to select multiple brands to find products he’s been looking for. Has anyone managed to filter a list of products with multiselect dropdown ? Thanks a lot for your help ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [November 24, 2021, 2:09pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/2 "2021-11-24T14:09:26Z")
Hi @chrl 👋 Like how you want to filter the dropdown? And I think you don’t need a collection for the Selected brands. You can create a relationship property between Users collection Many to Many and Update that property ( Item selected Update logged in user \> Brands add current brand and Oposite one for the remove one ) and filter the list as Logged in user\> Brands Thank you ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 2:26pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/3 "2021-11-24T14:26:29Z")
I’ve just tried but it seems it doesn’t work either (Brand collection is called Marque collection in the app) Any idea ? Thanks again ![Capture d’écran (2)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/b/bab38b9b6298a78e115bc6ba927bf68754214ab0.png) ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [November 24, 2021, 2:28pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/4 "2021-11-24T14:28:35Z")
No need to add Custom filters. Set the collection to the brands collection and set the filter from All brands to Logged in user \> Brands ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 2:58pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/5 "2021-11-24T14:58:12Z")
Thanks, it works great but I when I want to add a filter the same way such as “color” in MultiSelect Dropdown, there is still the problem to filter results. Here is the screenshot. Thanks ![Capture d’écran (3)](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/6/638b6f5bd29d0fa203cfb889b22016d77b8c7d79.png) ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [November 24, 2021, 3:00pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/6 "2021-11-24T15:00:08Z")
Is there a collection for colours as Brands? ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 3:03pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/7 "2021-11-24T15:03:16Z")
Yes and more such as Product condition, Materials and Style. I would like to be able to filter with brands, colors, condition, materials and style in the same list ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [November 24, 2021, 3:10pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/8 "2021-11-24T15:10:08Z")
Ok so you are trying to filter the product list from User’s selection? ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 3:10pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/9 "2021-11-24T15:10:58Z")
Yes, indeed ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [November 24, 2021, 3:13pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/10 "2021-11-24T15:13:05Z")
So you have added a multi select drop-down to select the brand? ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 3:15pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/11 "2021-11-24T15:15:06Z")
Yes and some more to choose color, condition, material and style. For instance, it’s working with brands but other filters related to Multiselect Dropdown don’t. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [November 24, 2021, 5:10pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/13 "2021-11-24T17:10:29Z")
Hi @chrl, I assume that you have a many-to-many relationship between Brands \<-\> Users, Colors \<-\> Users to store the “selected options”? In this case, here is the way you can make your list filtering work: ![Screenshot 2021-11-24 at 19.09.05](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/8/8064471fb9d3d9fb30014b43f7979a024ffa1bab.jpeg) ![Screenshot 2021-11-24 at 19.08.53](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/b/bb19e906c4117cedb34c4ad68c79035b8a694a2c.png) Basically, from a product you have a relationship to Color and Brand and etc. The collection records in Color (for example) will have a relationship to Users collection; if user selects a color, you create a “link” in Multiselect dropdown between User and Color. So you can then use this relationship to select "All’ users (see screenshot) and filter them out by Logged-in User. However, there are two huge drawbacks to such approach in general: - multiselect dropdown can’t “prepopulate” the selections. So when your user will open the filter for the 2nd time, the dropdown selections will be empty, however, the relationships will be there. So you need to invent how to clear them. - many-to-many relationships are not very fast in Adalo. They could be used in some cases, but in this scenario with the user base growth the speed will decrease. I’d advise to think about some alternative way of filtering. Best regards, Victor. ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 6:13pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/14 "2021-11-24T18:13:43Z")
Thanks a lot for your reply, unfortunately as soon as I set a second filter, I get no results. So I don’t know how to proceed to get this multi factor filter and it’s really annoying. The way to clear that choice up is a real problem indeed. Haven’t found a way to do it yet. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [November 24, 2021, 6:42pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/15 "2021-11-24T18:42:14Z")
Hi @chrl, Then most probably it is either something wrong with the relationships or in the dropdown actions. I’ve made screenshots from the sample I’ve created - both filter work. Though I really don’t like multiselect dropdown in this case - I don’t think it will work properly in real app. It might be a good idea to think how to create a filter for multiple properties in the most efficient way 🤔 Best regards, Victor. ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 6:49pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/16 "2021-11-24T18:49:26Z")
I’ve encountered today some troubles with the lists. It seems to work again, hope it will go on… You mean a select menu ? It would at least enables to clear the selection but the app has to let user select different brands, colors… Would you have any idea of the way to clear the selection ? As the MultiSelected Dropdown is not recognized as a component, I didn’t manage to clear user choices. Thanks again ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [November 24, 2021, 6:54pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/17 "2021-11-24T18:54:59Z")
Ok, how many brands, colors, product condition, material and styles are we talking about? Just an evaluation - because some solution will work for 2…5 selections, others for 5…10, etc. Clearing the selection is possible either via countdown timer or an external script. With a countdown, you will need to have a screen where you have lists of Brands, Colors, Materials, etc., filtered by Selectedby contains Logged-in User. And then you put countdown into the list, to remove this relationship. See the video with the same principle here. [Adalo experiments: mass update via integromat photos and categories - YouTube](https://youtu.be/NRxRsgnwS0U) Cordialement, Victor. ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 24, 2021, 7:33pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/18 "2021-11-24T19:33:47Z")
I would say 2-5 selections for each item (Brands, Colors, Materials…). So you need to create another collected of items selected filtered by Selected by contains Logged in user ? How do you remove the relationship with the timer ? I’d rather like not to go through external script ---
**Author:** ![chrl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/chrl/32/12128_2.png) [@chrl](https://forum.adalo.com/u/chrl)\ **Post date:** [November 25, 2021, 12:08pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/20 "2021-11-25T12:08:18Z")
I’ve already checked this solution, it’s really interesting but not useful when you want an user selecting several colors or conditions at a time… ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [December 12, 2021, 11:00pm UTC](https://forum.adalo.com/t/multiselect-dropdown-filtering/20049/22 "2021-12-12T23:00:42Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.