Export\Convert csv to pdf

[praveen1]

Hi All,

I am very new to power automate and trying to convert or export csv to pdf.

Tried exploring multiple blogs but could not achieve it.

Can some one please help me with the steps to achieve this.

Thanks in advance

[SamLed]

Hi @praveen1,

Basically, you want to convert a CSV data file to a PDF file with that data formatted. I would suggest including an HTML intermediate in it.

You format your CSV data into an HTML file using the "Create HTML Table" action, then convert that file to PDF.

2 links for inspiration:

Here to convert CSV to HTML: Solved: Create html table from csv file - Power Platform Community (microsoft.com)

Here to convert HTML to PDF: Power Automate Create PDF + 11 Examples - SPGuides

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

[praveen1]

Hi @SamLed ,

Thanks for the reply I have seen the post. The title is mentioned as csv to html but they are using Json format and then converting it into HTML.

My scenario is I am actually using power automate in power bi which will generate a pdf with all data rather than a screen shot of the page which is not possible.

Hence I created a flow which will create a csv file with all the data and save it one drive and then trying to convert the generated csv file into pdf.

[SamLed]

Hi,

If you are creating a CSV file, have you considered creating directly in HTML rather than CSV, because HTML can be converted to PDF while CSV cannot.

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

[AlexEncodian]

@praveen1 

You can do this using Encodian's Convert Excel action

----

*Encodian Flowr is a Standard Power Automate connector with 100+ actions to supercharge flow builds. Conversion, merging, splitting, OCRing, data extraction, QR/Bar codes, searching and much more. And we just added "Utility" actions, which are almost free to use and accelerate solution builds and remove maintenance overheads with actions like Extract text between values, extract URLs, extract email addresses, Password/GUID/HMAC creation, escaping/unescaping HTML, parsing HTML tables, etc.

[praveen1]

I tried this but its asking me for connection string and api details which I am not aware of could you please guide me

[SamLed]

Hi,

Of course, Encodian is a paid solution, so you have to subscribe at Encodian, the free version allows you to perform 50 actions max per month: Encodian Flowr for Microsoft Power Automate and Azure Logic Apps

Once done, you'll get required API key.

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

[SamLed]

Hi,

If you want to do it yourself, you'll have to convert your CSV to JSON, JSON to HTML and HTML to PDF, here's how to perform these steps:

• Convert CSV to JSON:

Get header names expression: split(first(split(outputs('Get_file_content_using_path')?['body'],decodeUriComponent('%0D%0A'))),',')

Apply to each from expression: skip(split(outputs('Get_file_content_using_path')?['body'],decodeUriComponent('%0D%0A')),1)

Inside Apply to each, add a Do until:

Next to Do until, compose JSON object and next to Apply to each, compose JSON array:

Full view:

• Convert JSON to HTML:

Here I'm using Create HTML table action:

Then save outputs to file:

• Convert HTML to PDF:

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

[Dave1968777]

Hi @praveen1 ,

PDFco offers a solution for converting CSV files to PDF with ease. By integrating PDFco with Power Automate, you can automate this process and simplify your workflow. This combination provides a reliable and efficient way to manage your document conversion needs. 

To assist you further, we’ve prepared a sample tutorial that demonstrates how to use PDFco and Power Automate for converting CSV to PDF. You can find the sample tutorial at the following link: https://pdf.co/convert-csv-excel-to-pdf-using-power-automate-cloud

Should you have any questions or require additional guidance, please don’t hesitate to reach out to us at support@bytescout.com. We’re here to help you make the most of this powerful solution. 

We look forward to assisting you in achieving your goals efficiently and effectively. 

Have a wonderful day!