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)

365-Assist 2,324 Moderator on at

Like (0)

Report

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
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
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