UNION query of two or more selects

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())

To merge to lists you can just use

{List 1} + {List 2}

1 Like

Or, more efficient:

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

See also:

1 Like

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 !

1 Like