# Fetch 2 different tables into one "menu selection"

**URL:** <https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779>\
**Category:** Flow Classic\
**Created:** [October 3, 2024, 7:54pm UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779 "2024-10-03T19:54:48Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikolo01](https://avatars.discourse-cdn.com/v4/letter/v/7C9FD7/32.png) [@vikolo01](https://forum.novacura.com/u/vikolo01)\
**Post date:** [October 3, 2024, 7:54pm UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/1 "2024-10-03T19:54:48Z")

</div>

Hi,

I am wondering how two different tables with different menu options can be combined and used in a “Menu selection” menu. The desired outcome is that if a specific condition is met, the options from one table should be displayed, and if another condition applies, the options from the other table should be shown.

I would be grateful for any help I can get.

Best regards,

Viktor

Example.  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/dc69ac3e506ba01a0fcafb6b8a448a97e9855aab.png)

---

<div class="post-metadata">

**Author:** ![Alluse](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/alluse/32/1013_2.png) [@Alluse](https://forum.novacura.com/u/Alluse)\
**Post date:** [October 4, 2024, 6:17am UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/2 "2024-10-04T06:17:07Z")

</div>

Hi,

You could just have one table and then add a column to it, let’s call it “Type” or something. Then based on previous conditions you can then filter the table (in assignment/script step) before using it in the User Step . Like this:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/e628d147eea2c2aca697935862dab172573b96b3.png)

---

<div class="post-metadata">

**Author:** ![vikolo01](https://avatars.discourse-cdn.com/v4/letter/v/7C9FD7/32.png) [@vikolo01](https://forum.novacura.com/u/vikolo01)\
**Post date:** [October 4, 2024, 12:46pm UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/3 "2024-10-04T12:46:20Z")

</div>

Thank you, that helped a lot.

BR, Viktor

---

<div class="post-metadata">

**Author:** ![Alluse](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/alluse/32/1013_2.png) [@Alluse](https://forum.novacura.com/u/Alluse)\
**Post date:** [October 4, 2024, 1:00pm UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/4 "2024-10-04T13:00:18Z")

</div>

Great! Let us know if you have any other questions. Happy Flowing! 🙂

---

<div class="post-metadata">

**Author:** ![vikolo01](https://avatars.discourse-cdn.com/v4/letter/v/7C9FD7/32.png) [@vikolo01](https://forum.novacura.com/u/vikolo01)\
**Post date:** [October 17, 2024, 7:31pm UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/5 "2024-10-17T19:31:03Z")

</div>

Hi again!

I would like to set the default value in my menu selection input to orderId number 8 when running the flow, instead of the first value in the list. How can I retrieve this specific value from the list?

![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/a1031e1048eab4786ad66726e673f160041c3a4a.png)

---

<div class="post-metadata">

**Author:** ![Alluse](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/alluse/32/1013_2.png) [@Alluse](https://forum.novacura.com/u/Alluse)\
**Post date:** [October 18, 2024, 6:24am UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/6 "2024-10-18T06:24:05Z")

</div>

Hi again :).

Many of the user steps items can have a default value. Apart from sorting the list you can also provide a default value for list selections, like this:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/novacuratalk/original/1X/c2962a3972f26448169522f3e736d87572f0ff5a.png)

---

<div class="post-metadata">

**Author:** ![FAF1](https://avatars.discourse-cdn.com/v4/letter/f/7C9FD7/32.png) [@FAF1](https://forum.novacura.com/u/FAF1)\
**Post date:** [April 8, 2025, 3:22am UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/7 "2025-04-08T03:22:14Z")

</div>

Hi Alluse,

Sorry for replying on this thread but might be related so I tried.  
I wanted to use List Selection Input but the table comes from SQL.  
How can i add an “NA” option in my table to display in the field?  
I hope I am clear on this.  
Hoping for a response soon!

Regards,  
Faye

---

<div class="post-metadata">

**Author:** ![daniel](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/daniel/32/708_2.png) [@daniel](https://forum.novacura.com/u/daniel)\
**Post date:** [April 17, 2025, 7:16pm UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/8 "2025-04-17T19:16:58Z")

</div>

You can do it one of two ways:

1. Add a union to your sql query with a bunch of empty column names except the one you are displaying in the Input selection
2. Append a record to your existing query using flowscript

---

<div class="post-metadata">

**Author:** ![FAF1](https://avatars.discourse-cdn.com/v4/letter/f/7C9FD7/32.png) [@FAF1](https://forum.novacura.com/u/FAF1)\
**Post date:** [April 21, 2025, 2:16am UTC](https://forum.novacura.com/t/fetch-2-different-tables-into-one-menu-selection/779/9 "2025-04-21T02:16:54Z")

</div>

thank you daniel that was really helpful!
