Can column display name be dynamic, I would like to show them in spanish for example.
Tried this formulas:
Lookup([_THIS], โColumnTranslationsโ, โColumnNameโ, โTranslatedColumnNameโ)
Select(ColumnTranslations[TranslatedColumnName], [_THIS]=[ColumnName])
But get an error message:
Column name โProduct Nameโ in Schema โProducts_Schemaโ has an invalid Display Name โ=Lookup([_THIS], โColumnTranslationesโ, โColumn Nameโ, โSPANISHโ)โ. Unable to find column โ_THISโ, did you mean โSPANISHโ?MORE INFOGO TO THE PROBLEM
Yes, the column display name can be dynamic.
Try using Expression Builder (click the flask icon in the expression box) to verify and test your expression. It might provide more information, or at least make it easier to troubleshoot.
Note, too, that [_THIS] refers to the column value, not the column name. If the goal is to translate the column name, youโll need to put the column name in the formula explicitly (which means you canโt reuse the exact same formula for every display name).
Just wondering if there is any progress on this now? Can we find the name of column names using any expression? It would save us a lot of time as we can use the same formula for all columns.
You can name the columns using any expression, yes, but thereโs (still) no way for a column to discover its own name, so you still need a separate expression for each column.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |