Answered

How to export filtered data verse table from power app to excel using automate?

(0) Share

Report

Posted on by MG-08080656-0

Hello All,
I have never worked on Dataverse table in power app before,
I have a dataverse table coming from snowflake/data flow table using power query.
How will i export the table in excel using powrer automate?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

hey

your topic would be a better fit in the power automate section of this forum to be found here:

Microsoft Power Platform Community Forum Thread

cheers

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi MG-08080656-0,

Assuming you wish to export filtered data from Power Apps by clicking a button and using Power Automate.

Here are the steps:

1. Add a button on the screen with the following code to create a JSON variable with all the dataverse table data

Set( varJSON, JSON( ShowColumns( YourDVTable, 'title', 'department' //add more columns ), JSONFormat.IndentFour ) )

2. Create a flow as suggested in this Article by Matthew Devaney: https://www.matthewdevaney.com/power-apps-export-to-excel-as-a-csv-file/

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report

Hi mmbr1606 and MG-08080656-0,

I would suggest not marking a generic statement (not related to the issue itself) as a verified answer on the forum.
I have encountered similar situations before and I feel its not right to do that.

Kind regards,

Nandit

Was this reply helpful? Yes No