Multilingual app - Excell - LookUp

[MDR26]

I imported my Table from my Excell file to my App.

Then put this formula in the textbox LookUp(Table1,Language = varCurrentLanguage && Key = "Titel_1ID").Value

I don't get an error but I see a blanco field. My text doesn't appaer?

Does someone know why?

[Pro_User_365]

Hi  @MDR26, 

1. Check Data: Confirm that your Excel table (Table1) contains the expected data, and there is a record where Language = varCurrentLanguage and Key = "Titel_1ID".

2. Field Existence: Ensure that the field you are trying to display (e.g., Value) exists in the data source.

3. Display Mode: Check the TextBox's DisplayMode property. If it's set to Disabled, the text won't appear. Set it to Edit or View.

4. Control Default: Verify that the TextBox doesn't have a default value that might override the LookUp result.

   Example Formula:

   LookUp(Table1, Language = varCurrentLanguage && Key = "Titel_1ID").Value

   By examining these aspects, you should be able to identify and resolve the issue. If the problem persists, please provide more details for further assistance. 😊

   Regards! Ali Shahzad

[MDR26]

@Pro_User_365 
I checked everything but I don't find an issue.
Dropdown setup - On Change - Set(varCurrentLanguage, Dropdown.Selected.Value)

- Items - ["nl","fr"]

App - On Start - Set(varCurrentLanguage, Coalesce( Lower(Left(Language(),2)),"nl"))

Text - LookUp(Tabel1,Language = "varCurrentLanguage" && Key = "Titel_1ID").Value

[Pro_User_365 · Accepted solution]

Hi @MDR26 ,

It seems there might be an issue with the Lookup formula. Try replacing "varCurrentLanguage" with varCurrentLanguage (without quotes) in your Text formula. The corrected formula would be:

LookUp(Tabel1, Language = varCurrentLanguage && Key = "Titel_1ID").Value

Using quotes around varCurrentLanguage might be treating it as a string, not a variable. After making this adjustment, check if the text now appears as expected. If the issue persists, ensure that the varCurrentLanguage variable is being set correctly in the app. Feel free to reach out if you need further assistance! 😊

Regards! Ali Shahzad

[MDR26]

@Pro_User_365 Thank you 🙂

Can you tell me if it's also possible to translate the values from a dropdown and radio buttons with the Excell file?

[Pro_User_365]

Hi @MDR26 ,

Yes, it's possible to translate values in dropdowns and radio buttons using Excel. You can create a translation table in your Excel file, mapping the original values to their translated equivalents. Then, in PowerApps, use LookUp or other functions to fetch the translated values based on the user's selected language. This way, your dropdowns and radio buttons dynamically display the translated options. If you need assistance with the specific implementation, feel free to share more details! 😊 Regards! Ali Shahzad

[MDR26]

@Pro_User_365 
All my original values and translations are in the Excell. I just wondering how i combine the choices with the lookup. Now i have my DataCardValue - Items - Choices(list in Sharepoint). 'Item') 

[Pro_User_365]

Hi @MDR26,

To combine choices with Lookup for translating dropdown and radio button values, modify your formula:

LookUp(TranslationTable, OriginalValueColumn = DataCardValue.Selected.Value).TranslatedValue

Replace TranslationTable with your Excel table, OriginalValueColumn with the column containing original values, and DataCardValue.Selected.Value with the selected value from your dropdown or radio button. This fetches the translated value dynamically. Give it a try! 

Regards! Ali Shahzad

[MDR26]

@Pro_User_365 I added the Original Values in a Column and the Translated Values in another Column.

Then I set the formula to LookUp(Tabel2, OriginalValueColum = DataCardValue1.Selected.Value). TranslatedValue with no result. 

[Pro_User_365]

Hi @MDR26 ,

For this question please open new ticket then i will help you.