Unanswered

Show a value that comes from a lookup column

(0) Share

Report

Posted on by Hii_iii

691

Hello. I created a gallery called "Gallery2" and it is connected to my list called "Project". In my "Project" list, I have a search column called "Brands_Rch" which comes from the "Brands" list. I would like to display in my gallery a label which displays the values of my "Brands_Rch" column but I have this error message: "Incompatible types for comparison. It is possible to compare these types: Number, Table". Can you help me please?

Here is the code for my label: LookUp(Brands; ID = ThisItem.Brands_Rch.Id; Title)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

gulshankhurana 1,397 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @s44

Please could you replace semi colons with commas and try again.

Kind regards
Gulshan
Please give it a thumbs up 👍🏻 if you appreciate my efforts.
If my answer helped you resolve your issue then please also mark it as a solution ✅ so that it helps others experiencing the same problem.

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @s44 ,

"Search" columns can be a real pain and most people simply choose to not use them at all. I wouldn't recommend using them either, as they can prove to be messy and sometimes really not easy to use.

If possible, could you replace your "Search" column with a "Number" column to store your "Brand" ID? Or do you need this "Search" column for a specific purpose?

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

If I put commas instead of semicolons it indicates a syntax error. In French we do not use commas in the Power FX language @gulshankhurana

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

I need the lookup column to indicate which brands each row in my "Project" list corresponds to. But if it is possible to do otherwise, I am willing to do otherwise! @WiZey

Was this reply helpful? Yes No