I have a report that is emailed into a shared inbox each week. I need to copy all the rows into a table on a pre-existing excel file. I have been searching for advice for some time, and everything I can find says tto create a flow that looks something like:
When Email is received
For each
Get attachment
Create file
Create a table
List rows present in a table
For each
Add a row to a table
This seems to work fine until I get to the Add row to a table. I am testing over and again with the same file, I have now got to the point where it tells me it has succeeded, and every step up until Create a Table is definitely working as expected. However, each time it fails to copy the data. Instead, it adds blank rows to the destination table, not only that a different number of blank rows is being added each time. This seems to me like the most basic possible use of Power Automate, to simply copy all and paste into another table, but here I am 3 days later. What am I doing wrong for it to add blank rows instead of my data? Screenshots below of what I have for each step in question.
Many thanks
EDIT: Apparently I am unable to reply to my own post for some reason.
I cannot share company data on a public forum. For information though, the data is names and email addresses and course names to indicate which colleagues have completed certain e-learning courses. So, there are columns for name, email, managers name, managers email, course name and pass date.
What do you mean by data being “passed in”? If this is Power Automate terminology then I am unaware as this is the first time I have ever used it. But all of the data received in the email is being saved in Table1 of the file that is created and then referenced in the first screenshot, so if that is what you mean then this is definitely happening.
2
Share
Report
All responses (
Answers (
