UNION query of two or more selects

[Michel_LeBlond]

Is there a way to do the equivalent of a UNION query ?

I want to do this for a Valid If list in a drop down. Do I need to wrap this in an additional select statement ? It runs but returns the values of the first select only
SELECT(Preferences[Type], [FirstName] = ‘Master’) UNION SELECT(Preferences[Type], [UserEmail] = USEREMAIL())

[1minManager]

To merge to lists you can just use

{List 1} + {List 2}

help.appsheet.com

List Expressions and Aggregates

List expressions use and/or produce lists of values.

[Steve]

Or, more efficient:

SELECT(
  Preferences[Type],
  OR(
    ([FirstName] = "Master")
    ([UserEmail] = USEREMAIL())
  )
)

See also:

help.appsheet.com

OR()

Are any true?

[Michel_LeBlond]

Yup that was it , I tried with or earlier but was wrapping the or around the selects and not doing an or in the select statement !