Creating a PDF from a Powerapps

(0) Share

Report

Posted on by G0Springs

134

I have a PDF that I want to be automatically filled by a Power Automate flow.

Pulling information from one (of multiple) data verses.

Is it possible to create a flow like this in Power Automate? If so may I ask for guidance on how to make a functional flow for this.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-yujincui-msft on at

Like (1)

Report
Hi @G0Springs ,

Do you want to edit PDF in Flow with the parameters passed by Power Apps?
I am afraid that there is no directly way to achieve this in Power Apps and Power Automate currently.
Is it necessary to edit an existing PDF instead of creating it from scratch?

I have made a test for your reference.
I wrote HTML in Power Apps and converted it to PDF in Flow.

1. Create a flow.
2. Create a App.
3. Add a HtmlText Control and apply the following formula on its HtmlText property as:
"<br><strong> Title: </strong>"& "<br><table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th> fieldname</th> <th> fieldname </th> <th> fieldname </th><th> fieldname </th><th> fieldname </th> </tr>"& Concat(yourdatasourcename,"<tr> <td>" & fieldname(.Value) & " </td> <td>" & fieldname(.Value) & " </td> <td>" & fieldname(.Value) & " </td> <td>" & fieldname(.Value)& " </td> <td>" & fieldname(.Value) & " </td> </tr>")& "</table><br>"& "<strong> MapTrackTest: </strong>"& "<br><table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>Title</th> <th> MapLabel </th> <th> MapLongitude </th><th> MapLatitude </th><th> MapColor </th> </tr>"& Concat(MapTrackTest,"<tr> <td>" & Title & " </td> <td>" & MapLabel & " </td> <td>" & MapLongitude & " </td> <td>" & MapLatitude& " </td> <td>" & MapColor & " </td> </tr>")& "</table>"
4. Add a Button Control and apply the following formula on its OnSelect property as:
YourFlowname.Run(HtmlText1.HtmlText)
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
G0Springs 134 on at

Like (0)

Report

Thank you this is exceptionally useful, I will let you know, in hopefully the next couple of days, whether this has worked for what I want to achieve 😊

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (1)

Report

Hi @G0Springs ,

Did you solve your problem? May I ask if this solution was helpful to you?

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Verified answer

G0Springs 134 on at

Like (0)

Report

I used elements of your advise in my final solution, but I pivoted from my method trying to create a PDF. As initially I tried creating a HTML table first and converting it into a PDF like so many guides said to and instead created a Word Document and converted that into a PDF, like the following:
Repeating the scope for each dataverse and also a using the Append to array variable action for the repeating rows of the table in word.
For more information on the method I used, the following was a useful resource: https://www.strategy365.co.uk/populating-word-document-with-microsoft-power-automate/

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report

Hi @G0Springs ,

Glad to see you solved the problem.
You could mark your solution as a 'solution' to close the case.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No