Here's some general instructions for you to follow:
1. Add the Excel sheet as a datasource in your PowerApp
2. Create the collection you'll eventually upload by putting this code in the OnStart property of the app.
ClearCollect(yourCollection, First(your_excelsheet_name)); Clear(yourCollection);
3. Collect new data while using the app (you have already done this)
4. Put this code in the OnSelect property of a button to upload all collected data
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
First of all, thank you for the prompt response, I am very novice; I tell you how I want the app to answer me, a collection with a series of data, which have several columns, is loaded on a screen with a button, after loading data in a collection, you go to another screen where there is a gallery with the data of the collection itself; and by means of a button I want all that data to be added in an excel file in my onedrive (company), and the formula you gave me, throws me an error, sorry for my English, it is almost null, I am using the google translator.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks