Generate a PDF from Microsoft Flow

Recently I have been asked by a few clients how to create PDF files from SharePoint Online List Items. At first, I was perplexed by this request, it is not something I ever need to do. After a few probing questions, I found that they were using SharePoint in very cool ways and one, in particular, was tracking trouble tickets and then generating an "after action report" for distribution to their customer as a PDF via email.

[chih-ninghsu]

Fabulous!! I was able to follow through the video and create a solution immediately for our team in Peru. They will be so pumped when I show them tomorrow! THANK YOU MUCH!!!

[casingena]

What a fantastic solution, thanks Matt. Loved the delivery! This is certainly a Flow that a lot of people will find incredibly useful.

[earllinealcide]

this is the most concise, clear explanation I've come across. thank you!

[althurmonang]

Thanks for the tutorial Matt! could not describe more clearly how this helps me

[hmvelloso]

Hey, man! Awesome video. Using what you showed, I'm gonna be able to change like a dozen documents in my company! Thank you very much!!

[artoonugroho]

Great video. Interesting! I have an issue in microsoft flow. I have no idea how to merge 2 different SharePoint lists in one flow and generate it into one pdf file then send an email that contain the pdf file. Do you have any clue. Thankyou

[njfrlng]

Can this work but with an entire list from Sharepoint?

When I get to the replace function in the Compose, I cannot select any dynamic content from the Get Items - plural (versus the Get Item - singular)

I want to use your technique to generate an individual report for every item in my sharepoint list that I can ultimately merge into one PDF.

[yehunlavolontededieu]

Thank you very much Matt. Incredibly useful.. ..Can I convert multiple items at once ? And merge the induvial multiple pdfs into one pdf? to send by email as a weekly report. They're looking for all the different items to be on the same pdf. For eg: 9 items at once / for weekly task report . But all i need is max 3 fields title+Date+ Description. Bear with me pls, can i also trigger the conversion when a status filed changes to " complete" in the SP list? Thanks a lot in advance.

[robertmerritt]

Awesome video. May I ask how do I get my power apps and flows to run under the context of the current user, instead of the user who created them?

[amyclapp]

What do you do when your HTML file is larger than 2MB? Convert file fails in that case. Do you have a workaround?

[dyldatsroj]

Thanks for good introduction.

I have a challenge to need some assistance: One of the columns in the table from which I retrieve information is optional, which means that some fields are sometimes empty. This causes flow to fail when it finds an empty field. My wish is that there should be no text in the final report when the table fields are blank, is it possible?

[jrhcr]

the html templates are necessary? I need to export a PDF with all the information of the selected item of the list, what I have to do. Thanks

[andyxberner]

Does the Compose action work with lookup columns? My flow worked for a text field, but there was a problem with a lookup.. unless there's something else going on?

[dbjaquet]

Great video, Thanks! I have a specific need to create the temp HTML file in SharePoint instead of OneDrive but during the conversion to PDF I get an BadRequest 400 error with the message “the response is not in a JSON format” .. do you have an idea on how to get around that?

[gaozizheng]

I encounter an issue here that really need your advise. I have created the flow, but it seems like the HTML will only replace the very last content, while the rest remains unchanged, what would that be?

[bhrigunath]

Thank you for the Solution... Can you help with how can we export attached images in list item in same PDF...

[marlonchristie]

great video, however when I try the first replace file content expression I get instead of "replace(body('Get_file_content-__Asset_Sheet')", what am I doing wrong

[lilfrog]

What happens if the HTML file links to a picture that exists on the same folder, for example a picture is called something.png and we added it to the html template as <img src="something.png"> will it be shown on the generated pdf?

[jhctao]

Seems the function replace() only can replace strings. Failed if the value in the SharePoint List is a number or date.
Unable to process template language expressions in action 'Compose_-_xxx' inputs at line '1' and column '20792': 'The template language function 'replace' expects its third parameter 'new string' to be a string. The provided value is of type 'Float'.


Any ideas if the values are numbers or dates? I can't change the source in SP List to different datatype.

[hughmurfitt]

Elegant solution, clearly and succinctly explained