Answered

Barcode reader to check off a checklist

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

i am new to PA and i want to make an app where i can check off a checklist using barcode scanner and qr codes. The background is that its a onboarding app, and when new people go to different stations within our company, they should be able to scan a barcode at every station, e.g. the HR department. So when they go there, they scan a qr code, and then the app checks this visit off of the list for onboarding tasks.

although i did a really basic online course, I have no idea where to start and how to go about it, can anyone help me get started with this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

Have you seen this video yet?

https://www.youtube.com/watch?v=lMqYjOpRbRg

Shane Young introduces all the potentials of barcode control here and he is using a very simple screen layout that you can follow.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the advice. The problem is not to scan data and show it in a gallery or table. The problem is that the patch function doesnt seem to work somehow. I just cant look up the scanned value, for example "Station 1", and write "OK" in the next column.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Basically the "cheking off" from a checklist is the problem, the scanning works fine!

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

What you can do is put your Patch function on either the OnScan or the OnChange property of the Barcode Reader control.

OnScan – Actions to perform when a barcode is successfully scanned.

OnChange - Actions to perform when a property on the barcode reader control is changed, including output properties.

Patch function is the function you use to update the record in a SharePoint list.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for your effort. Meanwhile i managed to solve the problem.

Here is the code that worked for me:

OnScan:
Set(BarType;First(BarcodeReader1.Barcodes).Type);;
Set(BarValue;First(BarcodeReader1.Barcodes).Value);;
Set(BarUser;User().Email);;
Set(BarDate;Today());;
Patch(Tabelle1;Defaults(Tabelle1);{User:BarUser;Type:BarType;Value:BarValue;Datum:BarDate});;
Refresh(Tabelle1)

I think collections and excel just didnt work well, now i use global variables and a Sharepoint list, and it works like a charm 😉

Was this reply helpful? Yes No