# Use magic text with many-to-many relationship

**URL:** https://forum.adalo.com/t/use-magic-text-with-many-to-many-relationship/19986
**Category:** Get Help
**Created:** [November 23, 2021, 7:02am UTC](https://forum.adalo.com/t/use-magic-text-with-many-to-many-relationship/19986 "2021-11-23T07:02:18Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![charleshope](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/charleshope/32/25088_2.png) [@charleshope](https://forum.adalo.com/u/charleshope)
#### Post date: [November 23, 2021, 7:02am UTC](https://forum.adalo.com/t/use-magic-text-with-many-to-many-relationship/19986/1 "2021-11-23T07:02:18Z")

</div>

Hi everyone,

I would much appreciate your help here.

I have two collections, related many-to-many. For example, users and favourite desserts. A user can have many favourite deserts, and a dessert can be related to many users.

I can’t figure out how to use magic text to show the favourite desserts of a user. It only gives me the option to show the count of them, but not the actual desserts.

Does anyone know of a solution or workaround to this?

Thank you.

---

<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: [November 23, 2021, 7:29am UTC](https://forum.adalo.com/t/use-magic-text-with-many-to-many-relationship/19986/2 "2021-11-23T07:29:40Z")

</div>

Hi @charleshope 👋

Add a list and set the collection to the Desserts collection and set the filter to Logged in user \> Desserts. Then rename the Title as Current Dessert \> Name

Here’s a quick app I created.

> **[Deserts](https://previewer.adalo.com/967786a1-bca5-4c08-a4d1-8b8f2dcb8570)**
>
> Built with Adalo

Hope it helps!

Thank you

---

<div class="post-metadata">

### Author: ![charleshope](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/charleshope/32/25088_2.png) [@charleshope](https://forum.adalo.com/u/charleshope)
#### Post date: [November 23, 2021, 11:19am UTC](https://forum.adalo.com/t/use-magic-text-with-many-to-many-relationship/19986/3 "2021-11-23T11:19:57Z")

</div>

@Dilon

Yeap, that did the trick. Although I wished magic text had that capability of presenting the data instead of just the count.

Thank you very much! 🙏

---

<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: [November 23, 2021, 11:24am UTC](https://forum.adalo.com/t/use-magic-text-with-many-to-many-relationship/19986/4 "2021-11-23T11:24:08Z")

</div>

Your welcome 👍

---

<div class="post-metadata">

### 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 3, 2021, 11:24am UTC](https://forum.adalo.com/t/use-magic-text-with-many-to-many-relationship/19986/5 "2021-12-03T11:24:52Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.