Lookup choice value in different table

(0) Share

Report

Posted on by KV-09061058-0

Hello specialists,

I have made a custom app and added a text field. The app is linked to several tables.

The text field is shown after the user clicks on a item in Gallery_Artikelen.

I want to look up and show the price in table Prijzen, column Price. So I made this formula:

"€ " &

(LookUp('Prijzen'; Artikel_handmatig = Gallery_Artikelen.Selected.'Glas 1'.Value; Prijs)) & " per kg"

The name Artikel_handmatig is a text field.

The Glas 1 is a Choice field. The text in this choice is exactly the same as Artikel_handmatig, double checked.

But, it does not work. Power Apps says .Value is invalid and not recognized.

What is the correct way to lookup a choice value in a different column in a different table?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Foxman_NL , Does Artikel_handmatig is also of Choice type column in data source? If yes, then try this:
"€ " & (LookUp('Prijzen'; Artikel_handmatig.Value = Gallery_Artikelen.Selected.'Glas 1'.Value; Prijs)) & " per kg"
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
KV-09061058-0 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ANB ,
No Artikel_handmatig is a text type column.
To me it looks like .Value is not a excisting term. Maybe because my browser is in Dutch, but I tried translations of .Value and I've been looking for official translations in the Power App info websites. But they all seem to use .value anyway.

I tried your suggestion anyway, but get the error that the dot behind Artikel_handmatig is incorrect usage.
The .Value behind Gallery_Artikelen.Selected.'Glas 1' remains a invalid name.

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Foxman_NL , My suggestion was only applicable if Artikel_handmatig of choice type. But as you mentioned that Artikel_handmatig is of text type, then what happen when you try this:
"€ " & (LookUp('Prijzen'; Artikel_handmatig = Gallery_Artikelen.Selected.'Glas 1'; Prijs)) & " per kg"

Thanks,
ANB

Was this reply helpful? Yes No
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Foxman_NL Can you also share the screenshot of column type: .'Glas 1' from your data source.

Thanks,
ANB

Was this reply helpful? Yes No
KV-09061058-0 12 on at

Like
a
(0)

Report
Copy link

Link copied!

In the mean time changed the language of my browser so Power Apps is now also in English.
So my errors are in English in stead of Dutch, mutch better for trouble shooting.
To double check, I tested if .value now works, but that gives this error:
Name isn't valid. 'Value' isn't recognized.
.Value error

The first option you mentioned is one I tried as well, but that gives me a Error:
Error when trying to retrieve data from the network: A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.Int32' for operator kind 'Equal'.
See screenshot
Screenshot of error "€ " & (LookUp('Prijzen', Artikel_handmatig = Gallery_Artikelen.Selected.'Glas 1', Prijs)) & " per kg"

This is the screenshot of the Glas 1 in datasource table Polyester artikelen; and the choice list it goes to
Screenshot Glas 1 Screenshot choices

Was this reply helpful? Yes No
Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Foxman_NL , Thank for all screenshots. Ideally you should provide all these information in your first post itself to save time. Basically as data source you are using is Data verse as table and that too be with Choice as data type. So below code should work:

"€ " & (LookUp('Prijzen'; Artikel_handmatig = Text(Gallery_Artikelen.Selected.'Glas 1'); Prijs)) & " per kg"
Basically, option set value and text cannot be compare. Hence we need to use Text() function.
I tried on my side and it worked for me.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
KV-09061058-0 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @ANB , this worked like a charm.
I'll keep in mind to post screenshots asap. I tried to do explain by text, but as they say, a picture says more than a thousand words.

Was this reply helpful? Yes No