Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Show a value that comes from a lookup column

(0) ShareShare
ReportReport
Posted on by 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)

  • s44 Profile Picture
    s44 691 on at
    Re: Show a value that comes from a lookup column

    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 

  • s44 Profile Picture
    s44 691 on at
    Re: Show a value that comes from a lookup column

    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 

  • WiZey Profile Picture
    WiZey 3,023 on at
    Re: Show a value that comes from a lookup column

    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?

  • gulshankhurana Profile Picture
    gulshankhurana 1,383 on at
    Re: Show a value that comes from a lookup column

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard