Convert SharePoint list item to PDF using Flow or Power Automate

In this flow tutorial, we will discuss how to convert HTML to PDF using Microsoft flow or Power Automate. We will see an example of how to convert SharePoint list item to pdf using flow or Power automate.

We will create a list in SharePoint Online and add some items to the SharePoint list, then we will bind it in HTML format that will convert to PDF files.

The advantage of using Power Automate in SharePoint is that we can easily integrate it with other applications using various connectors without writing any code. In Microsoft flow or Power Automate, there are almost 300 data sources (and publicly available APU) provided by Microsoft.

If you are new to flow, check out an article on What is Microsoft Flow or Power Automate.

Convert SharePoint list item to pdf using Microsoft Flow

Now, we will see step by step how to convert SharePoint list item to PDF using flow or Power Automate.

The final output: When a user creates an item a SharePoint list, S/He will receive an email that contains the PDF version of the list item.

Here we will manage the document management flow using Encodian API.

API Key

To utilize the ‘Encodian Document Manager for Flow’ connector you will require an ‘API Key‘, if you have an existing Encodian subscription but do not know your API Key please email [email protected].

If you do not yet have an Encodian subscription please create a trial subscription by completing the trial request form on our website found here.

Convert SharePoint List item from HTML to PDF file using Encodian

Step 1: Go to your SharePoint Online Site and create a list with below columns

  • Employee Name
  • Company Name
  • Mobile No.
  • Location
  • DOB
convert sharepoint list item to pdf using flow

Step 2: Once the list got created, click on the Power Automate in the top and create a new flow “Send a Customized email when a new SharePoint list item is added”.

convert a sharepoint list item to pdf using microsoft flow

Step 3: Now I will add one more step after Get my profile (V2).

convert html to pdf using microsoft flow

Step 4: Here just search Encodian and select Convert HTML to PDF. So in this step your list item will convert to PDF format.

microsoft flow convert to pdf

Step 5: Now you have to provide the Encodian Connection Name and API Key. In Connection Name, you can provide anything but in API Key, you have to provide the same key that you will get when doing registration on Encodian website.

convert html to pdf power automate

Step 6: Once you click on create, you will get the below page where you have to provide the below details.

  • PDF FileName: You have to provide the file name and extension should be in .pdf format.
  • File content: Optional Field
  • HTML Data: This is important where you can use HTML code and bind your list item data along with you can apply the custom CSS file and image file.
convert sharepoint list item to pdf using flow

Step 7: Next expand the send email and update the two fields in Attachment Name-1 and attachment content.

convert a sharepoint list item to pdf using microsoft flow

Step 8: Next go to your SharePoint Online list, create an item and see you will receive an email with an attachment.

See also  How to use Power Apps List box control?
How to Convert SharePoint list item to pdf using flow

Step 9: When I open the PDF file, I am able to see my list item here in PDF format.

Convert SharePoint List item from HTML to PDF file using Encodian

This is how to convert SharePoint list item to PDF using Flow or Power Automate.

Power Automate create pdf from SharePoint list

In this Power Automate tutorial, we will discuss how to create a pdf from a SharePoint list of items using Microsoft Flow or Power Automate.

We have a SharePoint list called Employee Information, in this list, we will add some items. After that, we will create an HTML table using a List of items and then we will create a file with a .html extension in OneDrive for business.

At last, we will convert the HTML file to pdf, then we will create the file with a pdf extension in OneDrive for Business or SharePoint Online Library.

Steps how Power Automate create pdf from SharePoint list item

Here we will see the steps on how to create a pdf file from the SharePoint list items using Power Automate.

Step 1: Create SharePoint list

I have already created a SharePoint list called Employee Information, having 8 columns with the column type.

Column Column type
TitleSingle Line of text
DepartmentChoice
ManagerPerson
HireDateDate and time
AddressLocation
Phone numberNumber
DOBDate and time
SINSIngle line of text
Employee Information List
create pdf from sharepoint list using power automate
create pdf from sharepoint list using power automate

Once your SharePoint list is done, we will move forward to create a flow.

Step 2: Create a Flow in Power Automate

In Power Automate, Login to Power Automate or Microsoft Flow, then click on Create and select Instant cloud flow.

power automate create pdf from sharepoint list
power automate create pdf from sharepoint list

Now provide the flow name and select the trigger as Manually trigger a Flow.

power automate create pdf from sharepoint list item
power automate create pdf from sharepoint list item

Step 3: Get items from the SharePoint Online list

See also  How to create an array from a string using Power Automate?

Now we will get items from the SharePoint Online list, so click on the Next step and select Get items action. Then provide the site address, list name, and top count as 5, so it will retrieve 5 items from the list.

Microsoft flow create pdf from sharepoint list item
Microsoft flow create pdf from sharepoint list item

Step 4: Map the value

In this step we will map the header and value, so click on the Next step and select Select action, then provide the From field the value from the dynamic content, and then map the field value from the dynamic content.

MS flow create pdf from sharepoint list item
MS flow create pdf from sharepoint list item

Step 5: Create Html table

Now we will create an Html table, so click on the Next step and select Create Html table action. Now provide the from the field from the output from the dynamic content.

How MS flow create pdf from sharepoint list item
How MS flow create pdf from sharepoint list item

Step 6: Create Html file in the OneDrive Business

Now in this step, we will create a file with HTML extension in OneDrive Business, so click on the Next step and select Create file action. Then provide the folder path, the file name with extension, and provide file content from the dynamic content.

How Microsoft flow create pdf from sharepoint list item
How Microsoft flow create pdf from sharepoint list item

Step 7: Convert HTML file to pdf

Now we will convert the above HTML file to pdf, so click on the Next step and select Convert file action. Then provide the file from the dynamic content and target type to pdf.

How Power Automate create pdf from sharepoint list item
How Power Automate create pdf from sharepoint list item

Step 8: Create a pdf file in OneDrive Business

Now we will create a pdf file, so click on the Next step and select Create file action then provide the folder path, file name, and file content from the dynamic content.

How to create pdf from sharepoint list item using Power Automate
How to create pdf from sharepoint list item using Power Automate

Once your flow is ready, run the Microsoft flow manually.

See also  SharePoint Online Button and Call to action Web Part

Step 9: Run the flow

Now click on Save and run the flow manually, and you can see the pdf file get created in the OneDrive for business. Then provide the folder path, file name, and file content from the dynamic content.

How to create pdf from sharepoint list item using Microsoft flow
How to create pdf from sharepoint list item using Microsoft flow

In this Power Automate tutorial, we learned about power automate create pdf from sharepoint list.

You may like the following Power Automate tutorials:

  • Microsoft Flow or PowerAutomate: Trigger email based on user input
  • Get a push notification when a new file is added to OneDrive for Business
  • Save Twitter Tweets in SharePoint Online list using Microsoft Flow
  • Get daily weather reports delivered to your email and phone using Power Automate
  • Send myself a reminder in 10 minutes in Power Automate
  • Microsoft flow parsing select and expand failed get manager v2
  • Log Gmail emails to a Google Sheet using Power Automate
  • Save tweets to a Google Sheet using Power Automate (Flow)
  • Convert Email to PDF using Microsoft flow or Power Automate
  • SharePoint custom list example

Please leave your feedback. I hope this article has been helpful for you so bookmark this blog as new articles will be posted regularly. Here, we learned how to convert a SharePoint list item to pdf using Microsoft flow or Power Automate.

>