cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amirghaderi
Helper III
Helper III

Multiple pages selection in Power Automate PDF conversion of Power Bi

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

 

amirghaderi_2-1630246461141.png

 

 

 

1 ACCEPTED SOLUTION
amirghaderi
Helper III
Helper III

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 🙂

amirghaderi_0-1631354703534.png

 

View solution in original post

3 REPLIES 3
amirghaderi
Helper III
Helper III

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 🙂

amirghaderi_0-1631354703534.png

 

View solution in original post

v-xulin-mstf
Community Support
Community Support

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:

vxulinmstf_0-1630984313372.png

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

vxulinmstf_1-1630984537359.png

 

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
Responsive Resident
Responsive Resident

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:

Migasuke_1-1630269178319.png

Migasuke_2-1630269202938.png


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



Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors