web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup of a Barcode Sc...
Power Apps
Answered

Lookup of a Barcode Scan (newbie number vs text)

(0) ShareShare
ReportReport
Posted on by 88

Hi All,

 

Sorry for the stupid question, I am a total newb.

Believe me, I have tried to get this working in vain 😞 

 

I have a simple sharepoint list called barcodes

Barcode            Product      Stock

111                   Apple         3

222                   Orange      12

 

Barcode is a number Product one line text, stock a number

 

I have added a barcode scanner to the app and set the onscan to set the value of a variable called BC, which I have proved working by creating a label that shows the value of BC.

 

I then want two labels to display the values in the list so I have set the label to be Lookup(Barcodes, Barcode = BC, Product) and for the second, (lookup(Barcodes, Barcode=BC, Stock) but it gives me an incompatible types for comparison error.

Could someone please give me the syntax for each label please? I have tried Barcode = BC.text, Barcode = BC.value, encasing the entire lot in Text, all without success but it is because of my very basic understanding of Powerapps so far that is my issue :).

Thanks very much in advance for any help! It's driving me crazy 🙂

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @MikeWJS ,

     

    I think it will be warnings for the incomparable data type, but you should still be able to get the results.

     

    Would you please try below instead?

    LookUp(Barcodes, Barcode = Value(BC), Stock)

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • MikeWJS Profile Picture
    88 on at

    I worked this out as I needed to push on, but thank you very much for your response, you were 100% correct!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 839

#2
Valantis Profile Picture

Valantis 533

#3
Haque Profile Picture

Haque 412

Last 30 days Overall leaderboard