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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sharepoint customized ...
Power Apps
Answered

Sharepoint customized form not showing expected default of variable.

(0) ShareShare
ReportReport
Posted on by 207

 

I have a form for a sharepoint list that I am customizing in Powerapps.
I have added a datasource for another list called "Label Translations" which holds an English and Spanish text for each label in the form.
OnApp start and OnVisible of my form  I set a variable - Set(_language,"English") 

On the form I have added a dropdown box with 2 values for the items property ["English","Spanish"] and then I set the default for the dropdown to my variable _language.
I have a label on my form to show the variable _language and it does display "English".


Then in each of my labels for all the fields I have this formula If(_language="English",Parent.DisplayName,LookUp('Label Translations',Title="Label4").SpanishText)
However, when the form loads after clicking the New button on my sharepoint list, the form always loads the spanish text for the labels instead of the English which is desired.

Changing the dropdown selected value does switch the language.
However, the desired functionality is to default to English and always make the user choose to show in Spanish.
Do you think this is a bug or am I approaching this the wrong way?

Categories:
I have the same question (0)
  • barlowse Profile Picture
    207 on at

    Oh and another thing, when in the editor and playing the app it works fine, its just after its published to Sharepoint that it goes wrong.

  • Verified answer
    barlowse Profile Picture
    207 on at

    So, I fixed my form but would still like to know if there is something I need to be aware of in the future. So if anyone has any idea please let me know.
    I adjusted this formula

    If(_language="English",Parent.DisplayName,LookUp('Label Translations',Title="Label4").SpanishText) 

    on all my labels to be this instead 
    If(_language<>"Spanish",Parent.DisplayName,LookUp('Label Translations',Title="Label4").SpanishText)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 638

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard