How to get label from Ref type EnumList

[Gaius]

I have a table with an EnumList column of Ref type. I’m trying to populate a Show type column that shows the selected EnumList items as new-line delimited text. However, it only returns the Keys, not the Labels.

How can I get the labels for an enumlist? Thanks in advance.

Safe (Enumlist with base Ref type) column:

Safe Pretty (Show type) column:

Output:

[Suvrutt_Gurjar]

Maybe there is a better way but you could try with a traditional approach of SELECT() to get label name list.

SELECT(Lab Inspection Issue Type[Lable Column], IN([Key of Lab Inspection Issue Type ], [Safe]))

[Steve · Accepted solution]

Try:

SUBSTITUTE([Safe][label-column], " , ", "
")

Replace label-column with the name of the table’s label column.

See also:

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

[Suvrutt_Gurjar]

Steve:

SUBSTITUTE([Safe][label-column], " , ", "
")

Oh , yes that is a much better approach @Steve

[Ethorup]

Sorry, but I am running into the same issue but I can not for the life of me figure out where you are putting the Substitute command.  Can you clarify this a little bit for me?  thanks.

[Steve]

Noted way up in the original post:

It's used as the App formula expression of a column of type Show.

[Gaius]

Worked great. Thank you!