Export large data in Canvas App

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All ,

My data source has 7K records and we are showing all these records in Gallery .

As per client requirement we need to export this data to CSV from gallery .What is the best way to do this.

Currently we are following below code to achieve this functionality but due to huge data browser is getting stuck

Download(Exportdatatoexcel_Dev.Run(JSON(Export_Collection,JSONFormat.IncludeBinaryData)).csv_link)

Please advise on this .

Regards,

Mahesh

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @Anonymous
Large data set means PowerApps little hang. If you need without any struggle you may do additional steps... You can Export excel thru Power Automate..

Refer https://youtu.be/tQCBWMR7T64 Youtube video for more information

Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AsanKani

Or export directly from the data source. That would be quickest if available.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@AsanKani ,

Currently we are following the same process to export the data calling power automate from powerapp's button by passing Collection(JSON) as parameter.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp Business user's will not agree for this approach

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I email the file back to the user - just send User().Email as an additional parameter in the Flow and email from there.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thanks for the reply ,We have considered that is also one of the option .
But MS flow it self is not trigerring

Regards,
Mahesh

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

This may seem old school, but I do not use JSON - just Concat with commas and Char(10) - always seems to work although I have not sent anything quite that big. Flow is below - I hope it helps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thanks for the advise .
I have implemented above approach but we are getting another Issue . One of the column contains Rich Text where user provided text with "," .
This is causing the problems in export to excel file .

Request your advise on the above use case.

Regards,
Mahesh

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just use Substitute on the field and put something else (as space) in there. I do this as standard on CSV files that contain any free-form text.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No