web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How the barcode scan c...

Power Apps

Unanswered

How the barcode scan can automatically fill a text box

(0) Share

Report

Report

Posted on by ginicolini

26

Hi,

I've created an app where I've already registered all of our cleaning products, with the following boxes filled:

- Item code

- Item description

- Barcode

Now I need that, when I use the barcode scan, it automatically fill those boxes, and the only thing I have to inform it's the quantity and if it's entering or existing our warehouse.

I couldn't find in the internet the code/formula for this use. I'm not using an "galery" in the PowerApps, I'm using an "form". (image linked bellow)

Captura de tela 2023-07-18 152448.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

mfvelazquez 17 on at

Like
a
(1)

Report
Copy link

Link copied!
You can perform a LookUp with data from scanning and save it in a variable.

BarcodeReader1.OnScan:
Set( vItemScanned, LookUp( myTableOrCollection, columnToCompare = First(BarcodeReader1.Barcodes).Value ) )

Then you can set de Default property of each text input with values from vItemScanned variable.

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ginicolini Please try this solution:

Set the Default property of the barcode scanner control:
BarcodeScanner1.Value
OnScan property add this formula to retrieve the item details, and OnScan property of the barcode scanner control triggers this formula:

UpdateContext(
{
selectedItem: LookUp(
ProductList, // Replace with the name of your product list
Barcode = BarcodeScanner1.Value
)
};
Set(itemCode, selectedItem.ItemCode);
Set(itemDescription, selectedItem.ItemDescription)
)

replace "ProductList" with the actual name of your product list.

Bind the itemCode and itemDescription in your form by set the Default properties of the Text input of your data cards as follows:
Item code field: itemCode
Item description field: itemDescription
With these steps, when you scan a barcode using the barcode scanner control, the item code and item description fields in your form will be automatically populated based on the scanned barcode's match in your product list.

Kind Regards,

Was this reply helpful? Yes No

Join the conversation