Power Platform Community Forum Thread Details

It is possible.

Sharing a demo flow with steps to get an idea on how to design such flows 🙂

So i have created a excel file , it has three sheets : Sheet1 , Sheet2, Sheet3 (Sheet3 we won't discuss).

Sheet2 has Pivot table (datasource is from Sheet3)

Now go to flow

Step1: Launch the excel file by passing the file path

Step2: Make sheet2 (which has pivot table) as active

Step3: Get the first free row/column from active worksheet (i.e Sheet2) and for easy reference, i have named both variables (first free row and first free column) as PivotFreeRow and PivotFreeColumn respectively.

Step4: Read the data from active worksheet by passing data from previous step and store in a datatable variable, let's say PivotData

Step5: Now set active worksheet as Sheet1 (which is the table we are writing the data from pivot table)

Step 6:Read the data from active worksheet (i.e Sheet1) like below

Note: here i am reading data from A1 to D1 , only for the headers data, in my case my headers in Sheet1 are upto D1, so provided like that you can change the D to required column letter to which your column is present in the worksheet where you need to write the data.

Step7: Create a new datatable variable named %dt1Final% with value like below