How to get table range for a pivot table?


I am trying to get the table range for a time pivot table but I am failing I tried using get table range activity but it only cater for if you getting an actual table’s range not a pivot table.

Is there another way I can use to the range for a pivot table.

Help will be appreciated thank you.

Hello @Phillip_Sibanda

can you use read excel and read the pivot. Then in the datatable try to use the find the first row and last row.

That can help to get the range.