Export\Convert csv to pdf

(0) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
praveen1 7 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
praveen1 7 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Dave1968777 4 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No