I am stumped and Google is uncooperative.
I am trying to add rows to a static Excel master file from a dynamically obtained Excel file from outlook.
I have been unable to append data to the master file. If I take the dynamic file and pretend it's static in another power automate i can list rows and then append to the master document with add rows. But if the dynamic file is newly created, it will not append to the master file. Flow is as below
Trigger-- new email
Apply to each
Get attachment
Create file
Create table
Get table
List rows from dynamic file
Parse json - to get column names
Apply to each
Add rows to table. -- I'm failing here too append data
I believe it has something to do with mapping the columns, but what I'm doing is failing.
Please help
