Hi,
I have a Dataverse table with a Country list, with several columns including the country name in different languages (E.g.: Country_EN, Country_ES and so on). I created different views to display and order alphabetically the country list depending of the selected language.
When I insert the Country field in form, I also created a metadata to Render Lookup as Drop down field.
I can display the correct order in English, but the problem is If I select e.g. Spanish (only translated a few countries for testing purposes), but I can't display the correct order. The dropdown will only display the primary column (English_ES) but in the equivalent "Spanish order".
English:
Spanish:
In this example, it shows Germany (English) but I want to display the "Country_ES" column with the correct name in Spanish, which is "Alemania".
Is there any way to Render Lookup as Drop down field, but displaying a different table column (other than Primary)? Any workaround?
Thanks in advance.

Report
All responses (
Answers (