How to Copy Data from One Excel to Another Excel in Power Automate?

In this Power Automate tutorial, we will see how to copy data from one Excel to another Excel in Power Automate automatically.

Here we will cover two examples to copy data from Excel to Excel using Power Automate.

  1. Copy data from one Excel to another
  2. Copy Excel data from two Excel files to another Excel file

Now, let’s discuss our first example ‘Copy data from one Excel to another’ using Power Automate.

How to Copy data from one Excel to another using Power Automate

Here we will see how to copy data from one Excel to another using Power Automate.

Now, we will create an Instant cloud flow that will copy Excel 2 to Excel 1 file from SharePoint Folder using Power Automate.

Using Power automate copy data from excel to excel

Let’s see how we can create an Instant cloud flow that will copy an Excel file to another Excel file.

Step 1: Log in to Power Automate, click on +Create, and select the Instant Cloud flow.

Using MS flow copy data from excel to excel

Now provide the flow name and select Manually trigger a flow action. Then click on Create.

Using Microsoft flow copy data from excel to excel

You can see a Manual trigger a flow action is added to the flow in Power Automate.

Power automate copy data from excel to excel
Power automate copy data from excel to excel

Step 2: Next, click on the +new step and then select List rows present in a table action. Then provide the below information:

  • Location: Select or Provide the location of the Excel file.
  • Document Library: Select the Document Library.
  • File: Select the file. In this case Excel2.xlsx
  • Table: Select the table of the Excel file.
Microsoft Power automate copy data from excel to excel

Step 3: Now we will add the row from Excel 2 file to Excel 1 file, so, click on the +New step -> select Add row into a table action. Then provide the below information:

  • Location: Select or Provide the location of the Excel file.
  • Document Library: Select the Document Library.
  • File: Select the file. In this case Excel1.xlsx
  • Table: Select the table of Excel file.
  • Product name: Select the product name from the dynamic content
  • Category: Select the Category from the dynamic content.
  • Product Price: Select the product price from the dynamic content.
copy data from one excel to another excel in Power Automate

Step 4: To run the flow click on Test icon, click on the Test icon-> select Manually -> click on Test -> configure the action with connectors, then click on Run flow -> Then click on Done

See also  How to Format Number to Percentage in Power Automate? [3 Useful Examples]

Now you can see your flow ran successfully, and go to the SharePoint folder, and open the Excel 1 file. You can see the data from Excel 1 is copied to Excel 1.

copy data from one excel to another excel in Power Automate

Copy Excel data from two Excel files to another blank Excel file in Power Automate

Here we will see how to copy Excel data to another blank Excel file using Power Automate.

We will create a schedule flow in Power Automate that will run every Wednesday for a week. Every week on Wednesday it will extract all the data from Excel 1 , and Excel 3 -> also we will create a blank Excel sheet (Final Excel) using the Excel template.

Finally, in the final Excel, we will copy the data from Excel 1 and Excel 3.

Excel 1: Then excel 1 contains the below columns:

  • Product name
  • Category
  • Product price
Copy excel file to another excel file
Copy excel file to another excel file

Excel 3: This Excel contains below columns:

  • Product name
  • Area
  • Availability
Copy excel file to another excel file using Power Automate

Excel Template: This template contains below columns:

  • Product name
  • Category
  • Product price
  • Area
  • Availability
How to Copy excel file to another excel file using Power Automate

Here is how our Final Excel looks like

How to Copy excel file to another excel file using Microsoft Power Automate
How to Copy excel file to another excel file using Microsoft Power Automate

Let’s see how we can create the flow to copy data from Excel to blank Excel using Power Automate.

Step 1: Log in to Power Automate, click on +Create, and select the Schedule Cloud flow.

Microsoft flow copy data from excel to excel

Now provide the flow name and select 1 and select week -> select time -> lastly select any day from a week (I choose Wednesday). Then click on Create.

Microsoft flow copy data from excel to excel file

Now you can see the Schedule flow trigger i.e. Reccurence is added to the flow page.

power automate copy data from excel to excel

Step 2: Get the rows from Excel 1, so click on the +New step and select the ‘List rows present in a table‘ action. Then provide the below information:

  • Location: Select or Provide the Location of the Excel file
  • Document Library: Select or provide the Document Library
  • File: select the Excel file
  • Table: Select the Table of Excel
 Copy data excel file to another excel file using Microsoft Power Automate

Step 3: Now we will get the File content of the Template Excel file, so click on the + New step -> select Get file content action. Then provide the below information:

  • Site address: Select or Provide the SharePoint site address.
  • File Identifier: Select the path of your template file.
Copy data excel file to another excel file using Power Automate

Step 4: Now we will create a New blank Excel file, so, click on the +New step -> select Create File action. Then provide the below information:

  • Site address: Select or provide the site address
  • Folder path: select or provide the folder path.
  • File name: Select or provide the file name.
  • File content: select or provide the file content.
power automate copy data from excel to excel

Step 5: We will create the table in the new Excel file i.e. Final Excel file. So, click on the +New step -> select Create Table action, then provide the below information:

  • Location: Select or provide the Location of Excel.
  • Document Library: Select the Document Library where the Excel file is present.
  • File: Select the Excel file below.
  • Table range: Select the table range like below.
  • Column names: provide the column names with commas separated.
How to Copy data excel file to another excel file using MS flow

Step 6: Then click on Add an action -> select ‘List rows present in a table action. Then provide the below information:

  • Location: Select or Provide the Location of the Excel file
  • Document Library: Select or provide the Document Library
  • File: select the Excel file
  • Table: Select the Table of Excel
power automate copy data from excel to excel

Step 7: Next we will copy the data from Excel 1 to the Final Excel file. So, click on the +New step -> select ‘Apply to each action. Then provide the below information:

  • Select an output from previous steps: Select the value -List rows present in a table, from dynamic content.
See also  Power Automate Get Display Name From Email

In this Apply to each action, click on Add an action -> select Add a row into a table action. Then provide the below information:

  • Location: Select or Provide the location from dynamic content.
  • Document library: Select the Document library from the dynamic content
  • File: Select or Provide the file.
  • Table: Select or provide the table
  • Row: Provide the below code:
{
  "Product Name": @{items('Apply_to_each_2')?['Product Name']},
  "Category": @{items('Apply_to_each')?['Category']},
  "Product Price": @{items('Apply_to_each')?['Product Price']},
}
power automate copy excel worksheet to another file

Step 8: Next we will copy Excel 3 to the Final Excel file, so click on the +New step -> select Apply to each action. Then provide the below information:

  • Select an output from previous steps: Provide the value of List rows present in a table for Excel file 3.

Then click on Add an action-> select Update a row action. Then provide the below information:

  • Location: Provide the location of the Final excel file
  • Document Library: Select or provide the document library
  • File: Select the File
  • Table: Provide the table name from dynamic content.
  • Key Column: Write the Key Column as Product Name (Unique Id)
  • Key Value: Select the value as a Product name from dynamic content.
  • Provide the item properties: Provide the below code:
{
  "Area": @{items('Apply_to_each_3')?['Area']},
  "Availability": @{items('Apply_to_each_3')?['Availability']}
}
power automate copy excel worksheet to another file

Step 9: To test the flow click on the Test icon -> select Manually -> click on the Test button -> configure the action with connectors, then click on Run flow -> Then click on Done.

Now you can see your flow ran successfully. Also, you can see the Excel 1 and Excel 3 data is successfully copied to the final Excel file.

power automate copy data from excel to excel

Conclusion

In this Power Automate tutorial, we saw how to copy data from an Excel file to an Excel file using Power Automate. Also, we saw how to copy data Excel file to another new Excel file in Power Automate.

See also  How to add Site columns to SharePoint content type using Power Automate?

You may also like:

>