Power Automate Tutorial: SharePoint List to PDF

In this video Jonathon explains how to use Power Automate to generate a table, designed with some CSS styling, and store it as a PDF. Follow along as he walks through the steps to take a standard list and use the data operations Create HTML Table and Compose to design a customizable table, then use OneDrive actions Create File and Convert File to save the table as a PDF.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks #JonathonSilva

-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
-~-~~-~~~-~~-~-

[omonbhudeiyoriobhe]

You taught this very well. I found it super helpful. Thank you!

[isaabdulghani]

This is very helpful. Thank you for the wonderful lessons!

[vinayv]

Thank you Pragmatic works for great videos, Can you please attach sample data as well

[rozinagoogle]

Great video, how can I generate a pdf from 3 sharepoint lists linked with a lookup column?

[marcb.]

Thank you for the video, it is very useful. I have a large table that when printed uses 3 pages, do you know of a way to consolidate to one page? In other words, i would like to split the page into 3 columns and have the table "wrap". Is this possible with css?

[midnightbeginning]

This is really helpful, but how do you get the headers to show on all pages when the list spans multiple pages?

[pedrohenriquefontesleitao]

Is it possible to get the image from an image column?

[FabianT.-pott]

Hi Jonathon,
if i set the trigger for the flow to "when a new item is created" for a sharepoint list, then i need to assign a new/different name for the PDF every time the flow runs.
How can i make the name of the pdf to be created dynamic, e.g. use the ID of the new record and put it in the pdf name?
Thanks a lot.

[ONURAYTAN-zw]

helpful vid, but since my SP list item is very crowded and fhaving too many column attributes with big texts as well, created PDF has too many fields getting off the A4 page limits.,

how can we style html table in a way to format table in A3 and landscape size but also fit in one page? ( the codes available on internet make no effect for a result)

[magnusmlarsen]

Is it possible to create a PDF from individual rows not the entire list, that also contains images?

[davidm]

Excellent user guide. You didn't, however, explain where you got "TravelStartDate" from. I'm assuming it was a bespoke view you created in SharePoint?

The major issue I have with the PDF conversion is that it cannot be formatted in landscape. This limits the output to very few columns. On the other hand, I find the HTML file a lot more pragmatic from a user point of view since it is more responsive and shrinks text size while at the same time expanding the page view to include all the selected data. The limitation I have is it would be nice to have dynamic filters, to filter by a particular column for example.

[mushdatta]

How to get the output of pdf in landscape format

[allansmith]

Is there a way to trigger this flow from sharepoint. I want users to do this not me 😂