Announcements
HI all,
I am new into Power Apps. I was creating a Barcode scanner app in MS Power Apps. I am using two dropdown fields and the barcode scanner object. And all is working fine. The only problem. How to transfer the data using a button to a excel file which is save on onedrive. Is there a step by step tutorial?
Thank you very much
Hi @Daydreamer
The easiest way to do this is to use Power Automate. Use the Barcodes collection:
Barcodes – Output property that contains a table of the barcodes scanned with two columns: Value, and Type. Value is the text value of the code that was scanned, while Type is the type of the code that was scanned.
Send the Barcodes to Power Automate and this via Power Automate you save the records to your file.
-----------------------PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
@Daydreamer
You can call the Collect function to copy the contents of a collection to an Excel datasource.
The syntax would look like this:
Collect(YourExcelDataSource, colYourLocalCollection)
https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 352 Super User 2026 Season 2
M Bilal Khan 323
Mohsin Ali 226
