Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Upload collection to excel file (table)

Good afternoon I am learning to use powerapps and I need help, I have a collection which collects data and arrives at a screen in which I insert a gallery, and the data of a collection is loaded, now my question .. There is a way that those Collection data is uploaded to an excel file in my onedrive (company) ??
Super User III
Super User III


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

Collect(your_excelsheet_name, yourCollection);​ ​


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.


Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (61,537)