Barcode Scanner to Sharepoint List Not functional

(0) Share

Report

Posted on by brandonluxe

Hi,

I have built a simple tracker for samples that we get in our office.

I created a SharePoint List, named 'Sample Tracker Inventory'.

Barcode Reader = BarcodeReader1

Trying to get data from barcodereader1 to output in DataCardValue10

sharepoint list.png

In the SharePoint List, I have the following columns:

Title

Barcode (single line text)

Date Item Received

Details

Sample Order #

Assigned To

Category

Customer

Branded, etc.

On Home screen, I have a gallery named BrowseGallery1 where I can select an item, edit the details, and submit changes.

However, I'm trying to implement a barcode scanner to be able to scan a barcode and put the value inside 'Barcode' column. This will save time with typing it in. However, I've searched all over the internet and can't find a formula that does this correctly because I'm poor at syntax. Please see below for pictures

This is what I have in OnScan property of barcode reader.

Patch('Sample Tracker Inventory',LookUp('Sample Tracker Inventory', WhoScanned=User().FullName),{Barcode:BarcodeReader1.Value})

I know I'm doing something wrong but too dumb to understand other people's posts. Any help will save me from losing my mind. Thank you in advance!!!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @brandonluxe,

With the following code you will Patch the barcode to the list when scanning:

Patch( 'Sample Tracker Inventory', LookUp('Sample Tracker Inventory', WhoScanned=User().FullName), { Barcode: First(BarcodeReader1.Barcodes).Value } )

What you may want to do is only save the barcode to the list when the user actually submits the form:

//OnScan Set(varScan, First(BarcodeReader1.Barcodes).Value) //Default property of your TextInput (will save when user submits the form) varScan //OnHidden of that screen Set(varScan, Blank())

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
brandonluxe 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM , thanks for the quick reply. I tried the first suggestion and getting these errors:

Is there an issue with 'Barcode' Column in SharePoint being Text? The reason I used text is because barcodes have text and numbers. Seems anytime I use .Value for 'Barcode' column it gives error that says it should be Text.

Thank you,
Brandon
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @brandonluxe,

The function seems to have issues with the WhoScanned column name. Would it be possible to double check whether this column is written correctly?

With the current set-up I would expect the WhoScanned column to be of type text.
brandonluxe 56 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM , I used the second set of functions and it worked. I actually didn't even have a column in Sharepoint for WhoScanned .... lol. Thanks for your help!!

Brandon