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"
Solved! Go to 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
69 | |
27 | |
22 | |
15 | |
13 |
User | Count |
---|---|
132 | |
43 | |
42 | |
34 | |
31 |