# List disappeared from screen now the filter does not work

**URL:** <https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273>\
**Category:** Database\
**Created:** [September 14, 2021, 10:01am UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273 "2021-09-14T10:01:24Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![adominicci](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adominicci/32/11384_2.png) [@adominicci](https://forum.adalo.com/u/adominicci)\
**Post date:** [September 14, 2021, 10:01am UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/1 "2021-09-14T10:01:24Z")

</div>

Hi.

I have a relationship of user/cities and is many-to-many. I had a list that users can toggle their favorite cities. That works. I have a button that goes to another screen (the one that the list disappear). In this list I had the reversed information a list of cities that the user had not favorite.

Now no matter what I do I can not recreate this list. I’ve spent countless hours and nothing. I’m asking for help because I don’t know if I’m stupid or this is another bug that just appeared in Adalo because of the missing list like the drop down select issue that was working and does not work anymore.

---

<div class="post-metadata">

**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:** [September 14, 2021, 10:10am UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/2 "2021-09-14T10:10:22Z")

</div>

Hi @adominicci !! 👋 👋  
Can you explain a bit more? 😊

---

<div class="post-metadata">

**Author:** ![adominicci](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adominicci/32/11384_2.png) [@adominicci](https://forum.adalo.com/u/adominicci)\
**Post date:** [September 14, 2021, 12:20pm UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/3 "2021-09-14T12:20:19Z")

</div>

Thanks @Dilon. Here are in 4 screenshots. The funny thing was that I made it worked before like I mentioned in my original post. I created a brand new app with only those two entities, just to make sure that’s not my relationships in my original app.

Here are my database collections:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/2d802fc179a5e6fa9c0506dd124d1c97d9250dbe.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f692e2f84128730be5ba426fef3ca6c40f00f69d.png)

And below what I want.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/225683a1b0b2c99fb5441e6f6c5d31b078d00000.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/030d5d654d4c3a47a20734e7d1cd1e4d2c14d56c.png)

---

<div class="post-metadata">

**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:** [September 14, 2021, 12:27pm UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/4 "2021-09-14T12:27:28Z")

</div>

So you want to display favorite cities in the home screen and when the button click other cities should display and favorite cities should not display.

Am I right @adominicci ?

---

<div class="post-metadata">

**Author:** ![adominicci](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adominicci/32/11384_2.png) [@adominicci](https://forum.adalo.com/u/adominicci)\
**Post date:** [September 14, 2021, 12:41pm UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/5 "2021-09-14T12:41:13Z")

</div>

Exactly, that’s what I want. Like I mentioned I had it all setup and working and all of the sudden my list disappeared from the screen and this is where I’m at now. Bummer!

---

<div class="post-metadata">

**Author:** ![adominicci](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adominicci/32/11384_2.png) [@adominicci](https://forum.adalo.com/u/adominicci)\
**Post date:** [September 14, 2021, 1:21pm UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/7 "2021-09-14T13:21:05Z")

</div>

Great! Thank you for your help. Funny thing I’m a SQL developer in my regular job and I can easily do this with outer joins and searching for a null value.

But after 25 years coding I’m really happy with no-code for my side gigs.

---

<div class="post-metadata">

**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:** [September 14, 2021, 2:53pm UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/8 "2021-09-14T14:53:36Z")

</div>

Hi @adominicci,

List for the “Favourite” cities:

 ![Screenshot 2021-09-14 at 17.49.32](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/d354af9900b1b3b6bc268d7465c634c07c8867a4.png)

List for “Non-favourite” cities:  
(Filter is Current City → Users → All)

 ![Screenshot 2021-09-14 at 17.50.54](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/3ee139f558e62914997f77cc97b3f864e29a1541.png)

Users and Cities have many-to-many relationship.

There is another option to do this via Junction/Associative table, though it is a bit more complex. In Adalo many-to-many relationships are not very fast (being an SQL developer you probably know why 🙂 ), but now they work much better than before.

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![adominicci](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/adominicci/32/11384_2.png) [@adominicci](https://forum.adalo.com/u/adominicci)\
**Post date:** [September 14, 2021, 3:22pm UTC](https://forum.adalo.com/t/list-disappeared-from-screen-now-the-filter-does-not-work/17273/11 "2021-09-14T15:22:18Z")

</div>

It worked!!! Thank so much @Victor for the solution and @Dilon for caring about helping.
