Answered

Formula translate dropdown

(2) Share

Report

Posted on by MDR26

Hello,

I found this formula to translate items from a dropdown to another language. Can someone tell me how i need to write down dutch - Belgium?

[
 {
 Label: If(Language() = "en-US", "All", <add Arabic word>)
 ID: "All"
 },

Categories:

General Questions

I have the same question (0)

All responses (6)

Answers (1)

Hassan_SZ_365 542 on at

Like (0)

Report
Re: Formula translate dropdown

Hi @MDR26 ,
To add Dutch (Belgium) to your dropdown list, you would check for the language code for Dutch (Belgium), which is "nl-BE". Here is how you can add it to your formula:

[ { Label: If(Language() = "en-US", "All", Language() = "nl-BE", "Alles", <other conditions here>), ID: "All" }, // ... add more items as needed ]

In this case, "Alles" is the Dutch word for "All". You would replace <other conditions here> with any other language checks and translations you need.
Best Regards,
Hassan Raza

Was this reply helpful? Yes No
KeithAtherton 3,690 Most Valuable Professional on at

Like (0)

Report
Re: Formula translate dropdown

Hi @MDR26,

You can use the translation service, info here:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-language#translation-service

If you provide translations manually as per your code sample, try the following to provide multiple languages:

{ Label: Switch(Language(), "en-US", "Hello", "fr-FR", "Bonjour", // etc ) ID: "All" }

More info on the Language function and language tags here:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-language

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
MDR26 on at

Like (1)

Report

Re: Formula translate dropdown

I tried this formula but i doesn't work.

Choices([@'LIST'].'Document')
[
{Label: If(Language() = "nl-BE", "Huurovereenkomst",
Language() = "fr-FR", "Contrat de location",),
ID: "Huurovereenkomst"},
{Label: If(Language() = "nl-BE", "IT-overeenkomst",
Language() = "fr-FR", "Contrat informatique",),
ID: "IT-overeenkomst"},
{Label: If(Language() = "nl-BE", "Dienstverleningsovereenkomst",
Language() = fr-FR", "Contrat de service",),
ID: "Dienstverleningsovereenkomst"},
{Label: If(Language() = "nl-BE", "Andere",
Language() = "fr-FR", "Autre"),
ID: "Andere"}
]

Was this reply helpful? Yes No
KeithAtherton 3,690 Most Valuable Professional on at

Like (0)

Report

Re: Formula translate dropdown

Do you have more information? Such as does it show an error / do something unexpected / do nothing, etc?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
MDR26 on at

Like (1)

Report

Re: Formula translate dropdown

I get the error unexpected characters, the first [ is underlined. Further its doing nothing.

Was this reply helpful? Yes No
Verified answer

KeithAtherton 3,690 Most Valuable Professional on at

Like (0)

Report

Re: Formula translate dropdown

The Choices function works like this:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-choices

Another option would be to build a collection using the ClearCollect function and use that for the dropdown control Items property:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-clear-collect-clearcollect

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No