So I've been working on this flow for about a week now and I just keep hitting errors after errors, making the flow more and more bloated and I decided I better come here and just ask for some help.
The basic function of the flow is to take an excel file that I get emailed everyday and update an existing sheet with the new data.
Here is my flow with some explanation to my reasoning:
Firstly the flow triggers from an email to a specific folder in my outlook
Next, I take the contents of the emailed excel file and update an existing file with the contents. The reason I use "Update file" is so I can run two scripts, 1 to remove all formatting from the file (it has filters, which won't allow me to create a table) and 1 to format the data into a table (since Power Automate only lets you interact with data in a table).
Next I get the rows of a table in a separate excel file (this is the file I'm doing all the actual data manipulation in) and I delete all the existing data.
Next I get the table that I created earlier.
Finally I get the rows of the table with the new data in and I copy that data across into the other excel sheet.
Now the current error I get is that the flow won't run the scripts that I've built:
So I suppose I'm asking for either:
- A fix for the above error?
or
- Is there any easier and more efficient way to build this flow all together?
Thanks.
