cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drnemer
Helper I
Helper I

HTML Text Box Formatting Issue + Export to PDF

Can anyone explain to me what is going wrong with my app?

 

I am trying to create a formatted HTML table, but there seems to be several issues going on in the finished product that I cannot discern.  I don't know why the HTML isn't taking the "whole" table I generate into PDF. And I don't know why I cannot format the table in HTML... 

 

What is going wrong?  Please help.

 

My HTML code is:

"<!DOCTYPE html>
<html>
<body>
<header><center><img src=https://i.imgur.com/kbBcrTP.png, width=160 height=100</center></header>
<p style='text-align:right'><font size=0.8 face=arial color=black>" & Today() & "</p>
<address><font size=0.8 face=arial color=black>
" & 'HOH Name'.Text & "<br> 
" & 'HOH Address'.Text & "<br>
" & 'HOH City, State ZIP'.Text & "<br>
</address>
<p><b><u><center><font size=0.8 face=arial color=black>Document Request Letter</center></u></b></p>

<p><font size=0.8 face=arial color=black>Dear Participant:</p>

<p><font size=0.8 face=arial color=black>Metro Housing|Boston is required to verify the incomes, expenses, and other information of applicants/participants for eligibility and continued occupancy in the rental assistance program.  In accordance with this obligation, you are required to supply the information requested below.</p> 

<p><font size=0.8 face=arial color=black>You must send or bring the requested documents/information to <u>1411 Tremont St, Boston, MA 02120</u>. The office is open daily from 8:45 AM to 5 PM. Please be aware that failure to submit the necessary documentation may result in the termination of your participation in the rental assistance program. If we do not receive the documents <b><u><font size=0.8 face=arial color=black>" & 'Due Date'.SelectedDate & "</b></u><font size=0.8 face=arial color=black>, we may begin the process of terminating you from the program.  We cannot accept pictures of these items. Please scan, fax, mail, email, or bring them into our office.</p>

<table border='1'; 
border-collapse: collapse;
width='100%'>" &
"<thead><tr><font size=0.8 face=arial Color=Black><th>Documents And Verifications</th><th>Member</th><th>Notes</th></thead>" &
"<tbody><font size=0.8 face=arial Color=Black>" &
Concat(ChecklistCol, "<tr><td>" & Label2 & "</td><td>" & Members & "</td><td>" & Notes & "</td></tr>") &
"</tbody></table>

<p><b><u><center><Font size=0.8 face=Arial color=black><Font size=0.8 face=Arial color=black>All requested documents must be submited and/or completed by " & 'Due Date'.SelectedDate & ".</center></u></b></p>

<p><font size=0.8 face=arial Color=Black>Your attention to this important matter is expected. If you have Any questions, please contact (617) 425-6611 Or gateway@metrohousingboston.org</p>

<p><Font size=0.8 face=Arial color=black>Sincerely,</p>

<p><font size=0.8 face=arial Color=Black>Metro Housing|Boston Leased Housing Department</p>


<footer><center><Font size=0.6667 face=Arial color=black>1411 Tremont Street, Boston, MA 02120-3401</center></footer>
<footer><center><Font size=0.6667 face=Arial color=black>Phone 617-859-0400 | Toll-Free 800-272-0990 | info@MetroHousingBoston.org | MetroHousingBoston.org</center></footer>

</body>
</html>
"

 

My Populating the table code is this (in case you are curious, this works fine for the HTML)

After Entering somethingAfter Entering somethingBlankBlank

 

This is for the conversion to PDF

 

DOCCHECKLIST.Run(Checklistbody.HtmlText, 'HOH Name'.Text)

 

The output of the PDF is in the attachment, the errors should be clear what is wrong, but I need help knowing what to do to fix it.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User III
Super User III

Hi @drnemer ,

If it is the image you are missing, it will not resolve on the URL the way it does in your HTML test box. The process is a lot more complex. Here is a good video from @ChinoDoesStuff on the way to do it.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

1 REPLY 1
WarrenBelz
Super User III
Super User III

Hi @drnemer ,

If it is the image you are missing, it will not resolve on the URL the way it does in your HTML test box. The process is a lot more complex. Here is a good video from @ChinoDoesStuff on the way to do it.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,634)