Forum Discussion
Using Paginated Report Name in Power Automate
Hello,
I have a paginated report with multiple page breaks. I named each worksheet a unique name.
I want to use Power Automate to grab each worksheet and separate into emails. Is this possible?
Thanks!
Hi timspan ,
You can try the following steps:
Use the “Export to File for Paginated Reports” action in Power Automate to specify the format (e.g., Excel) and report parameters. Export the paginated report.
Export paginated reports with Power Automate - Power BI | Microsoft Learn
After obtaining the paginated report, you can use Power Automate with the “Get file content” and “Apply to each” actions to split the Excel file into individual worksheets.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi timspan ,
You can try the following steps:
Use the “Export to File for Paginated Reports” action in Power Automate to specify the format (e.g., Excel) and report parameters. Export the paginated report.
Export paginated reports with Power Automate - Power BI | Microsoft Learn
After obtaining the paginated report, you can use Power Automate with the “Get file content” and “Apply to each” actions to split the Excel file into individual worksheets.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liu,
I don't believe I am understanding the part where you say to get file content and apply to each action. The get file content is using OneDrive and captures the file from my paginated report with content type infered. However, the apply to each action does not have dynamic content available, so I am unable to gather the content from the previous step.
Another piece is that each worksheet will be sent to different customers, so I added a condition where I hope to be able to say if "X" worksheet, then send to "Y" customer. Below is a screenshot of my current setup. Thanks for taking a look.
