Hi @Darkjedithx ,
So the HTML route is pretty tedious, especially so if you don't know HTML. You could also go the MSWord layout route and use SharePoint doc library properties to inject data, then convert that to PDF - but that's a whole other process, and just as difficult if you don't know SharePoint or MSWord that well either - so let's look at the HTML for now.
The HTML code provides you with a way to create a layout for a document (typically a web page). You use it to construct your PDF layout (headers, tables, lines, etc.).
You can then inject your data into this layout code so that your data appears in the tables or wherever you want it in the layout.
Once you have the complete code (layout + data), you would need to send it to Power Automate to save as an HTML file, then then you can use the OneDrive converter to convert that file to PDF and email it to the user for you.
So, let's say part of your PDF is a table that looks like this; (hopefully the forum table is readable)
In your app, you have the data for the "Problem" and "Solution" areas sitting in text input controls - let's call them ProblemTextInput and SolutionTextInput - and also the email address of the user you want to send it to - but no nice layout for the PDF.
So you construct the layout using an HTML string, and then you break the string to insert your data wherever you need it - eg:
Set(varHTML, "
<table style='border-collapse: collapse; width: 100%; height: 412px;' border='1'>
<tbody>
<tr style='height: 18px;'>
<td style='width: 50%; height: 18px;'>Problem</td>
<td style='width: 50%; height: 18px;'>Solution</td>
</tr>
<tr style='height: 394px;'>
<td style='width: 50%; height: 394px;'>" & ProblemTextInput.Text & "</td>
<td style='width: 50%; height: 394px;'> & SolutionTextInput.Text & "</td>
</tr>
</tbody>
</table>
");
You create a Flow that triggers from PowerApps and takes the HTML string and an email address string. You can then send these to Power Automate from PowerApps. If take a look at the link I posted, you can convert the HTML string to an HTML file, then you can convert the HTML file to a PDF, then email it off to whoever needs it.
The tough part is designing the layout, especially if you've never used HTML before - It would probably be easier if you could start with your blank PDF layout already in HTML somehow - if it's in MSWord format that would help as you can save as HTML, but if not you need to convert the entire PDF layout to HTML and bring it into PowerApps as a string. Have you got that PDF layout in a file format already that you can use?
WBP
