Solved: Convert to PDF

Anonymous · ‎02-16-2021

Hello everyone,

I have an issue now. I'am building flow to convert data from sharepoint list to PDF.

The flow works good, so it converts html template to PDF, but I can't see information from sharepoint list, for example names, phone numbers etc.

The question is how can I map/add/syncronize all information which are on the list of sharepoint in the PDF file.

Regards

anupam8555 · ‎02-16-2021

Hi @Anonymous ,

You need to create an HTML file with data you are getting from sharepoint list. Than you need to use same file to create pdf. Please see below :

Here on first , there is function "concate()" is used. You can specify HTML inside this and place your dynamic data as well .

concat('<!DOCTYPE html>
<html>
<head>Test Report
</head>
<body>
<center>
<b> Monthly Report </b>
<br>
<EM>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</EM>
</body>
</html>
')

You can add your list data inside this concat function and export as PDF.

Thanks

Anupam

(please like/resolve if it helps you)

View solution in original post

anupam8555 · ‎02-16-2021

Hi @Anonymous ,

You need to create an HTML file with data you are getting from sharepoint list. Than you need to use same file to create pdf. Please see below :

Here on first , there is function "concate()" is used. You can specify HTML inside this and place your dynamic data as well .

concat('<!DOCTYPE html>
<html>
<head>Test Report
</head>
<body>
<center>
<b> Monthly Report </b>
<br>
<EM>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</EM>
</body>
</html>
')

You can add your list data inside this concat function and export as PDF.

Thanks

Anupam

(please like/resolve if it helps you)

Anonymous · ‎02-17-2021

Hello @anupam8555 ,

thank you for your answer, but I don't understand how I can add my data list so, that I can see it than in pdf-file like:

First name: James

Last name: Peters

Email: jp@gmail.com

Could you explain me it with my example, if you have time?

Here below is my simple html code:

<!DOCTYPE html>
<html>
<head>
<title>Main information</title>
</head>
<body>

<h1>Main information</h1>
<p>First name:</p>
<p>Last name:</p>
<p>Email:</p>

</body>
</html>

Anonymous · ‎02-17-2021

Thank you @anupam8555 ,

I solved the problem)

Regards

anupam8555 · ‎02-17-2021

@Anonymous - Glad to hear

Convert to PDF

Helpful resources

Join us for Microsoft Power Platform Conference

Register for a Free Workshop

Help make Flow Design easier