how to create table and the move to another table in excel in a single flow?

[Blewis21]

I can do the 2 flows below separate, but how to do I do this in a single flow?

1.) I can take a worksheet in excel and convert it into a table using power automate

2.) In a separate flow, I can take an existing table 1 in excel file "A" and move it to table 2 in excel file "B"

but... how do you have that all in a single flow? convert a worksheet to a table from excel file "A" and then take that newly created table (table 1) and move it to table 2 in excel file "B" 

[fchopo · Accepted solution]

Hello @Blewis21 

You could do something like this:

The steps are:

1) Create a table from an existing excel worksheet, specifying the table range and the column names.

2) List rows in the table.

3) For each row, add it to a new excel file (with an existing table).

You can use some expressions to get the columns values in the 3rd step, like: 

items('apply_to_each')?['Date']

Hope it helps!

Ferran