Hello there, I hope someone can point me in the right direction:
I would like to make an app that scan a barcode, preferably a QR-Code, then retrieve the stock quantity and product details, so I can have an excel file in my one drive with Product, Description, Quantity, Value, etc.
is this possible?
thanks in advance for any response,
Regards
Hi there, I did that a long time ago, and if I am right the functionality used by that time is no longer supported, but the Powerapps team added more support for this and even now you can scan a QR codes.
This is a preview of my app. Unfortunately I can not share because of company policy but if you get stuck at some point just let me know.
Hello, my name is Randall, it is possible to share your app also with me, I already have an app for stock control, however I want to add the barcode scaner in order to make it easy to use... I have the data in excel tables, so I want to scan the serial number for one item and get all the item information into the editform, then the user just need to enter the quantity and comments to save the new entry.
I don't know how to use the scanned code to retrive the data from the stock table in excel.
My email is randallarce@hotmail.com
Hey @RachelMoore
I'm not sure if you're still looking into this, but I was able to get Sharepoint to automatically generate Code39 barcodes for any new items in a SharePoint list - my reply is within this thread:
https://powerusers.microsoft.com/t5/General-Discussion/Help-With-Barcode-App/m-p/178716#M59188
If you still have any questions about this or want to know how I implemented it please feel free to ask,
Regards,
We are looking for help on a PowerApp for scanning barcodes. I was trying to just use Excel for this but they need something for iPad/Tablet use. They are a moving and storage company. What they need is when onsite at the customers location they will scan the barcodes for the items they are putting on the truck. If they scan something twice they want duplicates removed and the barcodes sorted lowest to smallest number. A total of barcodes scan at the end. Then they bring the items to their warehouse and put them in a room. They want to track the room number with all the items. Then when they are ready to take them out of the warehouse they want to scan the barcodes again and match up what they already had scanned onsite and know if they missed any items. Hope this makes sense.
Right now I have an Excel spreadsheet with macros, control buttons to run the macros, conditional formatting, etc. But of course this won't work with iPads/tablets using Office 365.
Is there anyone that could help us with this? I have not worked with PowerApp before. Thank you so much! JoLynn
OK. A couple of things here.
1. Please consider use Share point list for your data. when I started all my apps were in excel because it was easier, but I had to move one by one to a share point list. it's worth it you'll have fewer problems in the future and if you want integrated microsoft flow it works better too.
So please send me a Private Message with your email address, I will send you a copy of my APP along with a copy of the excel. BTW Can you create barcodes? if not I will send you a link for this website to create barcodes I did it and works witout any issue.
Regards
wow thank you! I so appreciate this!
1. Do you have your data in an excel file in shared in one drive? Yes
2. Your coorworkers will use an iPad or a phone? or a PC We are expecting it to be mobile phone or tablet, either IOS or Android
3. When your coorkers are using the app they have access to wifi all of the time? Yes
I'd love to be able to use this as a base for learning to do more exciting things with the app but at first, if I can get the few things displayed that would be great. In time, it would be brilliant for non identified barcodes to return an error message with the option to take a photo of the item and send it to the administrators so that the item can be added at some point.
But let's not run before I can walk!!
No worries, I will help
1. Do you have your data in an excel file in shared in one drive?
2. Your coworkers will use an iPad or a phone? or a PC
3. When your cookers are using the app they have access to wifi all of the time?
Hi,
That is almost exactly what I want to do.
I need for an inexperienced team member to be able to scan the barcode on a product and have the product description, Part Number, price and picture pull through from a spreadsheet which I will keep offline in a dropbox folder.
However, I have no idea how to create an app and the provider of our IT system are being particularly unhelpful to me!
I've searched long and hard through available apps and while I can find plenty that will point to a web search, I am struggling to find something that does what I need.
I even went as far as downloading Android Studio and a load of other things in an attempt to write something myself. Quickly realised that I have no hope in hell 🙂
This is a completely cheeky question and I totally understand if you tell me to get stuffed but would you consider sharing what you produced with me please? As I said, I know that this is totally cheeky and am fully expecting you to say know but I'm struggling to get this off the ground and I know it would help boost the confidence of newbies at work (not to mention reduce error rates!)
Rachel
Good afternoon.
I am looking to achieve almost exactly the same thing and wondered if you had managed to resolve your issue?
Regards,
Rachel
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
