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.
kb177Helper II
Helper III want to export to excel not to csv, After pasting the query in the below flow what should be done next
I dont want to create csv table and create a file from that
From there you can try converting CSVs to Excel with something like this template:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-New-Excel-Table/td-p/1826096