Power Platform Community Forum Thread Details

Hello,

I have trawled through the forums but haven't found anything that can help.

I have an Excel file (File A) with 9 sheets. I need to take 3 sheets and copy into a new Excel file (File B), take another 3 and copy into another new File C, and the final 3 into File D.

The flow can be triggered by moving File A into a particular SharePoint folder, unless there is a better option. There are no Excel tables.

Can anyone help?

Thanks in advance.

Categories:

Building flows

The "quickest" method of doing so regularly is using Office Script. But if you haven't done Office Script before, you might find it hard to learn/use. This gets into an area of "high" code. But you can learn if you want: https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel

If you want to strick with "low/no" code with Power Automate, there's also 2 ways you can go about it: slow but easy, fast but harder

Slow but easy
- Create the 3 new excel files
- Get worksheets from excel File A
  - determine your logic of which worksheet of the 9 is going to File B C or D
  - apply to each worksheet:
    - create table of the worksheet range that has the rows/columns of data
    - list rows present in a table
    - apply to each rows
      - add row into table
Fast but harder
- Create the 3 new excel files
- Get worksheets from excel File A
  - determine your logic of which worksheet of the 9 is going to File B C or D
  - apply to each worksheet:
    - create table of the worksheet range that has the rows/columns of data
    - list rows present in a table
    - use Graph API to insert a 2-dimension array into the new excel file's worksheet