cancel
Showing results for 
Search instead for 
Did you mean: 

Export Collection to local drive as CSV or Excel

If PA can export collection to a local drive in a CSV or Excel format, it would increase relevance of PA to making tools that use only backend data for reference and Collect result based on user choices. User should then be able to save/export Collection to their local drive. This will let multiple users make local copy of their choices simultaneously. eg - I have an app that builds Bill of Material (BOM) based on user choices. If the BOM could be exported to a local drive, the user can share it further without having to provide app and data permissions. Additionally, multiple users simultaneously can chose any features and get their BOM saved locally.

Status: Under Review

Updating status and adding @GregLi

Comments
Level: Power Up

I also need that functionality.

Level: Powered On

Me too! Why is this not already implemented? I believe there are lots of people that want and need this function. Please make this happen! 🙂

Level 8

Any updates on the Exporting collection to CSV in power apps?

 

Thanks,

Prajyot


@ManishM wrote:

If PA can export collection to a local drive in a CSV or Excel format, it would increase relevance of PA to making tools that use only backend data for reference and Collect result based on user choices. User should then be able to save/export Collection to their local drive. This will let multiple users make local copy of their choices simultaneously. eg - I have an app that builds Bill of Material (BOM) based on user choices. If the BOM could be exported to a local drive, the user can share it further without having to provide app and data permissions. Additionally, multiple users simultaneously can chose any features and get their BOM saved locally.



@ManishM wrote:

If PA can export collection to a local drive in a CSV or Excel format, it would increase relevance of PA to making tools that use only backend data for reference and Collect result based on user choices. User should then be able to save/export Collection to their local drive. This will let multiple users make local copy of their choices simultaneously. eg - I have an app that builds Bill of Material (BOM) based on user choices. If the BOM could be exported to a local drive, the user can share it further without having to provide app and data permissions. Additionally, multiple users simultaneously can chose any features and get their BOM saved locally.


 

Microsoft

I am still waiting for this feature. It's been "Under Review" for some time now.

 

I managed to get collection data into Excel but it is a terrifying approach. I do not ever want to do it that way again or recommend to anyone.

 

Basically, I create XML formatted data that I write to a text file but with .XML extension. This file I necessarily have to create in OneDrive because file creation is supported only there. I then download and save the XML file locally and open it in Excel. My Excel needs to have tabs for separate collections but in one file.

 

The terrifying work was to first deconstruct XML how excel would read it especially where separate tabs are needed; and then build that structure within Text field while I read/write 2 levels of data. phewwwww.

 

What I would like this feature to do is allow for table creation for sure but also cell level formula creation from PA.

 

 

Level: Powered On

I am so terribly in need of this feature, if anyone even have a work around, I will be grateful!

Level: Power Up

Any news about it? I need to record some rows and using edit form is not a good experience for the user. Look, a need to input 20 records, using I will need to press 20 times the button to save. If I use a gallery to edit all registers I can press one time the button.

 

 

Level: Powered On

Workaround... Power BI, success here!

 

1 - Use Power BI to create some table/chart from your Powerapps datasource that you need to export.

 

2 - Now include the Power BI as an embedded element back on Powerapps.

 

3 - Then, using the Power BI export data function, you'll be able to export to an CSV/Excel your data.

 

4 - Have fun! 🙂