Writting labels from an enum list with Base Type Ref

[maretec]

I want to write the labels of an enum list with base type Ref, but I haven't found the formula to do it.

This is the enum list with base type Ref column.

This is the "Piezas Chapistería ID" column in my Google Sheet.

Here you can see the column in the form view. The user must be able to select one or more items and create a new item.

I want to write the labels in the column "Piezas Chapistería".

I have to create a PDF, so if I do it with the "Piezas Chapistería ID" column, I'll get the keys instead of the labels (values) of those keys.

The table "Piezas Chapistería" has just 2 columns, the ID and the label as seen below.

I have tried different formulas.

Can anyone help me with this?

[TeeSee1 · Accepted solution]

SELECT(Piezas Chapistería[pieza], IN([Pieza id], [_THISROW].[Piezas Chapistería ID]

[maretec]

I knew that the IN expression is a Y/N expression, but I didn't realize that used together with the SELECT expression it is like SELECT(Table[Column], TRUE).

The formula works fine. Thank you @TeeSee1.

When entering the formula, the editor gave me an error because it automatically sets it as a LIST type column and only virtual columns can be of this type. I tried columns of type EnumList and Text, and the formula works with both.  Does it matter if I choose one or the other?

[maretec]

In my application, it is important to set the column as EnumList, because I have to put those values/labels in PDF, each on a single line as shown below.

If I set them as Text, all the values/labels are placed in one paragraph, one next to the other.

As a matter of fact, you gave me the solution to put those labels each on a single line.