web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Formula translate dropdown

(2) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • Hassan_SZ_365 Profile Picture
    542 on at
    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

  • KeithAtherton Profile Picture
    3,690 Most Valuable Professional on at
    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.

  • MDR26 Profile Picture
    on at
    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"}
    ]

  • KeithAtherton Profile Picture
    3,690 Most Valuable Professional on at
    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.

  • MDR26 Profile Picture
    on at
    Re: Formula translate dropdown

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

     

  • Verified answer
    KeithAtherton Profile Picture
    3,690 Most Valuable Professional on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 655 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 391 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 225

Last 30 days Overall leaderboard