Export Collection to excel or csv

(1) Share

Report

Posted on by Art_Ratta

154

Dears all

how to export collection to excel or csv. files by using button? and files will be export to local drive.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report

Hi @Art_Ratta - have a look at Export to Excel PCF control by @yashag2255.

However, if your data source is SharePoint list, you could create a flow to export csv/excel file.

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi@Art_Ratta,
Based on the issue that you mentioned, do you want to export the collection to excel or CSV and save this on the local?
Could you please share a bit more about the scenario?
Currently, I am afraid that there is no way to achieve this directly in PowerApps. As I know, we could save the file into a local file with the SaveData function or Export control, but the saved file format is restricted to only be available within PowerApps.
On the other hand, even if you can save the collection into an Excel CSV file through Microsoft Flow integration, there is no way to display/load the data into PowerApps directly.
Here is a similar idea you can vote for:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Export-Collection-to-local-drive-as-CSV-or-Excel/idi-p/68559/page/2#comments
As an alternative solution, you could check the following video to see if it works for you.
https://www.youtube.com/watch?v=imhxy3REgXc
Best Regards,
Qi

Was this reply helpful? Yes No
Art_Ratta 154 on at

Like (0)

Report

@v-qiaqi-msft
Based on the issue that you mentioned, do you want to export the collection to excel or CSV and save this on the local?
Answer : yes need export to local drive and format file (csv or xlsx if possible)

Assume : I have 2 Gallery
Gallery1 : filter data form collection
Gallery2 : Blank Gallery
Scenario
1. Export data from Gallery1 after filter and save to local drive.
2. Import same CSV file to collection and filter display on Gallery2.

Was this reply helpful? Yes No
Art_Ratta 154 on at

Like (0)

Report

it's working.

Was this reply helpful? Yes No
varo2812 19 on at

Like (3)

Report

How did you do it ?

Was this reply helpful? Yes No
sxg185_sherwin 14 on at

Like (0)

Report

Do you have more information on how you solved this please?

If you have an answer for your own question, that's well appreciated because like me, we find this thread from Google and read it to find no solution at the end 😞

Was this reply helpful? Yes No