Answered

Incompatible types for comparison. Number and Text

(0) Share

Report

Posted on by Bokaboi

Hi all,

This is my first attempt at making a Power App. My goal is a make a simple app for our warehouse staff to report production. I'm using the built in barcode scanner. Ideally they will simply scan a barcode, enter the number they produced, along with their name, and then click submit. This will then email their manager with the production report for verification.

I've uploaded a spreadsheet with a table called 'AllCodes' which is to translate the barcodes (column A "BCode"), to product code (column B "ProductCode), description (column C "Description") and UOM (column D "BaseUOMCode").

At my current level of understanding, I have managed to write LookUp functions, which can successfully search and return values for both description and UOM when I manually enter a product code. I seem to be running into issues comparing the output of the barcode scanner to my table, which should return the product code. I can't seem to get a scanned bar code to match in this table.

Thank you in advance for your assistance.

2022-07-11 10_06_38-Power Apps and 1 more page - Work - Microsoft Edge.png

Default value for 'Product Code':

LookUp(AllCodes,BCode = BarcodeScanner1.Value).ProductCode

Default value for 'Description' (works):

LookUp(AllCodes,ProductCode = ProdCode.Text,Description)

Default value for 'UOM' (works):

LookUp(AllCodes,ProductCode = ProdCode.Text,BaseUOMCode)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sounds like you are trying to compare a Text Value to a Number Value. Try using the Value function to convert the Text to a number Value function in Power Apps - Power Platform | Microsoft Docs
--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Bokaboi 47 on at

Like (0)

Report
Copy link

Link copied!
Hi Darren,

Thank you for taking the time to reply.
I did have a good search through the forums, prior to posting. It seems this is a common issue for beginners, myself being no exception. I did have a try wrapping the search value, and the table value in a 'Value' or 'text' function.
Example with value function:
LookUp(AllCodes,Value(BCode) = BarcodeScanner1.Value).ProductCode
I can understand how it would trip people up - I'm familiar with the VLOOKUP function in excel, which just seems to work regardless of the cell format. So that is my frame of understanding.
I've created a text label in PowerApps to output the value from the Barcode Scanner. To me it would seem to be a number, and thus I can't understand why it wouldn't be able to match the data in the table.

Text label:

Data in table (formatted as numbers):

App:
nbsp;i9

Was this reply helpful? Yes No
Verified answer

Bokaboi 47 on at

Like (1)

Report
Copy link

Link copied!
Hi Darren (and future readers).
The following code in default has resolved the matter.
LookUp(AllCodes,Text(BCode) = Label2.Text,ProductCode)

Was this reply helpful? Yes No