Power Apps Barcode Scanner For Inventory Records
Vložit
- čas přidán 25. 07. 2024
- In this tutorial I show how to use the Power Apps Barcode Scanning functionality for inventory item interaction. If you need Power Apps help, feel free to reach out here.
solvedsystems.com/pages/contact
What a great video, Jeff! It’s amazing how easy this is to implement. Thank you for producing and sharing!
Thank you for the compliment.
You are awesome how soft and smartly teaching I like it
This is an awesome video! Going to checkout your other videos.
Thank you for the kind words. Let me know if you need and development for your organization on the Microsoft stack.
Thank you for sharing this video. It was a great help on my creation of barcode scanner.
The only annoying thing is after submitting the entry, the app comes back with the "Getting Your Data" message. I tried using the ResetForm and NewForm in addition to the SubmitForm cmds and it doesn't fix the problem.
Great help thank you. Can you assist or share a video. I want to manage inventory with scanning the QR code. So when you scan, the information from the data (list sheet) needs to be pulled, a QTY needs to be added (what I received) and then submitted to a column on the list sheet. I am new and getting a bit stuck.
i swear people from Houston Texas have to mention that they are from Houston Texas haha. No but serious, good and quick video that helps a lot! Thanks
Louisiana, but now a proud Houstonian / Texan. Glad it helped.
@@SolvedSystems i just wonder now, how do you input multiple data sources? Like the "Form" isnt loading in again. I have to exit out of the app and only after entering it works again. Do you have a solution for this?
Thanks by your lesson.
Welcome
I followed your steps to the letter, but when trying to use the app on my Android phone, it states that there was a problem saving your changes, the data source may be invalid. any ideas?
Tempted to try. I have my app built and can edit and save but if scanning it would be scan a desk then scan a pc. One after the other 500 times. Might get messy with app. At present we scan and auto adds to excel. Then I can save that to my app
Hi question about your inventory test app. After applying the QR code, is it possible to add a calculated column for inventory quantity changes made my users? Great video!
Yes you could have a calculated column. You could also have the QR Code Scan, filter out that inventory Item, and add a parameter to add or subtract that inventory item on submission.
If you need consulting help for this, my new website is about to launch. You can go through this form if you need more help
www.solvedsystems.com
It's an impressive video. I have a quick question. Would it be possible to scan multiple items at a time and submit the data?
Yes you can, you would have to add each item to a collection, then patch all the data to the data source
Thank you! It helped a lot. I need your help in another thing. I want to scan the QR Code (that is an employee ID) and the app shows all the trainings that this employee have (like a filter of information). Could you help me please?
Amanda Justus send me an email at jeff@solvedsystems.com
Send a screenshot to jeff@solvedsystems.com
Question, I made a inventory app. I can add inventory but haven’t figured out how to remove inventory. Any help is appreciated. Thanks
On the gallery add an icon for a trash can or whatever icon or button you want. On the button user remove()
great content! was there a video for the power app barcode scanner using a webcam?
The webcam is no longer supported.
Hi, I would like to do a barcode scanner with BIN so can log barcode stored on different BIN locations
that can be done. I would have to hear more about it, to understand how to answer your question.
Amazing tutorial! Got this to work for our inventory system, however as of now after each submission we need to close and re-open the app. Ideally, after submitting the form would reload empty. How can we achieven this?
ResetForm(nameofyourform)
@@SolvedSystems Thanks! It works for the simulation now. Somehow on the phone it gets stuck on getting your data after I have submitted. Not sure if you have a ready to fire answer, but I'll be looking into this :)
Thank you !, how can Click submit, then go to new record?
In the on select property use submit(formname), Reset(Formname), then go to the next action
Please make a video for an application. Where I can scan barcode and it should be reflected in computer in word, Excel, or at any place. And mobile need to be connected to pc by bluetooth
nice video. it is possible to check barcode and add the date (actual date) of control and note? For year to year stock inventory, where will be column " last control date" ?thank you for your help
You could utilize a sharepoint supplied column called modified. When you update the record, this would show the last update. You can also add a text field for notes when you edit or submit a barcode.
@@SolvedSystems thank you . it is posiible to work with excel sheet on onedrive?
@@michalkrenek6659 in my experience using excel as a data source is very unreliable unfortunately. I would use SharePoint or build a SQL database
Hi, the fomula at 3:15 throws out an error, is it because this video is 3 years old and there have been updates?
Nice. Very helpful!
Can you help me on this, I need to scan a barcode and it will need to present all the listed items on the SharePoint List on the next screen in PowerApps as a report style.
Set a gallery to be filtered with the output or the barcode scan.
@@SolvedSystems Thank you! I will try this.
How did you emulate your own ihpone on your computer, any software that can be used for this?
Reflector app for iOS is what I use
Can you do a video with usernames, barcodes, date created etc great video btw!
Thanks for the idea!
Question - with your video, I was able to create a beautiful barcode scanning app; however, when I try to submit it to the Sharepoint List, I receive the errorTitel: Field Title is required. Your video indicates we don't need Field Title. Has this changed, and if we now need Title, how do I add it into my PowerApp since it's already complete. Thanks in advance.
Go to the sharepoint list > list setting > title label for that data field > uncheck required.
@@SolvedSystems Thanks. I will be making several entries, how do I get the previously scanned barcode number to clear/reset when I press the Scan button a second, third, fourth, etc time?
@@bethquickel8783 on each submit collect the entry and then clear(myinputfieldname) or reset(myinputfieldname)
Great video, thanks a lot. it works for me issue free. However when I share the app with a colleague as "Co-Owner" he is able to scan but when he submits he gets an error message: " Connection not configured for this data source". While he's able to go to that sharepoint List and manually add records to it. Any ideas?
How about retrieving records that already exist. Every barcode video I watch shows how to push data but nothing on fetching data. Being able to scan some from the field and look at data attached to that barcode in a form would be great.
You can use an input field and tie this to a gallery. When you scan the barcode, the value populates in the input field, filtering the gallery for your desired record with the barcode value.
great video!, is it posible to submit de data in one excel ? to submit new data to this excel?
Yes, of course but I would advise against using excel.
Is it possible to do barcode scanner lookup if so, how? :)
Yes. Setup a gallery connected to a data source with barcode values. Add a text input. Add the ‘name of your barcode control’ into the text field on the text input. Finally, filter the gallery with the text input control.
Can you add a feature to this so you can update inventory numbers after the product has been scanned?
Yes that could be added.
Some Barcodes have additional characters that I dont need. Is it possible to remove the last few characters while scanning? If so how? Thank you!
If all of your barcodes have a constant number of digits, you can trim the capture in to the number of digits that you want.
@@SolvedSystems thank you! If it’s not hard to explain, how can I trim the capture?
@solvedsystems i have a Similar issue. I need to remove the first and last digit. Is this possible while scanning?
Thanks, QUESTION - I have it all set and connected to SharePoint and have drop downs in the form connected etc..
I am using for our equipment inventory and some of the trailers do not have a barcode to scan so I need the field to accept text OR the barcodescanner2 data on submit.
Assistance is appreciated!!!!
Rick B. Use single text value in sharepoint. This should catch any combination of data. You should be able to use the barcode scanner as qr scanner as well. The data capture is the same.
@@SolvedSystems In the app is where my issue is :) When I manually enter the data and hit submit I get the error - An entry is required or has an invalid value. Please correct and try again.
Rick B. In your sharepoint list, check that the title field required is unchecked. By default Sharepoint lists have a title column that is required that typically causes this issue
@@SolvedSystems I used a new field for the bar-code scan results to go into and all other scans have been successful. Only manual entry causes the error. Do I need to change either the default value on the field that I have set to default to the barcodescanner2 to an if statement or something? or the Submit button needs a different code? I have over 30 successful scans with drop downs in my form that go into the SharePoint, etc.
(Also the title field is set to not required :) )
Its very helpful video but can you help me on how to scan a barcode and automatically fill the other text box information.
Put “BarcodeScanner1” into the Text function of the text box.
Its really great video but I'm new for power app
That's great. Watch as many youtube videos, on power apps and you will be a pro in no time!
Do you have system for web cameras to monitor inventory on shelves and trigger re order before stock out?
Yes, one could be built with Azure ML studio.
If you want us to build this, reach out here for a consultation.
Jeff@solvedsystems.com
Thanks Jeff@@SolvedSystems
Can the barcode scanning feature scan multiple items at once, or just one at a time?
Jordan Eddy you could have it collect the scan, then reset itself after collection, then scan another and repeat that until you’ve collected your barcodes.
@@SolvedSystems Could you do a tutorial on this? Can't figure out how to accomplish this.
@@anthonybauman7249 Yes I can. Stay tuned. Also, if you need power apps dev work, give me a shout at jeff@solvedsystems.com
Come in 4 years later! I've been trying to figure out how to set stuff like this up for weeks now
If I have techs around the country, and need the inventory sorted by location, how could I do that?
You could give add a location field in your database. This would allow location filtering.
@@SolvedSystems I've been trying to make this work with forms for 3 weeks. I think this is my answer!
Nice, can i store the data in onedrive instead of SharePoint?
I’m sure you could, potentially in excel, but excel doesn’t work well with power apps in my experience.
Can you do the video on barcode scanner on the Web? Can use QR code with PowerApp?
The web is the same idea. It you open the app and have a camera connected it will use that camera. Also, the barcode scanner can read qr codes
Hello I would like to send two forms at the same time and I do not know the formula .. can you help me
Please see video description for contact info. If your project has a budget please feel free to reach out.
very interesting, could it be done with qr codes?
Absolutely
Awesome tutorial. I followed step by step and when I scan it asks for the title column to be identified?
Go into settings in the SharePoint list, uncheck required on the title column, refresh your data connection. SharePoint list, by default, make the title column required. You can choose to use and rename it or just uncheck required. I typically uncheck required and do not use the title column.
What if you want to edit that scanned number?
You can set the field to new and change the values
Hi, can the app read QR code also?
I have not used the QR code scanner, but I know it’s possible. Here is some documentation on QR code implementation. medium.com/@jenzushsu/building-contact-tracing-check-in-canvas-app-using-power-apps-5b273956de33
Is it possible to do this with an actual barcode scanner instead of on my mobile?
There might be a peripheral input for a barcode scanner. I'm not sure of it though. The point of the phone scanner is to build the app for workers, deploy to them so you don't have to manage a scanner.
@@SolvedSystems Thanks for the quick response!
iOT pls video needed yeah
Hi - I am getting a "data source is invalid" error when i use the app on my android phone once i click on submit.
If your data source is a Sharepoint list, firstly make sure the "title" column required value is unchecked. This is a common error. After you uncheck required, refresh the datasource in power apps and try submitting again.
@@SolvedSystems I made the changes - still same error. Also not able to view the Datafield and Display - Only the buttons are visible - sorry - just new to all this....
found a solution: Essentially you need to select the form on the sheet, and you will see that when selecting 'Item' the functions bar is blank, therefore it displays nothing in preview!
Simply change to: Item = Defaults('list name')
'list name' should refer to whatever SharePoint list you are pulling your data from
- just googled it to find a MS solution) - is it possible to clear the data after submitting by default?
@@j.capgemini83 Yes, in the "OnSuccess" Property in the advanced settings on the form use "ResetForm(YourFormName)" . Once the form submits data, the form will be reset.
@@SolvedSystems So here is another dilemma which you can guide me - As an owner - i am able to scan and record the entries to a Sharepoint List. I have added some members as co-owners on the power app. and also provided access for them to read and write to the sharepoint list. The app on their end - post submitting - the 3 floating dots are visible on top - but nothing happens. Any ideas?
Com o qrcode procurar registos na lista sharepoint????? Can you Helô
Can you Help with barcode search item in sharepoint list
Yes the we code would need to be made for the information you are looking up. Ext. QR code transcribed 1234, make the column text for the QR code values. Set Search input value to onscan
Не работает, когда BarcodeScanner отмечаешь, начинает выдавать ошибку "Ожидалось значение Text
"
CZcams didn’t translate this. If you can respond in English, I can answer your question
how about QR code?
We code would work the same. Use a qr instead of a barcode.
Hello
I get an error message Error: A value must be provided clientRequestId. i want to save to one drive excel .xlsx, test item in a columnar table. THX Barna
Are you submitting or patching to your excel?
@@SolvedSystemsHello, patching!
Barna Kovács can you copy paste your patch formula here?
@@SolvedSystemsof course "Patch('Keszlet.tabla', {Raklap: BarcodeScanner1})"
@@barnakovacs2339 Are you creating a new record with the barcode value attached or are you updating a record and looking up the record initially with the barcode value?