Not getting to work USERSETTINGS()-based translation in dereferenced columns. any ideas?

[pawann]

Dear all

Based on the chosen Language set via usersettings(“Language”), a virtual column should concatenate two columns:

• the translated name of an item the user has selected from the ref dropdown
• user text input

Example:

Usersettings:
USERSETTINGS(“SiteLanguage”) = “DE”

User Input:
[User Input] = “Hallo”

Enum Table from which user selects an item in the form column [Select]:

ID°	EN	DE	FR	IT	Translation**
set1_dog	Dog	Hund	Chien	Cane	Hund
set1_cat	Cat	Katze	Chat	Gato	Katze

° key column
** virtual column, used as label.
column formula:

SWITCH(
  USERSETTINGS("SiteLanguage"),
  "DE", [DE],
  "FR", [FR],
  "IT", [IT],
  [EN]
)

The “Translation” column is properly used to label the selected item.

However, when trying to access the item’s translated name through dereferencing [Select].[Translation], the fallback value from the switch statement is returned instead of the correct translation [Select].[DE].

Directly accessing the German translation through dereferencing is working as expected.

Please refer to the screenshot.

Question:

How in this case can I access the translated String so that the result of the concatenation example is
Hund: bla instead of Dog: bla?