I have a requirement where I have 3 different fetchxml queries of same table, on button click on Main grid it should create that data in 3 different sheets of the same excel file along with pivot table and download that file.
I have used using power automate "HTTP trigger and Respond to power app flow". its giving runtime error as the file has around 300 records.
I have used Plugin its giving the "ClosedXML" error.
Power Automate + Excel Online (Business) connector + Office Script
Excel template
– In OneDrive or SharePoint, create a workbook with three empty sheets (e.g. “Stage 1”, “Stage 2”, “Stage 3”) and define a proper Excel Table on each (Table1, Table2, Table3).
Flow trigger
– Use the “Power Apps” trigger in Power Automate or an HTTP trigger if you prefer to call it yourself.
Fetch your data
List rows (Dataverse)
– FetchXML #1 → apply to Table1
– FetchXML #2 → apply to Table2
– FetchXML #3 → apply to Table3
– In each loop, use “Add a row into a table” (Excel Online (Business)) to inject the Dataverse fields you need (including modifiedby and modifiedon).
Create Pivot
– Add a “Run script” (Excel Online (Business)) action that calls a small Office Script you write once to insert a pivot table per sheet (or a consolidated pivot if you prefer).
Return/download
– “Get file content” (OneDrive) → “Respond to Power Apps or flow” with a file attachment.
Pros: No size limits up to ~250 MB; runs entirely in the cloud; uses only supported connectors.
Was this reply helpful?YesNo
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.
2
Share
Report
All responses (
Answers (
