web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need assistance with P...
Power Automate
Unanswered

Need assistance with Paginated Report Builder to Excel Table

(1) ShareShare
ReportReport
Posted on by 36

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!

Categories:
I have the same question (0)
  • Verified answer
    MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    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.

     

    MarconettiMarco_0-1660288156866.png

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard