Hi All,
This is an urgent requirement and if anyone could cater to it i would really appreciate it. I have already built a flow that works absolutely fine in converting sharepoint list items to an html code and then to a PDF.
However, today a user generated a quote and due to the increase word count in one column the PDF cut out the data and thus the PDF is of no use i will be attaching a PDF for reference so that you guys can have a look and will be attaching the html code too.
i would want my html table to automatically resize based on higher word count in any column per say.
kindly help me resolve the issue this issue as it is very urgent.
below is the image of the pdf Generated , kindly look at the word count in Project Description column and see how the html table has broken. i would like to fix this issue where in increased word count of the column should not affect the table layout. i am using Onedrive connection for converting my html code to pdf.
please find the html code below the pdf
concat('<!DOCTYPE html>
<html>
<head>
<style>
table {
font-family: Arial;
border-collapse: collapse;
width: 100%;
font-size :15px;
}
td, th {
border: 1px solid black;
text-align: left;
padding: 5px;
font-size :15px;
}
img{
height:57px;
width:62px;
}
</style>
</head>
<body>
<img src="',variables('logo'),'">
<h1 style="text-align:center; font-family: Arial;">Global Analytics Center</h1>
<h2 style="text-align:center; font-family: Arial;">Work Agreement Quote</h2>
<table>
<tr>
<th>Quote Date</th>
<td>',formatDateTime(utcnow(),'dd-MM-yyyy'),'</td>
</tr>
<tr>
<th>Quote Validity</th>
<td>',triggerBody()?['Quotevalidtill'],'</td>
</tr>
<tr>
<th>Customer cross charge BU</th>
<td>',triggerBody()?['BillingBU'],'</td>
</tr>
<tr>
<th>Customer location</th>
<td>',triggerBody()?['CustomerLocation'],'</td>
</tr>
<tr>
<th>Project ID</th>
<td>',triggerBody()?['Title'],'</td>
</tr>
<tr>
<th>Project name</th>
<td>',triggerBody()?['ProjectName'],'</td>
</tr>
<tr>
<th>Project sponsor</th>
<td>',outputs('Compose_5'),'</td>
</tr>
<tr>
<th>GAC contact name</th>
<td>',outputs('Compose'),'</td>
</tr>
<tr>
<th>Project description</th>
<td>',triggerBody()?['WorkDescription'],'</td>
</tr>
<tr>
<th>resource skill description</th>
<td>',triggerBody()?['SkillSetRequired_x002f_GPP'],'</td>
</tr>
<tr>
<th>Resource type</th>
<td>',outputs('Compose_2'),'</td>
</tr>
<tr>
<th> vertical</th>
<td>',triggerBody()?['Function'],'</td>
</tr>
<tr>
<th>Costing (Yearly/monthly)</th>
<th></th>
</tr>
<tr>
<th></th>
<th></th>
<th>Year 1</th>
<th>Year 2</th>
<th>Year 3</th>
</tr>
<tr>
<th></th>
<th>Currency</th>
<td>',outputs('Compose_4'),'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th>General Cost</th>
<th>Payroll Cost</th>
<td>',triggerBody()?['PayrollCost'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>CBS charges</th>
<td>',triggerBody()?['CBScharges'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Rent</th>
<td>',triggerBody()?['Rent'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Common support cost</th>
<td>',triggerBody()?['Commonsupportcost'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Others (Employee fringes)</th>
<td>',triggerBody()?['Others_x0028_Employeefringes_x00'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
</tr>
<tr>
<th>Specific job need</th>
<th>Shift charge (Other than general shift)</th>
<td>',triggerBody()?['Shiftcharge_x0028_Otherthangener'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Travel</th>
<td>',triggerBody()?['Travel'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Training</th>
<td>',triggerBody()?['Training'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Subtotal</th>
<td>',triggerBody()?['Total_x0020_Transfer_x0020_Price'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Transfer Price Mark-up %</th>
<td>',outputs('Compose_10'),'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Transfer Price Mark-up amount </th>
<td>',triggerBody()?['Transfer_x0020_Price_x0020_Mark_0'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Total Transfer Price</th>
<td>',triggerBody()?['subtotal'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>GST %</th>
<td>',outputs('Compose_13'),'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>GST Amount</th>
<td>',triggerBody()?['GST_x0020_Amount'],'</td>
<td>--</td>
<td>--</td>
</tr>
<tr>
<th></th>
<th>Total cost to customer</th>
<td>',triggerBody()?['Total_x0020_cost_x0020_to_x0020_'],'</td>
<td>--</td>
<td>--</td>
</tr>
</table>
</html>')
