How can I create "A qr code matching app for Material pickings".

(0) Share

Report

Posted on by Kumashiro

I'd like to create "A qr code matching app for Material pickings" with MS Power Apps.

Please take a look an attachment pdf file.

As a no-code tool, I use Appsheet. However, Appsheet doesn't seem to be able to change the display on the screen to "OK" when the imported QR is consistent with the master data.
If this is possible with Power Apps, I would like to try using Power Apps.

I would appreciate your feedback.

qr-code-matching-...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-albai-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Kumashiro ,
I think PowerApps can achieve your purpose. I did a simple demo on my side for your reference:
1. My master data is keep in a SharePoint list called "list10". QRcode and Quantity columns are both Text column.
2. In my app, I add a blank Gallery and set its DataSource to my list 10. Inside this gallery, add two Label controls and rename them to "ID" and "Title". Set Text property of ID toThisItem.ID and set Text property of Title to ThisItem.Title:

3. Still inside gallery, besides Title control, add a "Barcode scanner" control and rename it to "BarcodeScanner1"(for scan), and besides this BarcodeScanner1, add a label and rename it to "BarcodeValue"(will show QR code after scan). Set Text property of BarcodeValue to BarcodeScanner1.Value:
4. Besides BarcodeValue control, add a TextInput control and rename it to "Quantity"(for input its qty), set its HintText property to "input quantity here":

5. Besides Quantity control, add a Label control and rename it to "Result", set its Text property to:
If(!IsBlank(Bracodevalue.Text=ThisItem.QRcode)&&!IsBlank(Quantity.Text),If(Bracodevalue.Text=ThisItem.QRcode&&Quantity.Text=ThisItem.Quantity,"OK","NG"),"--")

then set its Fill property to:
If(Result.Text="OK",Green,Result.Text="NG",Red,Result.Text="--",White)
This time, after step 5, if QR code(Barcodevalue control) and qty(quantity control) both are blank, the result will show "--" with white color, if both the QR code and the qty contained in the master data(my SP list), it will show "OK" with Green color, if not match, it will show "NG" with red color.
6. Outside the gallery ,add a button, rename it to "SendButton", set its Text property to:
If(CountIf(Gallery3.AllItems, Result.Text="OK")= CountRows(Gallery3.AllItems),"Completed","Cancel")
So that when all result values in above gallery are "OK", the button will show as "Complete". Then you can set its OnSelect property with your own formula to send data to your server.

Result like this(The marking values don't match the ones in my SP list):
Best regards,
Allen

Was this reply helpful? Yes No
Kumashiro 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer.
Thanks to your explanation with some images, I feel that I can achieve what I want to do.
I haven't used Power Apps yet, so I don't understand everything you explained, but I will give it a try.
Thank you very much.

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Kumashiro ,
Glad my solution can help you. Since you haven't used Power Apps yet, I would suggest you study basic knowledge first, or you will meet many difficulties when deploy an app like above.
Besides, if my solution is helpful to you, please mark my answer. This will benefit other community members who stuck with the same question.
Best regards,
Allen

Was this reply helpful? Yes No