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 Employee

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!