Power Apps USB Barcode Scanner
Вставка
- Опубліковано 5 вер 2024
- Learn how to use a scanner that is plugged into your PC or laptop. Turns out they just act like a keyboard so not all that tough to use. 😁
Video also includes: OnChange, Collect, Self, and SetFocus
Link to scanner: amzn.to/3oziEzI I do make pennies if you buy it. 😂
Power Apps Consulting and training at www.PowerApps9...
Hey Shane , Gino’s dad here . This is exactly what I needed . I am getting ready to scan in all my mechanical equipment at my building that I manage. Great info .. thanks !
Bro can you advise to me how?
@@sairamp1494 watch the video, friend.
This is right on time! We have an IT inventory system that I am trying to move away from and this is exactly what I'm looking for. The barcode scanner on the phone didn't work as well as expected, but I'm hopeful this will. Thanks!
Perfect!
Yeah the smartphone scanners can be a little annoying sometimes where you multiple barcodes near eachother
I just want to say man. You really had me my day with this video. I didn’t know it was possible to scan on power apps from a computer. This will help me a lot with a work project
Awesomeness 🤩
Wish you'd posted this a year ago! At least I was able to make my code better, thanks to you, thanks Shane!
Sorry. I will try harder next time. 😁
OMG this is what I need In this moment, I’m working on a tooling inventory app!!... I’m your fan.
Regards from Mexico!!
Awesome Val 😎
Yo iniciaré a crear una... puedo buscarte si tengo alguna duda? :D
Thanks for the video!! It was really helpful for the project I'm working on at the company. We were almost buying a tablet to use scan functionality. With this proposal we can keep monitors that we already have at the factory. Tks again!!
Great to hear!
Hey Shane, one question. Why ColScan gives me an error? Is your list in share point? pls help. Greetings from Peru
We look after a Dental Service that send the tools external to clean , each tray has a barcode so better tracking of the tools going in and out this will be perfect.
Awesome. Love it!
Perfect timing on the vid! Working on an inventory system and this was very helpful
Awesome 😎
Is it possible set this field only for the USB scanner and disable manual keying option?
You are awesome and your videos are so clear and crystal.
The variable has the value you want. Show it in a label and save it. No reason to have a text input if you don't want the user typing. :)
Awesome! It is a great complement to the barcode Scanner on mobile devices. Thank You for sharing!
Glad to help. 😀
The firing of OnChange event seems a bit off. The event is not triggered until you tab/enter out or select another field on the form....!
Yes, because the control doesn't Change until you leave it. Might not be the way you want it to work but it is how it has worked for as long as I can remember. 🙂
Good morning, Shane.
I can make an inventory that can create sequential barcode reading and quantity validator with the key read on the app screen.
Thank you very much for those contributions you make to us. I would like to have support with the same process in the video but grouping and counting the barcodes that are repeated, that is, if I scan the same barcode 3 times it will only show me a single one in the gallery and count 3... Thanks in advance
I will put this in my thinking machine. 😊
Basically what I would do is when I scan do a lookup into the collection. If there is a hit then add 1 to the count. If not add a new row.
Check out this video on Duplicates and do the opposite. ua-cam.com/video/Ap3_Ea9H8b0/v-deo.html
@@ShanesCows Thank you for your prompt response and collaboration.
@@julianvaldez1059 So the way you would do that. OnChange I currently have Collect(collectionname, {Barcode: Self.Text, When: Now()})
Change OnChange to be something like this: (Keep in mind this is quasi code from my memory)
OnChange: With({xScannedItem: Lookup(CollectionName, BarCode = Self.Text)}, If(IsBlank(xScannedItem.Barcode), Collect(collectionname, {Barcode: Self.Text, When: Now(), Count: 1}), Patch(CollecttionName, xScannedItem, {Count: xScannedItem.Count + 1})))
That is the logic and hopefully the working code but I am sure I have minor issues. But that is where I would start building the logic to do what you want. :)
Hope that helps
Worthy of a like and subscribe? 😜
hi shane, amazing tutorial
i have a question: we're using a similar power app but in a scanner that looks like a phone. how can I disable the keyboard from popping up?
Thank you, How compare data from scan value and patch to SharePoint list.
I went further in this video ua-cam.com/video/1rlPduDP_Ew/v-deo.html
Hey Shane, Great video, I have a RFID Scanner that acts as a keyboard. When i read the tag it show a bunch of Hex how can i convert it to decimal.
There is a function learn.microsoft.com/en-us/power-platform/power-fx/reference/function-hexdec
Nice one!
Thanks for another useful video!
My pleasure!
How about a video on Getting Started with Powerapps Framework ?
Would it also work with an integrated scanner. I have a Zebra TC26 and wana use the integrated scanner.
Yes. We built similar for a customer a couple years ago.
@@ShanesCows I have a follow-up question regarding the integrated scanner (Zebra TC20 - Android-based scanner). Should we be creating an app using the above approach or use the Barcode Scanner for mobile devices? I can install Power Apps from Google Store on the Zebra TC20 device.
BARCODES ROCK!! 🥳
They do :)
Thanks for the Video! I'm new on Power Apps and this videos are helping me a lot.. I have a quick question. How about if you want to also add an item to a sharepoint list on top of showing the collection on the gallery? . I don't want my users to press a submit button or anything. the workflow would be we scan the QR Code it shows on the screen but also creates a new Item on sharepoint
Try putting a patch in OnChange and see if that gets you what you want.
Trying to figure out how I can use this at school. I want to create an app where when I scan the student ID, it will show me the time the ID was scanned, the student's picture (which is in a SharePoint list) and also assign a random seat number between 1 through 60 that refreshes at 8 am the next day. I have looked at various barcode scanner app and can't figure out a way to combine them.
Hello do u have any idea how we can use power apps ...for opening excel sheet from share point if we scan qr code or bar code...if yes could you please send procedure step by step
Hi Shane, can make a video about creating pdf with barcode or print document with barcode? Highly appriciated. Best Nuin
Btw, great video as always 😀
Great suggestion!
Thanks Shane; great as usual.
Glad you enjoyed it
Hi Shane, this video was just what i looked for!
I have a weird experience with this though, when I try to scan as fast as I can it can break the scanning, so some barcodes only shows up with half the numbers, and some are left empty.
Have anyone else experienced this?
I have not ran into that :(
@@ShanesCows Alright, I must investigate further then. Thanks for the reply!
Hey Shane, great content. I wonder if you have the video of the app you created to for inventory. I want to check a barcode serial number against a sharepoint list.
Quick Thursday tip idea: sending auto emails pending on the status of a column in a SharePoint list. To only send when that item is changed not the whole item - pending email 1 closed email 2 etc
Idea for future videos:
create barcode/ qr codes in your app to scan or store them as picture in your database.
Great content as usual, Shane; thanks for sharing!
You’re welcome Manny. 😎
Dude can you tell me how you put the lateral bar?
I think you are talking about the blue line in the gallery? That is a rectangle set to 1 Pixel tall and ___ pixels wide based on wide you need it.
well, I have a requirement in which I have to scan the barcodes from a Barcode Device.. (it could be Wireless, how will I be able to connect it with) PowerApps..???
Hi Shane,
I like the way we quick scan items here, quickly building a list. I'm trying to find a way to extract this list and save the data in a CSV or a sharepoint. I'm experimenting with your video of copying a record and making multiple copies once moved into a second gallery.. Maybe that gallery could be tied to the cloud since the first is tied to ColScans Text Input.
Any help would be appreciated if you got some ideas.
As you scan stuff put it into a collection. Then this video talks about taking your collection and making it a CSV. ua-cam.com/video/imhxy3REgXc/v-deo.html
Hi Shane, Can you use multiple scanners in Power Apps? For example one scanner will add to one collection and the other to a second collection.
Yes, just add more buttons.
Hi Shane, Thanks for the video also I have a request please do a dedicated video on Canvas app like "Wall Mart" where they can sell goods by scanning goods barcode we will get all data relating to the product.
If this video done by you that will be great help for all of us.
Thanks and love in advance❤️❤️
hi how to connect usb to machine to scanner qr codes implemented in powersapps
I would have thoguht it would work the same way as shown in this video.
Has anyone tried this using the component library? The textInput is different as it doesn't have a "DefaultValue" and a "Text" value. It just has TextInput.Value. It wants to collect the values at each keypress.
Hi Shane,
On the beginning I would like to thank you for your last tip :) You saved my day.
I have another problem and I believe you can help. I have created Sharepoint form in Power Apps. I have question in the form and possible answers are 1,0,N/A. Is it possible to display only "Yes", "No", "N/A" instead of 1,0,N/A. So for example when I select "Yes" and submit form I can see on sharepoint list 1. I'm trying to migrate form from infopath when it was set up somehow.
Thank you.
Regards,
Pawel
Did you configure scanner itself to press enter after the scan is performed? I made exactly same as you video but in order to get data into collection i have to hit enter or mouse press somewhere out of textinput
Same problem here... Did you find a solution?
Yes. I bought zebra mc30x series scanner and you can configure datawedge to auto send enter key after each scan
hi Shane, great video really. We have document scanners at the office and We have a whole bunch of documents to scan and digitize them i.e kind of after scanning tag them or index them. Can you do any video on that or can power apps handle that? That be able to recognize the scanners and scan the dos into a list, then tag them or index them for later search and enquiries etc. can power apps handle that?
Rowland not exactly but I would check out something like this ua-cam.com/video/ogFz7BbLfvc/v-deo.html In the video I take pictures with camera, you could use your scanner to create the images and then feed them into the system.
It’s helpful, please could you help me to specify the type of barcode data like Y010210. Thanks in advance.
Hi Shane did powerapps ever fix the autoscan feature? I'd like to be able to scan multiple barcodes.
I don't think anything has changed but I haven't looked too hard either.
Hey. What about if customer wants a wireless scanner and can't use phones. How could this work with powerapps?
Connect it to The pc and you are good. Bluetooth maybe?
Thinking about you Shane Young.
I went to restaurant. Using QR scanner. To scan it. Appear menu. I can menu to order food.
I would like to know.
How is it work for Power App.
Do simple exercise for Power App.
1. Create simple Galary for Menu
2. Create QR barcode.
3. Scanner it will appear a list of food.
Look forward to seeing. How you do it.
Thanks.
Toan
you are the bessssst , you just saved me a lot of time to do my project
Awesome.
@@ShanesCows but I am still having issues to patch the collection into a sharepoint list , can you please refer me a video for that pleaaase
@@nadiarahel5136 Try this video on saving data two different ways back to SharePoint. ua-cam.com/video/MclJ_O9HvJQ/v-deo.html
@@ShanesCows checking it now , thank you so much
bro , some time we need to get scanning one barcode and this barcode having not only one information ,,, some time 3 some time 4 and so on ,,, but question is how we after scanning this code we distributed the information that comes from the code to deferent field properly because it only on barcode containing multiple information , like the name , phone number , age , other ,,, this is my question?
Hi, Shane, I'm trying to find a way to do this in a model-driven app on a form. I know I can add the business card reader but the barcode scanner is a bit more tricky to find?
I have never tried this with Model-Driven so I am no help. Sorry.
I figured it out. It’s in the old design under field property controls.
hi Shane thanks for yours videos, I have this need currently : I need to scan a serial number and confirm if this exist on a list (list by trailer), using a movil, do you have something similar I can use to learn whow to scan and compare ?
Combine what you learned in this video with what I do in this video. ua-cam.com/video/-JLgj9l25ok/v-deo.html YOu will do a Lookup against your data source based on the input of the scanner.
This video might help also ua-cam.com/video/kWUvttbYpu4/v-deo.html
Hey Shane is it possible to do a similar operation with a desktop (flatbed) scanner?
I would use the flatbed scanner to create a PDF or Image and then feed it to the AI like shown here. ua-cam.com/video/ogFz7BbLfvc/v-deo.html
nice tutorial, but strange why by me barcode collects to collection only when i click somewhere else in app. OnChange is not working. Do all as in video.
Hi Shane, Great tutorial.
Do you have a way around hiding the pop-up keyboard when using an 'input text box' while using a mobile device and not PC? Cheers, Alex
Not that I know of. :( Someone else asked about this and we had no good anwer.
They should just add the ability to put false there so that it won't pop up. Maybe that works now but if not that would be an easy fix for them to implement I would think.
Is there an option for barcode scan in portals?
Not that I know of.
Hi Shane. Great video! Can we use the camera to scan barcodes or qr codes?
This video talks about scanning on mobile via the camera. ua-cam.com/video/kWUvttbYpu4/v-deo.html
@@ShanesCows Thank you!
Thanks Shane. This was fun to watch. Not sure how I can convenience my IT Staff. Do you have any ideas on a app that I can showcase in Hackathon project in my office. I Will buy you a coffee if that application gets appreciation /or wins prize from my line manager. XOXOXO
Hey Shane,
Quick question on the barcode scanner, will the bar code scanner be functioning same even if we use a wireless bluetooth barcode scanner.
Thanks in advance.
I would assume yes Pavan but I haven't tested one.
@@ShanesCows Thanks for the reply 🙂
did it work? I have the same question@@pavankumar-sm9kh
How did you connect the scanner to the PA text control?
You don’t have to. The scanner is just a keyboard so it just works. 😎
the input field removes special character GS before 17:
]d201041500443285402109213256249361 1725033110202777A
how do I fix this
Sorry, I am not sure.
Hey Shane, I’m using a Zebra TC52 and building an app for checking in and inventory management. Zebra’s DataWedge utility has an intent output feature to send/broadcast the captured barcode programmatically. Is there a feature in Powerapps to utilize this?
I want to ensure the barcode input goes to a specific field, which may not happen when it’s set as a keyboard output.
TIA.
I personally do not know, but you could utilize variable as a proxy and then use OnChange to detect if the input is valid for what was scanned, else it would change your focus to be wherever necessary based on the needs for your app. There are formulas to detect how long a string is. Hope this helps!
First thing I always do before watching is like the video.
Thanks. I'm frustated because of this today and again you save me. Lol. 😂 one down..However i need to validate the value in my datasource. But i dont know how..
Use the lookup function. I will do a video sooner than later showing exactly this. :)
Oh wow. Thanks in advance. Waiting for this😁
Hi its me again.😅 I add another textinput in my app now, my prob is why do i need to top my screen to collect the item and setfocus. Can u help me please , Our company use zebra tc56 scanner.
Onchange = Collect(colscan,Lookup(Bundles,item.Text=itemscan.Text,pieces));Reset(Self);Setfocus(Self)
hi Shane, great video as always!
just couple of questions,
① i test it with my scanner(not the one in your video);
it didn't quit the editing current item automatically , for example , if Barcode A=123,Barcode B =456,if i scan them continuously , the text turns out to be 123456, rather than item1=123; item2=456
it just won't quit editing
i have to click the finish button on the screen(BTW it just come out nowhere , i didn't put it on my screen)
② the setfocus function seems to fail in my app, I have to click the input control manually, i don't know how to fix it...
just adding some comments about my question2:
i set the "SETFOCUS" on the screen's onvisible ,but it fails ,
but if i add a button , set its onselect to be "SETFOCUS", it works;
finally, i find if the app just have a screen ,it seems this screen's onvisible does not work very correctly
but if add another screenB above the original screenA, once navigate to screenA , then this time ,its ONVISIBLE works correctly
do you know about this?
Hi,
If you read the scanner's manual, you may find you can add a 'Suffix' to the end of the data that is read. If you set this to a carriage return character it will act as if you pressed [Enter] on the keyboard. Many scanner manuals offer a barcode to do this as it is such a common requirement.
Good luck!
@@clare5967 Hello Clare, did you get it to work? I have the same issue. I tried what you said with the button but no luck.
@@SwadDashcam Hi Swad, can you expand on this explanation? I have contacted my scanner device support team to get help. But I wanted to know if this is something I can configure myself from my device? thank you in advance!
Following up on this. For my scanner, in the settings, under 'Key Stroke', 'Basic Data formatting', I checked 'Send ENTER Key'; now when I scan it not only takes the data but it acts as an ENTER button triggering the OnChange and executing the function every time I scan.
Hello there.. can the scanner work with a tablet? Amazon fire tablet
We’ve used Bluetooth scanners to be able to scan barcodes into an iPad, that might work for you as well. Just like Shane said, it functions just like adding another keyboard.
I like the blue tooth idea. 😎
@@BegeNCSU i use a bluetooth scanner to scan barcode on my android Smartphone. caracters are not correct . 59534105 = %(%#$!)% any idea ?
Wow!!
🤩
Anybody ever use a Zebra scanner in a PowerApp?