Unanswered

Scan QR Code and change stock value (Phone App)

(0) Share

Report

Posted on by VincentGiovanni

Hello great community!

I'm trying to build a PowerApp for my warehouse where you should be able to scan out physical products and input quantites taken out for each product, and when the you submit the collection I need it to decrease the scanned article in my Inventory SP list.

The Inventory List consists of:

Article ( Single Line of Text)
ProduktName ( Single Line of Text )
Quantity ( Number )
Unit ( Choice )
Location ( Choice )
QRCode ( Attachment )
Price ( Currency )
Total Value ( Calculated Column Quantity * Price )
StringQRKod ( MultiLine Text || This is just a test column where the qr code attachment is a .dymo file and have copied the text in the qr code in this column )

The process is that each worker that comes through the warehouse will take one phone available and scan his Personal ID card, then he proceeds to scan multiple physical QR-code which is on the box and insert a quantity on each item that gets stored in a collection, thereafter when he submits the collection is patched the info gets stored in a separate SP list which is sort of a log. That part works fine and is basically done, but the struggle I've is how i can match the scanned qr-code and reduce the quantity item of my inventory SP list.

I can't seem to "match" the QR-code to my Inventory List and since the Qr-codes are stored as an attachment and is a .dymo file, the conversion to Base64 string is unavailable.

The increase of quantity will be done through a form for the warehouse staff when items arrive by searching Articlenumber.

I've been working on this for weeks (Months....) and my time is running out, what is it I need to do in order to reduce the quantity scanned out for each scanned item?

Best Regards

Categories:

Building Power Apps

Inventory_List.PNG

qrCodeAttachmentF...

I have the same question (0)

All responses (5)

Answers (0)

Aapok on at

Like (0)

Report

Could you post a picture of what gets stored to the other SP list (log) and/or the collection of scanned QR codes?

Was this reply helpful? Yes No
VincentGiovanni on at

Like (0)

Report
Hello again,

Of course!
Columns of Log SP List
idKort (Single Line of Text) this is the workers personal IDcard that gets scanned
Produkt ( Sinle Line of Text) is the Qr-code embedded text
Antal (number) = quantity in english
Enhet ( Choice ) = Unit
Tidspunkt (Date or Time ) = Timestamp
See attached files, is it this that you are looking for?

Best Regards

LogSPList.PNG

CollectionInApp.jpg

CollectionSyntax.PNG

Was this reply helpful? Yes No
Aapok on at

Like (0)

Report
Looking at the pictures a bit closer, does your QR code include the ArtikelNummer for each item? Assuming they are unique, you could try extracting that from the string, and using the ArtikelNummer to match to the inventory list.

Something like this:
UpdateContext(someVar, Left(QRString, Find(" ", QRString) - 1)) //This finds the first index of whitespace in your text and returns everything to the left of it (ArikelNummer)

Then use it like this:
Patch(SP_Inventory_List, LookUp(SP_Inventory_List, ArtikelNummer = someVar /*ArtikelNummer split from the string*/, {/*Your changes here*/})

Free typed quickly so there might be errors, but this should guide you to the right direction.

Was this reply helpful? Yes No
VincentGiovanni on at

Like (0)

Report

I'll try this right away!

just to be clear, where do you mean the UpdateContext syntax should be applied, in the collect Button with the rest of the code or at the Patch Button?

Was this reply helpful? Yes No
Aapok on at

Like (0)

Report

It depends on how you're implementing the patch to the inventory list. You don't even necessarily have to set it to a variable, I just did so for the sake of clarity. The main takeaway is to use the Split ArtikelNummer in the LookUp inside your patch.

Was this reply helpful? Yes No