Using Paginated Report Name in Power Automate

[timspan]

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!

[v-yangliu-msft · Accepted solution]

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.

Use the Apply to each action to process a list of items periodically - Power Automate | Microsoft Le...

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.

[timspan]

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.