Fetch 2 different tables into one "menu selection"

Flow Classic
1

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

2

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
image919×580 23.6 KB

3

Thank you, that helped a lot.

BR, Viktor

1 Like
4

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

5

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

6

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
image933×540 15 KB

7

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

8

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