Gallery text return two values with lookup

(1) Share

Report

Posted on by AG-21101159-0

I have an issue using lookup to translate from data source file

LookUp(Translation,key="item" And Title=setLang,Value)
 
the issue is that the lookup return with two value while there is only one value in the data source file.
 
and if I use thisitem.item it only shows the correct value.
 
I am trying to translate the full page but the issue with gallery that return two values

Categories:

General Questions

All responses (5)

Answers (0)

Suggested answer

SaiRT14 1,961 Super User 2025 Season 1 on at

Like (1)

Report
Gallery text return two values with lookup

Pls check the following:

The issue might be due to the logical conditions (key="item" And Title=setLang).

LookUp(Translation, key = "item" && Title = setLang, Value)

Even if you expect only one value in the data source, there might be duplicate entries for the same key and Title in the Translation table.

If you're using this inside a Gallery and it’s returning multiple values, it may be because the Gallery context (such as ThisItem.item) is conflicting with the LookUp function.

LookUp(Translation, key = ThisItem.item && Title = setLang, Value)

If there are still multiple matches and you only need the first match, you can wrap the LookUp in a First() function

First(LookUp(Translation, key = "item" && Title = setLang, Value)).Value

Use a Label control to display the results of your LookUp function temporarily

Text(LookUp(Translation, key = "item" && Title = setLang, Value))

try out ping me if you require more details.
Nandit 1,563 Super User 2025 Season 1 on at

Like (1)

Report

Gallery text return two values with lookup

Hi AG-21101159-0,

Can you share how you have things up for translation and what are you trying to translate?

Kind regards,

Nandit
timl 34,935 Super User 2025 Season 1 on at

Like (1)

Report

Gallery text return two values with lookup

Where in your app are you calling LookUp?

The property that controls the items that are shown in a gallery is the Items property. This property expects a Table and it's this formula that results in the 2 items that are shown in your gallery. Therefore can you confirm the formula that you've used here?
AG-21101159-0 4 on at

Like (1)

Report

Gallery text return two values with lookup

I tried both but it did not work for me
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (1)

Report
Gallery text return two values with lookup

Hi AG-21101159-0,

Can you try using the following please:

LookUp(Translation,key="item" And Title=setLang)

Or if you are trying to get a value from a specific column, you could use the following:

LookUp(Translation,key="item" And Title=setLang).ColumnName

If this doesn't work I would suggest you share how you have things up for translation and what are you trying to translate? What do you mean by translating the whole page?

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!