# How do you get a multi select to filter a table when the underlying data isn't an array?

**URL:** <https://community.weweb.io/t/how-do-you-get-a-multi-select-to-filter-a-table-when-the-underlying-data-isnt-an-array/4543>\
**Category:** How do I?\
**Tags:** formulas, filter\
**Created:** [September 23, 2023, 12:23am UTC](https://community.weweb.io/t/how-do-you-get-a-multi-select-to-filter-a-table-when-the-underlying-data-isnt-an-array/4543 "2023-09-23T00:23:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KnightVisionCreative](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/knightvisioncreative/32/5075_2.png) [@KnightVisionCreative](https://community.weweb.io/u/KnightVisionCreative)\
**Post date:** [September 23, 2023, 12:23am UTC](https://community.weweb.io/t/how-do-you-get-a-multi-select-to-filter-a-table-when-the-underlying-data-isnt-an-array/4543/1 "2023-09-23T00:23:12Z")

</div>

Hi!

I’m trying to add an additional filter to my datagrid where it will filter the options based on one or more levels selected. I’ve tried a variety of different options, but am unable to get any of them to work. As soon as I make a selection it fails. I was thinking I need to do has any of, but am assuming that’s only available for an array. I tried is and contains without luck.

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/e/e82f96a4358cd32f81219066bea5fae864be44e0.png)

I followed this documentation and was able to populate the dropdown, but couldn’t get the dropdown to work for the table. [Select & Multi-select | WeWeb documentation](https://docs.weweb.io/add-elements/elements/select.html)

Thanks a bunch!

-Brendan

---

<div class="post-metadata">

**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\
**Post date:** [September 23, 2023, 7:35pm UTC](https://community.weweb.io/t/how-do-you-get-a-multi-select-to-filter-a-table-when-the-underlying-data-isnt-an-array/4543/2 "2023-09-23T19:35:14Z")

</div>

![Screenshot 2023-09-23 at 21.34.27](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/a/a52eb80f93d9974758c25bc8b8d438e23ddcb546.png)

Seems to work for me like this. Or am I misunderstanding your question? Maybe you’re filtering it so much, that there are no options matching your filters. That might be why you’re not getting any results.

---

<div class="post-metadata">

**Author:** ![KnightVisionCreative](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/knightvisioncreative/32/5075_2.png) [@KnightVisionCreative](https://community.weweb.io/u/KnightVisionCreative)\
**Post date:** [September 23, 2023, 9:27pm UTC](https://community.weweb.io/t/how-do-you-get-a-multi-select-to-filter-a-table-when-the-underlying-data-isnt-an-array/4543/3 "2023-09-23T21:27:59Z")

</div>

“Is in” worked! Thanks for the suggestion. I’m not sure if I missed that one the first time around or just butchered it in the formula.

Thanks again!