Answered

Translate dropdown/radio buttons - Excel - Lookup

(1) Share

Report

Posted on by MDR26

I wanted to try and translate the values in dropdown and radio button by putting the original values + translated values in an Excel table.

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

How can I fix this?

Categories:

General Questions

All responses (9)

Answers (1)

Verified answer

Pro_User_365 546 on at

Like (1)

Report

Re: Translate dropdown/radio buttons - Excel - Lookup

Hi @MDR26 .
I'm glad to hear that you were able to resolve the issue using the distinct function! Sometimes, when dealing with complex data types and formulas, using functions like DISTINCT can simplify the process and eliminate compatibility issues. If you have any more questions or need further assistance, feel free to ask. Happy app building! 😊
MDR26 on at

Like (0)

Report

Re: Translate dropdown/radio buttons - Excel - Lookup

I tried everything without succes.
I used the distinct function and now its working.
Pro_User_365 546 on at

Like (0)

Report
Re: Translate dropdown/radio buttons - Excel - Lookup

Hi @MDR26,
Ensure Data Types Match: Confirm that the data types in Excel match those expected by PowerApps. Text fields in Excel should be plain text and not formulas that could result in an error state.
Use Text Function: Use the Text function to ensure you are comparing text to text in your lookup formula.
Proper Column References: Double-check that the column names used in the formula exactly match those in the Excel table. This includes checking for any hidden spaces or special characters.
Use Correct Syntax: The correct syntax for a lookup function in PowerApps using the Text function should be:
LookUp(Tabel2, Text(OriginalValueColumn) = DataCardValue1.Selected.Value, TranslatedValue)
Check for Errors in Excel: Make sure there are no errors in the Excel data source that might be causing the error type to appear in PowerApps.
MDR26 on at

Like (1)

Report

Re: Translate dropdown/radio buttons - Excel - Lookup

I tried but no result
Pro_User_365 546 on at

Like (0)

Report
Re: Translate dropdown/radio buttons - Excel - Lookup

Hi @MDR26 ,
To address the "incompatible types for comparison" issue, make sure to explicitly convert the data type of the OriginalValueColumn in your Excel table to match the type of DataCardValue1.Selected.Value. For example, if DataCardValue1.Selected.Value is of type Text, modify your formula as follows:
LookUp(Tabel2, Text(OriginalValueColumn) = Text(DataCardValue1.Selected.Value)).TranslatedValue
MDR26 on at

Like (0)

Report

Re: Translate dropdown/radio buttons - Excel - Lookup

I tried the above without success. I think the error occurs in the reference to the datacard / translated value.
Pro_User_365 546 on at

Like (0)

Report
Re: Translate dropdown/radio buttons - Excel - Lookup

Hi @MDR26 ,
To fix the "incompatible types for comparison" issue, ensure that both sides of the comparison have the same data type. In your case, convert one side to match the other.
LookUp(Tabel2, OriginalValueColumn = Text(DataCardValue1.Selected.Value)).TranslatedValue
Make sure to replace OriginalValueColumn with the actual column name in your Excel table.
MDR26 on at

Like (1)

Report

Re: Translate dropdown/radio buttons - Excel - Lookup

I checked my table
And then my formula in DataCardValue1 - Items

I get the issue incompatible types for comparison. These types can't be compared: Text, Error.
Pro_User_365 546 on at

Like (0)

Report
Re: Translate dropdown/radio buttons - Excel - Lookup

Hi @MDR26 ,
Use the LookUp function to find the corresponding translated value.
Update your formula:

LookUp(Tabel2, OriginalValueColumn = DataCardValue1.Selected.Value).TranslatedValue

Confirm that the column names (OriginalValueColumn and TranslatedValue) match the actual column names in your Excel table.
If the formula still doesn't work, check for typos, spaces, or any discrepancies in the column names. Ensure that the data types match.
Note: After receiving the answer, if you think it's helpful, please consider accepting it. 😊
Regards! Ali Shahzad