Multiple pages selection in Power Automate PDF conversion of Power Bi

[amirghaderi]

I have a Power Automate flow which creates PDF from a Power Bi report. I want to select multiple pages during PDD conversion. But, I am struggling to find out how to put AND in Pages section of the below screen. It works perfect for one page. But, when I try to ad more than one page, then it does not work. I am sure that i am not applying AND correctly

[Oscar_Mtz_V]

This also works. 

[amirghaderi · Accepted solution]

I found a very simple soloution. Just by clicking on "Add new item", as many pages can be added. Sometimes we are looking for complex soloutions 🙂

[JCERVANTES]

Hello...I'm wanting to do something similar. Export in an PPT format specific pages of BI Report. I can get several pages to work but the main page won't export.

In the pages section, I've all the pages I'm wanting to export to PPT. Where did I go wrong?

[v-xulin-mstf]

Hi @amirghaderi,

Here is a workaround to generate multiple pages PDF in Power Automate.

First step is to write some HTML in a “Compose” action:

The div approvalHistory has a height of 300px. This makes it possible to insert content into this div that is dynamic and not always has the same height in the PDF.

For the h2 tag, I calculated a little bit and added a margin-top of 450 pixels. This is not really a proper solution, but it can be useful if you cannot buy extra subscriptions.

Next steps are:

• Creating the HTML file
• Convert the HTML file to PDF
• Creating the PDF file

For more information, you can refer:

https://www.inspiribytes.com/power-automate/generate-multiple-pages-pdf-in-power-automate/

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Migasuke]

Hi @amirghaderi ,

I had similar problem but did not solve it entirely, but I still found some hints:
1. If you want to add more pages, you need to add them in array.
2. My array does not work if I put it directly in the field. I need to first set up Array Variable and then use it in the field. Something like this:

Unfortunately, after testing the flow, I receive message "Bed Request" and nothing more.