Scan and Store Barcodes in Sharepoint using PowerApps!

[@hughmurfitt]

Excellent video, Henry. Your work has saved me a huge amount of time (in terms of research I now don't have to do). Thank you so much

[@henryouang]

I'm glad I saved you more time for you to spend doing other productive activities! That is my goal. Stay tuned for more helpful tutorials! Thank you!

[@777tonahttiu777]

Thank you for the info, tried it several times but it will not work for me. Item: BarcodeReader2.Value, WhoScanned: User().FullName, Time: Now()}) Always gives me an error message saying Value is not accepted. Any suggestions?

[@ajingar]

I think the API has changed now.

[@jeffreymenezes6493]

Hi Henry, The formula that you use in this video (5:58) does not seem to work for me, could this be because this video was made 3 years ago and updates to the sofware has been made??

[@nofam]

Great video Henry! It's been super-helpful!!!

[@reinierstoltz7176]

Thank you, saved me lot of time.

[@msoit8594]

Nice one!! Excellent video, worked straight away.

[@wernergouws2744]

This is awesome, will it be possible to add text and lookup column fields in this app to push to a SP list?

[@Porknan]

Thanks - what should the datatype be for the barcode field in the share point list?

[@tomtebodakoloni3228]

Hi Henry, I recently watched your video on how to scan and store barcodes in SharePoint using Power Apps. I found it to be very informative and helpful, so I wanted to take a moment to express my gratitude for your efforts in creating such a valuable resource. I have a specific question regarding an existing SharePoint list. Suppose I have a list that is already populated with data, but it lacks a barcode and a running number. I would like to add these two fields to the list, with the running number serving as the barcode. Could you please provide some guidance on how to accomplish this? Thank you once again for your insightful video. I look forward to your response. Best regards

[@paulskingley]

great video. thanks. one question ... is there a way to capture a signature in powerapps and save to the sharepoint list?

[@simonea.4189]

Thanks for the video. I did exactly as you did, but I always get the "unexpected characters" error. I think I have set the columns in sharepoint well. I paste you the code: Patch ('DPI Tracking', {Item: BarcodeScanner1.Value, Technician: User (). FullName, Data: Now ()}) It highlights the parentheses after "Patch" and "{" as an error. thank you so much!!

[@قناةالباحث-ه2س]

Patch('Final'; {Item: BarcodeScanner1.Value; Tecnico: User().FullName; Data: Now()})

[@Lineage2Ragnarok]

Is this the only way to set the product name to automatic?

[@SA-kt3wt]

Really helpful thank you One query I have is I want to put the barcode number from the scan into a form first (as I have other data I fields that are associated with the barcode I want the user to input). I did it once successfully so the table was barcode / then data along one row. But then I must have deleted something as it no longer works. I set the default text in the data card to the barcode scanner which works (it populates on each scan) but is not pulling through to table now. Bit confused!

[@colby4390]

I have a Microsoft Form that our service guys are using for auditing a bunch of equipment inside buildings. They use the form to upload a photo of a barcode to a sharepoint list. Can a power app load that barcode image from the sharepoint list then read it with the barcode scanner?

[@astonish1109]

Any tutorials on multiple barcode scanner?

[@milig.8106]

How can we make the barcode scanner to scan an electric meter serial number? It just didn’t work for the serial number n that’s I needed

[@netherlandsinternationalsc8050]

Hi Henry, thank you for this tutorial. I followed exactly the code but I am getting error message (The barcode scanner is not configured to scan a valid barcode type) on the app when I click on the scan button on the phone. Please help.

[@dr.mohammedmohammed7633]

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?

[@hunganh1396]

Thank you! I have a question: "How do I use real barcode scanner with powerapps"

[@fabianmaes1448]

Hi, Is it possible to use a real barcodescanner instead of the phone?

[@Imakemvps]

If I wanted to create a powerapp barcode scanner for housekeeping employees with buttons on a mobile app. For example each place they clean can log in a sharepoint list who cleaned, when, and any comments and tracked through powerBI? Anyone know where I can find this?

[@SissasHeART]

Thank you - you make it look easy, can't wait to try it. I was wondering - how would you do this is you wanted to keep a couple of constant data pieces and then a list. To help illustrate - I'd want to scan an SOP QC Code, a Trainer (both of those are static) - then each person that attends the training - they would have a QC code on their badges. I would love to hear your solution ideas for that!

[@danzukielyzu273]

When I enter the formula I get an error that says "The specified column "Item" does not exist. The Column with the most Similar name is 'ID'" any clue what I'm doing wrong?

[@warehousetechie6428]

Do u know of a way to generate a barcode with PowerApps

[@henryouang]

I would use a free barcode generator's API and link it all together with an HTMLText field. I'll make a video about it soon.

[@Meurre001]

Hi, Thanks for the video. Is there any way to do the opposite? I mean, showing/finding a record from a Sharepoint List by scanning a QR code? (giving the QR code the same name as a unique item on that list). Thanks

[@henryouang]

Madriquad no problem! Maybe you could try using a Search function with the scanned item’s value within it. So your function would be searching within a database for the scanned item. You could then take this out and display the values that it results in (hopefully 1 value). Try that, I believe it will work!

[@onatsworld9911]

Hi, Thank you for this video. I applied all of them (exactly same). However, app on the phone says that "Status: Field required" and the list is not updated. What is missing in my app?

[@henryouang]

Kuntay, could you send the code you put in to [e-mail]? Maybe I can find a mistake in it. Alternatively, since you probably entered the information in correctly, maybe you didn’t create the respective fields within Sharepoint?

[@onatsworld9911]

@@henryouang Hi Henry, I just added a new column called Status then the problem is solved !!!

[@hughmurfitt]

Review the default list columns (e.g. "Title") in the List Settings and uncheck the "Required" box. If this is left checked, SharePoint will not allow a record (row) to be created / saved unless the Title field is populated with some data (which it won't be, as Henry's app is not collecting any data for that field). HTH

[@dependentongadgets480]

@@hughmurfitt I tried that, but my phone persists with the error "Title: Field 'Title' is required' - I've tried using the field AND making it 'not required' but no joy :-(

[@huyenduongtran589]

Are you Vietnamese, your voice is so nice!

[@abdullahkamal6502]

you are the besttttttttttt

[@AnneDelosReyes-c8r]

User this Patch('Automated Scan',{Item: BarcodeReader1.Value, Whoscanned: User().FullName, Time: Now()}) not working

[@ajingar]

Yeah, it's not working - I think the API has changed now.

[@shaikha4362]

Thank you so much for this, I did the exact as demonstrated but it shows me the error "Title: Field "Title" is required"

[@MohammadArif1187]

Please check your DB there should be a title field in the table and that title field is required field. So if you don't need that field just delete it or change the field type to unrequired 🙂

[@simonea.4189]

@@MohammadArif1187 Can you please tell me where I find this information? I am going crazy. Thank you

[@raphaeltoye7024]

@@simonea.4189 if its sharepoint, go to your list setting, locate title, uncheck field required, hope this work

[@bennyponet2186]

Super, easy to design a barcode scanner for inventory database, thnx

[@addisutegegn9125]

hoops It doesn't work for me. pls help.it gives me an error( the type of this argument x not much the expected argument "record" found type text. I use the code.Patch('Final',{Item:BarcodeScanner2.Value,Whoscanned:User().FullName,time:Now()}).in share point i use a list with name"final" with columns Item(multi line), who scanned(multi line), and time (date and time)

[@raghadzarei4907]

Any answer to this?

[@simonea.4189]

@@raghadzarei4907 Patch('Final'; {Item: BarcodeScanner1.Value; Tecnico: User().FullName; Data: Now()})

[@قناةالباحث-ه2س]

@@simonea.4189 It's working. Thank you very much!