Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Power Automate export to Excel

I have a Power BI Matrix visual setup to present a data table. This will show all the information available however might not show any information in a given cell if there is nothing to show.


When I setup Power Automate to export this to excel it will only export the rows of data that have data in each of the columns. For example:


Name    Qty

A            1

B            2


D            4


What I'm finding is the output is:


Name    Qty

A            1

B            2

D            4


Notice that Row C is missing as it didn't have any data in the Qty column.


Below is an example of the flow I'm using:


Screenshot 2021-06-11 142042.png


Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,105)