Power Platform Community Forum Thread Details

Hi everyone,

I've got an excel spreadsheet laid out in a table with all of the data I need to populate a new .pdf form.

I want each row to populate into its own .pdf file from a .pdf form template (its file name will be one of the cells from the row in the spreadsheet).

I see a few different tutorials on how to convert that row into an html form, or a generic .pdf file, but not one that will put the data into a pre-made .pdf form template.

Any insight into this would be greatly appreciated!

Thanks,

Zack

Categories:

Building flows

Hi @Anonymous,

You have a community post that provides a solution on how to pass excel to PDF here. However, from y understanding this would pass the entire excel sheet into PDF.

To insert each row into a separate PDF fie you would need to use an action like List rows present in a table, to get all the rows of your excel spreadsheet and then use an apply to each to convert each of the rows to a PDF file.

In regards to saving into a PDF form Template, I'm not currently aware that this is possible in Power Automate. What I know is possible is to fill a Microsoft Word template instead, and then convert that file into a PDF file. You have this community post here which can be more useful for your specific scenario.

So it would be a matter of instead of populating each row into a PDF, first populate it to a word template and then convert it to PDF.

Hope this helps!

Regards,

Ricardo