How to create a PDF using Power Automate from a SharePoint List Item

In this demo I show how to create a PDF file using Power Automate. This uses the File Convert function and OneDrive to generate a PDF file using a List item as the input. This is great for creating a printable file or receipt to send to someone based on the list content. There are many things you could do this this! Learn how in less than 5 minutes.

[euniceseifert]

This was great! !!! Thank you so much. My only wish is that you could do store the info within the SharePoint rather than to OneDrive in the same manner.

[usurper]

Hi Steve,
Thanks for the video. I had a colleague ask for something similar recently. I’ll be happy to tell him we can now accommodate him. Cheers!

[naziahurrymun]

Hi Steve, great video. Are we able to create the pdf file in Landscape, rather than portait?

[ginoginetto]

Hi Steve great video just a question a want save the pdf file with the "title" value in sharepoint, in the "create file 2" on the field "File Name" ex. SHAREPOINT_TABLE.TITLE.PDF but i don't know which command and syntax to use. tks in adv

[Joe-kjbw]

Wow, Thank you Mr. Knutson! I've been looking for a way to do this without a third-party connector or software and this solution was fantastic and worked perfectly. I just need to fine tune the layout, I am not well versed in HTML. Also would like to name the file using a value from the list, like room location or something.

[paulkelly]

Hi Steve.

Thanks for the video.

I have been asked to export an employee handbook from Sharepoint to allow someone to review it.

The handbook is a series of webpages with a table of contents page.

Do I have to do each page indivdually or is there some way I can supply a 'root' page and have the routine work through each page?

[nicoletonietto]

Hello, great video thanks!
I am trying to create an action to send the PDF in a e-mail with the "send mail" action. When I try to fill the "Attachments contents" part I don't have an option "File content" in the "Create File 2". Do you what I could do to send the PDF in the mail ?
Thanks in advance

[ryanhewitt]

thanks for the video :) Is their anyway to ignore blank columns when generating PDF's? sometimes not all columns are used and i dont want that on the final pdf if possible. I know something can be acheived using an expression somehow.

[sebasy]

what a great Video!! Thank you very much!!!

[susanamartinezdeunanue]

Hi There!
thanks for the information. What would be the flow to do the same but pulling the file from Sharepoint.
I am working in a project but it looks like we do not have the action convert html to pdf from Sharepoint :(
any advice is greatly appreciated.

[deepikaradhakrishnan]

Hi Steve, If it is possible to generate pdf from multiple sharepoint lists

[ARONCASSELL]

would there be a way to add all attached items on the sharepoint list to the pdf such as .jpg files

[hugosoto]

Hey Steve, Great video
By any chance do you know if it is possible to add a professional header (or images) to this process?
I'd love to generate some official company documents for which that would be necessary
Thanks a lot

[abuena]

how about if my SharePoint list has an image item, how could i call it to html/PDF?

[nikitachakh]

Hi Steve, thanks for this video. Is there any way to convert an Excel file located in a Sharepoint to a PDF file, without using your One Drive account and without using any third party Flows? Thanks

[yuetnhinhin]

Thanks Steve, I am using this method to create PDF file where chinese character in the html content. The output pdf could not show the chinese character correctly. Those characters became a block. Do you have any ideas on this? I guess it doesn't support UTF-8. Is it true. Thanks

[AliOGUL]

I keep getting error 400, file id is not valid error on the covert file stage. any suggestion?

[BEautiful]

Hey Steve - how do you take that converted pdf and attach to outlook email?

[muzammil]

Hi Steve video helped me a lot, but i want my pdf in tabular form please help me again

[kathrynhall]

Thank you so much for this, it’s exactly the answer I was looking for. However I’m having an issue with dynamic content that contains more than one response.

I’m using this to create a pdf document based on an entry in a SharePoint list. The responses are for an incident report that it is completed through a Power Apps form.

Some of the responses allow for multiple answers. I have a text field for a list of witnesses, separated by commas, as well as a list of injury types and locations where the staff member can select all that apply to them.

How can I get the items in these fields separated into bullet points?

I can bullet the line, but not separate the contents to provide multiple bullets.

Also, for the fields where more than one option can be selected, I’m not getting the responses at all, more of an error code.


Any help would be greatly appreciated, I’m incredibly new to this and it’s my first journey into the world of HTML code.