Multilingual app - Excell - LookUp

(1) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Pro_User_365 546 on at

Like (1)

Report
Copy link

Link copied!
Hi @MDR26,
Check Data: Confirm that your Excel table (Table1) contains the expected data, and there is a record where Language = varCurrentLanguage and Key = "Titel_1ID".
Field Existence: Ensure that the field you are trying to display (e.g., Value) exists in the data source.
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.
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

Was this reply helpful? Yes No
MDR26 on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

Pro_User_365 546 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
MDR26 on at

Like (1)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Pro_User_365 546 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MDR26 on at

Like (1)

Report
Copy link

Link copied!

@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')

Was this reply helpful? Yes No
Pro_User_365 546 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
MDR26 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Pro_User_365 546 on at

Like (0)

Report
Copy link

Link copied!

Hi @MDR26 ,
For this question please open new ticket then i will help you.

Was this reply helpful? Yes No