Good morning,
I have two Excels files. I want to export data from Excel file A to Excel file B because I need the historical data by day. I have created a flow in Power Automate.
Recurrence-Get tables- List rows present in a table-Apply to each- Add a row into a table.
Do you miss any step?
How can I improve the flow?
On the other hand, the data in the excel file A is into a pivot table. I want to export this data but when I have to choose the table in "List rows present in a table" I can´t choose directly the pivot table. I have to get another table and I pass the data from the pivot table to the new table with the formula =. After that I can use this new table.
Do you know how can I choose the pivot table in "List rows present in a table"?
Thanks in advance.
This is the flow: