Barcode Scanner function to check if the scanned item is already exists

(1) Share

Report

Posted on by DTamang

Hi All,

I am new to the PowerApps so any help is highly appreciated.

I am currently struggling to write the correct code for my requirement.

I have a simple barcode scanner app.
I want to add a simple check function on the Scan button to display "Duplicate Item- Its already exists in the system" if the scanned item is already recorded.

Scan button is BarcodeScanner1
Barcode text input is DataCardValue4
Data source is IT Inventory

Please help !!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

EricBLott 248 on at

Like
a
(1)

Report
Copy link

Link copied!

You'll need to use a LookUp() function and IsBlank() to see if it exists. Lookup() checks the data source for a record and IsBlank() will tell you whether a record was returned.

IsBlank(Lookup(DataoSource,barcodeValue = DataSource.barcodeValue))

Was this reply helpful? Yes No
DTamang 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @EricBLott , much appreciated for your response.
Still getting error.
Apologies in advance if I am making some silly errors.
If(IsBlank(Lookup('IT Inventory',DataCardValue4 = DataCardValue4)),Notify("Item already exists");

Was this reply helpful? Yes No
Verified answer

EricBLott 248 on at

Like
a
(1)

Report
Copy link

Link copied!

In your LookUp() function, you need to reference the value of the control, so for example DataCardValue4.Text. You also need to compare this value to your data source column, like 'IT Inventory'.yourBarcodeColumn.
So you'll use something along these lines..
DataCardValue4.Text = 'IT Inventory'.yourBarcodeColumn

Was this reply helpful? Yes No
DTamang 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @EricBLott

Was this reply helpful? Yes No