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

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Translations based on ...
Power Apps
Answered

Translations based on dropdown and SP list

(0) ShareShare
ReportReport
Posted on by Tinneke 13

Hi all,

 

I am a PowerApp beginner.

I want to change the text on a button (or label) depending on a dropdown on the screen (with fixed values).  

 

So I have a dropdown with the values "English" and "Dutch"

 

I have a sharepoint list that looks like this and I added the SP list as a datasource:

Translations

TitelEnglishDutch
button1Move to next screenGa naar volgend scherm
label2WelcomeWelkom

 

I can achieve what I want with a formula and fixed texts in that formula, but I want to easily add extra columns (languages) to the Sharepoint list.

 

I know there is a connector to automatically translate, but I want to control the translations.

 

I tried some different formulas like the below, but they don't work 

 

LookUp("button1",Translations,DropdownLanguage.Selected.Value)


I would then per label or button add a line on sharepoint and refer per button to the title I will give it on Sharepoint.

 

Thank you in advance for your help.

 

Kind regards, Tinneke

 

 

Categories:
Building Power Apps
I have the same question (0)
  • SpongYe Profile Picture
    SpongYe 5,909 Super User 2026 Season 1 on at

    Hi @Tinneke 

     

    Ik heb gekeken naar je code maar er moet nog een condition in zitten.

    Try this:

     

    LookUp(Translations, Titel = "button1", DropdownLanguage.Selected.Value)

     

     This would solve your problem.

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

  • Tinneke Profile Picture
    Tinneke 13 on at

    Thank you @SpongYe , that was another formula I tried, but that gives me "English" or "Dutch" on my button (changing if I change my dropdown).

  • SpongYe Profile Picture
    SpongYe 5,909 Super User 2026 Season 1 on at

    Hi @Tinneke 

     

    I would suggest to restructure your table as following:

    IDTranslation_TextTranslation_Lang
    scrceen1_button_submitMove to next screenEN
    scrceen1_button_submitGa naar volgend schermNL
    scrceen1_label2WelcomeEN
    scrceen1_label2WelkomNL

     

    This would be better to filter down the text and use the data as following:

    LookUp(
 Translations, 
 ID = "scrceen1_button_submit" && 
 Translation_Lang = DropdownLanguage.Selected.Value,
 Translation_Text 
)

     

    Ik hoop dat dit je helpt.

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

  • Tinneke Profile Picture
    Tinneke 13 on at

    Extra comment:  This works, then the label shows the correct translation:    LookUp(Translations, Titel = "Label_User_Instruction", Dutch)
    But I want to replace Dutch with the selection from the dropdown.  I believe the issue is that the items in the dropdown are TEXT.  How can I make my formula not treat them as "text"? 

     

  • SpongYe Profile Picture
    SpongYe 5,909 Super User 2026 Season 1 on at

    Hi @Tinneke 

     

    Based on your use case this would be a workaround.

    Try this:

    LookUp(
 Translations, 
 Titel = "Label_User_Instruction", 
 If( 
 DropdownLanguage.Selected.Value="Dutch",
 Dutch,
 DropdownLanguage.Selected.Value="English",
 English
 )
)

     If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

  • Tinneke Profile Picture
    Tinneke 13 on at

    Thank you again @SpongYe ,
    This works, I like it.... but I don't yet want to accept it as a solution, to leave this question open for other ideas.

    Reason?  This would mean if I get a request for an extra language, I would need to change the formula on each button/label/....

    Perhaps someone has an idea to automate it more, so I can just:

    1. add a column for an additional language to the Sharepoint list

    2. add in the dropdown for available languages, 1 extra text choice.

     

    Kind regards,

  • Verified answer
    SpongYe Profile Picture
    SpongYe 5,909 Super User 2026 Season 1 on at

    Hi @Tinneke 

     

    I can best say with certainty that it will not work.

    Purely for the fact that you have to add a column (English, Dutch) to your table.
    Therefore, my suggestion is to look at your table structure.

     

    IDTranslation_TextTranslation_LangTranslation_Lang_Long
    scrceen1_button_submitMove to next screenENEnglish
    scrceen1_button_submitGa naar volgend schermNLDutch
    scrceen1_label2WelcomeENEnglish
    scrceen1_label2WelkomNLDutch

     

    On the DropdownLanguage you can set Distinct() function:

    Distinct(Translations, Translation_Lang_Long)

    This will automatically remove the duplicates and set the langauge in the Dropdown without any adjustments in the app. 

     

    Then on the buttons, Labels and controls you can set the following code based on the name:

    LookUp(
 Translations, 
 ID = "scrceen1_button_submit" && 
 Translation_Lang = DropdownLanguage.Selected.Value,
 Translation_Text 
)

     This will automatically select the Translation_Text of the control without any need to customize if a new language is added. 

     

    Wish you good luck further. 

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

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

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans