Export to Excel Feature

(0) Share

Report

Posted on by PM-06010842-0

I am building a Power Apps Canvas App connected to a SharePoint list.

In the app, users can filter data using comboboxes.

I want to add an “Export to Excel” button so that:

Only the data matching the user’s search/filter is exported
The output is an Excel (.xlsx) file or (.csv) file.
The file contains actual rows (not just headers)

My current design is:

Power Apps button triggers a Power Automate flow
The flow reads data from the SharePoint list
The flow creates an Excel file with the filtered data

The issue I am facing:

The flow runs successfully
The Excel file is created
But no data rows are written (only headers), or filtering does not apply when triggered from Power Apps

I am looking for:

A recommended and reliable pattern to export filtered SharePoint data to Excel from Power Apps or maybe a flow to export data from gallery in power apps to excel.
Best practices on where filtering logic should live (Power Apps vs Power Automate)
Confirmation of whether this scenario is fully supported and how it should be implemented correctly.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

RobElliott 10,428 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

We do this for many apps at my company with a PCF component built several years ago by Yash Agarwal and available from github at https://github.com/yashag2255/exportToExcel

There is a video from April Dunnam at https://www.youtube.com/watch?v=xqUBFJfNvyM which explains how to install it.

One of the good things about this component is that it respects filtering and only the filtered records are exported to the CSV file.

Clicking the Export button launches a flow. The OnSelect for this example:

The flow looks like this:

It all works very well, but one of the minor irritations is that you can't specify the order of the columns in the exported spreadsheet, it puts them into alphabetical order and I've never found a way round that.

Rob
Los Gallardos
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

PowerDeveloperTP 442 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Please check this blog for detailed export to excel functionality from PowerApps. Hope this helps. Thank you.

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

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @PowerDeveloperTP if you still have any queries related to the solution or issue persists.

1 people found this reply helpful.

Was this reply helpful? Yes No