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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

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

Was this reply helpful? Yes No
AG-21101159-0 4 on at

Like
a
(1)

Report
Copy link

Link copied!

I tried both but it did not work for me

Was this reply helpful? Yes No
timl 37,269 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi AG-21101159-0,

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

Kind regards,

Nandit

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(1)

Report
Copy link

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

Was this reply helpful? Yes No