
Announcements
Flow: Export To File for Paginated Reports -> Create File (file content "body('Export To File for Paginated Reports')) -> Create Table
Question: How to I have the Table range in Create Table to be dynamic to the data passed from Paginated Reports?
Thanks in advance!
Hello @TerryHughes ,
do you already know at least the columns number?
If yes, please put the following text in the "Table range" field: =OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),3)
where 3 is the columns number.
If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco
BR,
Marco