How to get label from Ref type EnumList

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:

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

2 Likes

Try:

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

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

See also:

3 Likes

Oh , yes that is a much better approach @Steve :+1:

2 Likes

Worked great. Thank you!

2 Likes