Forum Discussion
kb177
Helper II
Helper IIExport filtered matrix to Excel using Power automate
Hi, I have 3 matrix tables in seperate pages on my report, I'm looking out to export the same to excel into one workbook into seperate sheets I dont have access to power apps, only power auto...
Oh I see: You have entered the formula into the wrong window. That will indeed just interpret it as text.
Instead, click on "Add dynamic content" and then choose the "Expression"-window for the formula.
ImkeF
Community Champion
Community ChampionHi kb177 ,
to make using the result of the query against your dataset as easy as possible I'd recommend to transform the matrix visual into a table visual instead. This ensures that only one table is returned by the DAX-query and you then therefore reference it unambigously.
In your flow, you create a compose action and use this formula in it:
outputs('Run_a_query_against_a_dataset')?['body/results'][0]['tables'][0]['rows']
This will return an array. Based on this, you can follow the instructions in this video to: Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Email - YouTube
1) Create an Excel file
2) Create a table in that Excel file
3) Fill in the rows from your array into this table
kb177Helper II
Helper IIShould I add run a query against data set and then compose flow ?
if that's the case then compose action is just returning the formula as text in output