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)
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
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
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?
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.