
Announcements
Hi everyone,
I've scoured this community and videos and more and can't find anything that is similar to what I'm experiencing. I "think" I know the issue but I don't know how to fix it.
I have a simple HTML table that I'll fill with SP Lists and Collections....that works without a problem.
The issue that I'm having is when I send the htmlControl.htmlText to PowerAutomate, the right side of the table stays "open".
My PowerAutomate is quite simple and works:
PowerApps (V2) trigger with 2 text fields: HTMLCONTENT & FILENAME
ODB Create File - temp.html with HTMLCONTENT
ODB Convert File with ID from above to PDF
SP Create File - FILENAME.pdf
I ran the code in W3 Schools editor and I get exactly what I'm expecting....except that at the top it says result size 825x753...I think that's the root of my issue...that's wider than a portrait letter paper size which is the limitation of this Flow.
Anywho, I'm attaching 3 files here: 1) HTML Generated File - perfect, 2) Generated PDF - open table, 3) Size report from W3.
My code is below....I've gone over it for the past 2 days and can't find anything wrong.
Any help is appreciated!
Cheers,
Louis
----
CODE:
"
<html>
<head>
</head>
<body>
<table width='500px' border='0' cellpadding='2' style='border-collapse:collapse;'>
<tr>
<td colspan='6' style='text-align:center;font-weight:bold;font-size:16px;border:1px solid black'>STATION 1</td>
</tr>
<tr>
<td colspan='6' style='font-size:14px;text-align:left;font-weight:bold'>PUMP</td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-right:1px solid black;border-top:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>UNIT:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;font-weight:bold;background-color:#efefef'>RADIO</td>
<td style='width:10px'></td>
<td style='width:200px'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>OFFICER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>DRIVER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-bottom:1px solid black;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='font-size:14px;text-align:left;font-weight:bold'>RESCUE</td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-right:1px solid black;border-top:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>UNIT:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;font-weight:bold;background-color:#efefef'>RADIO</td>
<td style='width:10px'></td>
<td style='width:200px'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>OFFICER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>DRIVER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-bottom:1px solid black;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='font-size:14px;text-align:left;font-weight:bold'>ADDITIONAL VEHICLE</td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-right:1px solid black;border-top:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>UNIT:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;font-weight:bold;background-color:#efefef'>RADIO</td>
<td style='width:10px'></td>
<td style='width:200px'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>OFFICER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>DRIVER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-bottom:1px solid black;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='height:20px'></td>
</tr>
<tr>
<td colspan='6' style='text-align:center;font-weight:bold;font-size:16px;border:1px solid black'>STATION 2</td>
</tr>
<tr>
<td colspan='6' style='font-size:14px;text-align:left;font-weight:bold'>PUMP</td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-right:1px solid black;border-top:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>UNIT:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;font-weight:bold;background-color:#efefef'>RADIO</td>
<td style='width:10px'></td>
<td style='width:200px'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>OFFICER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>DRIVER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'</td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-bottom:1px solid black;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='font-size:14px;text-align:left;font-weight:bold'>AERIAL</td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-right:1px solid black;border-top:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>UNIT:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;font-weight:bold;background-color:#efefef'>RADIO</td>
<td style='width:10px'></td>
<td style='width:200px'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>OFFICER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>DRIVER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-bottom:1px solid black;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='font-size:14px;text-align:left;font-weight:bold'>ADDITIONAL VEHICLE</td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-right:1px solid black;border-top:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>UNIT:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;font-weight:bold;background-color:#efefef'>RADIO</td>
<td style='width:10px'></td>
<td style='width:200px'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>OFFICER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>DRIVER:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td style='width:80px;font-size:14px;text-align:right;border-left:1px solid black'>FF:</td>
<td style='width:150px;font-size:14px;text-align:left'></td>
<td style='width:50px;font-size:14px;text-align:center;background-color:#efefef;border-top:1px solid #efefef'></td>
<td style='width:10px'></td>
<td style='width:200px;border-bottom:1px solid black'></td>
<td style='width:10px;border-right:1px solid black'></td>
</tr>
<tr>
<td colspan='6' style='border-left:1px solid black;border-bottom:1px solid black;border-right:1px solid black'></td>
</tr>
</table>
</body>
</html>
"
Generated HTML from PowerApps:
Generated PDF from PowerAutomate:
Size report from W3:
The basic issue is that the free/out-of-the-box PDF generator available in Flow is not that great. When I first started using it I would get page spill as well and tried many ways to adjust this. I just gave up in the end.
What you could try first is to use %'s instead of px for your widths, ie
Instead of this
style='width:80px
use this
style='width:18%
There is a 3rd Party platform which offers features that can fix all the issues you may have with PA PDFs called Encodian. They have a Free 50 actions/Mth subscription if you don't do a lot of PDFs. I've never used them nor am I associated with them in any way, just like what they have to offer and would use them if the need arose.