Thank you for the compliment.

Thank you for the kind words. Let me know if you need and development for your organization on the Microsoft stack.

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.

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?

Welcome

Yes you can, you would have to add each item to a collection, then patch all the data to the data source

The webcam is no longer supported.

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

that can be done. I would have to hear more about it, to understand how to answer your question.

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!

Reflector app for iOS is what I use

In the on select property use submit(formname), Reset(Formname), then go to the next action

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 :)

Amanda Justus send me an email at jeff@solvedsystems.com

Send a screenshot to jeff@solvedsystems.com

On the gallery add an icon for a trash can or whatever icon or button you want. On the button user remove()

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

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

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!

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 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)

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 :) )

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

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?

Set a gallery to be filtered with the output or the barcode scan.

@@SolvedSystems Thank you! I will try this.

Please see video description for contact info. If your project has a budget please feel free to reach out.

I’m sure you could, potentially in excel, but excel doesn’t work well with power apps in my experience.

Yes that could be added.

You can set the field to new and change the values

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.

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.

Thanks for the idea!

Yes, of course but I would advise against using excel.

That's great. Watch as many youtube videos, on power apps and you will be a pro in no time!

KZfaq didn’t translate this. If you can respond in English, I can answer your question

Put “BarcodeScanner1” into the Text function of the text box.

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

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

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

Absolutely

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?

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?

We code would work the same. Use a qr instead of a barcode.