Hello,I have an Excel file that has several different spreadsheets, but I want to copy only the data from the "FormOP" spreadsheet and paste it into a

You can also use this template Azure Function to pull data from any Excel sheet without the need for table formatting...https://community.powerplatfor

Copy spreadsheet from one excel and paste into another excel

Yes, you can automate the process of copying data from a specific sheet in an Excel file to a new Excel file using Power Automate (formerly Microsoft Flow). Here’s a step-by-step guide on how to set this up:

Step-by-Step Guide to Automate Copying Data Using Power Automate

Create a New Flow:
- Click on "Create" from the left sidebar.
- Choose "Automated cloud flow" or "Instant cloud flow" depending on whether you want to trigger it manually or automatically.
Define a Trigger:
- For an Automated cloud flow, you’ll need to select a trigger like “When a file is created or modified” in OneDrive or SharePoint, depending on where your file is located.
- For an Instant cloud flow, you can manually trigger the flow from the Power Automate interface.
Add Actions to Copy Data:
- Get File Content:
  - Add a new step and select the "Get file content" action.
  - Choose your file location (OneDrive, SharePoint, or other).
  - Specify the path to your Excel file.
- Read Data from Excel:
  - Add a "List rows present in a table" action from the "Excel Online (Business)" connector.
  - Select your file and specify the "FormOP" sheet from which you want to read the data. Ensure your data is formatted as a table in the Excel file for this to work.
- Create New Excel File:
  - Add a "Create file" action.
  - Choose the location (OneDrive, SharePoint) where you want to save the new Excel file.
  - Specify the file name and path.
- Add Rows to New Excel File:
  - Add a "Add a row" action to insert data into the new file.
  - Specify the file and table where you want to add the rows. You may need to format the new file similarly to the original.
Test Your Flow:
- Save and test your flow to ensure it works as expected.
- Check the new Excel file to verify that the data from the "FormOP" sheet has been copied correctly.

Detailed Steps for Reading and Writing Data

Get File Content

Action: Get file content
Location: Choose the location (e.g., OneDrive for Business, SharePoint)
File Identifier: Path to the Excel file containing the "FormOP" sheet.

Read Data from Excel

Action: List rows present in a table
File: Use the file identifier from the previous step
Table Name: Select the table corresponding to the "FormOP" sheet.

Create New Excel File

Action: Create file
Location: Choose the destination (e.g., OneDrive for Business)
File Name: Specify the name for the new Excel file
File Content: Use content or template as needed.

Add Rows to New Excel File

Action: Add a row into a table
File: Choose the new Excel file
Table Name: Specify the table in the new file
Row Data: Map the data from the "FormOP" sheet.

Notes

Ensure that both the source and destination Excel files have tables defined in them. Power Automate uses these tables to identify and manipulate data.
You may need to adjust the schema of your destination file to match the source file’s structure.

By following these steps, you can automate the process of copying data from a specific sheet in an Excel file to a new Excel file using Power Automate.

Quick Links

Leaderboard > Power Automate - Building Flows