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.
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.
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
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
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.
You could use use variables to create each line of HTML e.g. label{column value} and then concatenate the variables to create the HTML format, checking to see if each column is not blank.
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?
Hi Paul, I think this might help. I am not sure it will work with images in the page however, but it would be worth a try. sharepointstuff.com/2022/06/15/convert-sharepoint-pages-into-pdf/comment-page-1/
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.
To do this you will still need to convert the file using OneDrive as I show in the video. You can "Get File Content" action to get the content of the file in SharePoint and then create a file in OneDrive using the Content from the first action, next use the OneDrive Convert File action to create a PDF file and then use the SharePoint Create File action using the content from the Converted file action.
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
Hi Hugo, you can add images to the HTML template to style the output. It uses standard HTML tags.If you have a paid Power Automate license then you can use Microsoft Word documents as a template.
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
Hi Joanne, I know it is possible with some of the email actions, but I am not sure if the HTML content supports UTF-8. You may be able to get some help on the Power Automate forum powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
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
Hi Siretha, this blog explains how to attach PDF files using Power Automate medium.com/@woophily/power-automate-send-email-with-attachments-when-adding-new-item-in-sharepoint-a52bfb90fbd4
It will depend a bit on your data. If it is a single List item then, you can create an HTML Table. If it is multiple List items then you need to do a For Each loop and append a new Table Row. This is the reference for the HTML you need to create. www.w3schools.com/html/html_tables.asp
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. [{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:10,”Value”:”Sprain/strain”},{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:13,”Value”:”Other”},{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:-1,”Value”:”possiblybroken- awaiting xray”}] Any help would be greatly appreciated, I’m incredibly new to this and it’s my first journey into the world of HTML code.
Hi Jennifer, I am using a 'Compose' action to build the HTML table. There are some more details on my blog that should help steveknutson.blog/2022/01/25/create-a-pdf-from-a-sharepoint-list-item-with-power-automate/
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.
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!
Awesome, glad this helped :)
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.
I’m glad it helped 😀 You can use dynamic content in the Flow to name files.
Hi Steve, great video. Are we able to create the pdf file in Landscape, rather than portait?
what a great Video!! Thank you very much!!!
Thank you
Thanks Steve you for this video.
My pleasure!
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
Hi Steve, If it is possible to generate pdf from multiple sharepoint lists
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
would there be a way to add all attached items on the sharepoint list to the pdf such as .jpg files
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.
You could use use variables to create each line of HTML e.g. label{column value} and then concatenate the variables to create the HTML format, checking to see if each column is not blank.
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?
Hi Paul, I think this might help. I am not sure it will work with images in the page however, but it would be worth a try. sharepointstuff.com/2022/06/15/convert-sharepoint-pages-into-pdf/comment-page-1/
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.
To do this you will still need to convert the file using OneDrive as I show in the video. You can "Get File Content" action to get the content of the file in SharePoint and then create a file in OneDrive using the Content from the first action, next use the OneDrive Convert File action to create a PDF file and then use the SharePoint Create File action using the content from the Converted file action.
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
Hi Hugo, you can add images to the HTML template to style the output. It uses standard HTML tags.If you have a paid Power Automate license then you can use Microsoft Word documents as a template.
how about if my SharePoint list has an image item, how could i call it to html/PDF?
I have the same question. I cannot bring over images using the dynamic url objects provided. I tried but it does not translate to PDF
Thanks a million ❤
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
Hi Joanne, I know it is possible with some of the email actions, but I am not sure if the HTML content supports UTF-8. You may be able to get some help on the Power Automate forum powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hello! Were you able to fix this? I have the same problem
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
Hi Nikita, sorry I didn't see your message. The only choices are OneDrive or third-party tools.
Hey Steve - how do you take that converted pdf and attach to outlook email?
Hi Siretha, this blog explains how to attach PDF files using Power Automate medium.com/@woophily/power-automate-send-email-with-attachments-when-adding-new-item-in-sharepoint-a52bfb90fbd4
Hi Steve video helped me a lot, but i want my pdf in tabular form please help me again
It will depend a bit on your data. If it is a single List item then, you can create an HTML Table. If it is multiple List items then you need to do a For Each loop and append a new Table Row. This is the reference for the HTML you need to create. www.w3schools.com/html/html_tables.asp
I keep getting error 400 , file id is not valid error on the covert file stage. any suggestion?
okay, found solution. instead of Path on the "convert" you should put ID
Hi Ali, it sounds like the ID being used isn't the source file.
Impressive!
Thank you
Seems very hard to post sample code :}
Thanks.
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.
[{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:10,”Value”:”Sprain/strain”},{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:13,”Value”:”Other”},{“@odata.type”:”#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”,”Id”:-1,”Value”:”possiblybroken- awaiting xray”}]
Any help would be greatly appreciated, I’m incredibly new to this and it’s my first journey into the world of HTML code.
Same here, did you solve it?
Not sure what's up with my flow, but after I do a Get Item, I try to add HTML but the only thing close I get is Create HTML Table.
Hi Jennifer, I am using a 'Compose' action to build the HTML table. There are some more details on my blog that should help steveknutson.blog/2022/01/25/create-a-pdf-from-a-sharepoint-list-item-with-power-automate/