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
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.
@@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?
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.
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.
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?
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?
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?
@@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 :)
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.
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.
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.
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
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.
@@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?
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?
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.
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.
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.
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.
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.
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?
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
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?
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
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
@@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?