How to show 2 values in a dropdown menu EnumList?

[rafaelpazsud]

I have the enumList below

However, I wanna to show like this:
- INCOME_HH - 25
- POLITICAL_PARTY - SOME OTHER VALUE
ETC...

I tried to within Data Vality to  CONCATENATE SELECT(VW_MKT_COLUMNS[COLUMN_NAME],true) with the other value, however I'm getting error.

[jballester]

Hi 

... without using concatenate
have you tried marking the two fields in the source table enumlist as labels?
Also check that the field's "show" option is checked

 

[rafaelpazsud]

Thanks, however, for me it didn't work though.

[MarceloStein01]

Only 1 column can be "label" (exception: if one is text and other is image, you can have two)

on original table, you can concatenate this value? If yes, make a virtual column with concatenation, and this column set as "label"

[Steve]

To do what you want, the EnumList column would have to have a base type of Ref and the label column of the referenced table would have to be the text you want displayed in the dropdown.

[rafaelpazsud]

I have a table in BQ (source) with two columns, on the Appsheet enum list, I wanna to combine the values of both columns together to show to the user(as I mentioned above). After the user selects one or more options from the enum list, I wanna get ONLY the value of the first column and put it into a virtual column, something like that.. 
It seems Appsheet still very imature for some basic stuff... I'll try to sort something else.

but thanks for the help though!