Export to Excel

(0) Share

Report

Posted on by VamsiP

Hello!

I want to export gallery data in my PowerApps to Excel using Powe Automate flow. My data source is Dataverse table.

Can anyone help me how to do the same.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

Hi @VamsiP

Natively you can export the data, without using Power Automate,

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
VamsiP 5 on at

Like (0)

Report
Copy link

Link copied!

I have data connected to gallery and user can apply filters to the data. The filtered data should export to excel. To do this is there any way other than using Power Automate.

Was this reply helpful? Yes No
Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

Hi @VamsiP

There is no way to export that data to Excel directly from a gallery. One of the reasons is that this data is not being stored anywhere, neither in Excel nor in Dataverse, so you must use Power Automate to create the Excel and be able to export the data.

This article describes it quite well on how to do it.

https://www.matthewdevaney.com/power-apps-export-to-excel-as-a-csv-file/

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @VamsiP ,

Please try:

1\Formatting the Gallery.AllItems table(The JSON function do no support table column or object type column)

2\Using the JSON function to format the table in to JSON string format.

3\Passing the JSON string to flow

4\Parsing the JSON string

5\Converting the table in to a CSV table

6\Creating a CSV file

I think this link will help you a lot(About how to format the Gallery.AllItems table and how to passing the table to flow):

Re: Need to send a single email if multiple rows a... - Power Platform Community (microsoft.com)

If you want to export excel directly in a canvas app, then you can consider using this PCF.

https://pcf.gallery/export-to-excel/

Best Regards,

Bof

Was this reply helpful? Yes No