web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Not sure how to extrac...
Power Automate
Unanswered

Not sure how to extract lines of text from an email

(0) ShareShare
ReportReport
Posted on by 118

Hi everyone,

I receive these emails from the Ministry. I am trying to extract the apprentice Last Name, Client ID, Milestone and Payment amount rows from page 2.

Some things to note:

  • Sometimes there is only one name, sometimes there are pages of names. That being said, splitting the body of the email into lines and retrieving those lines will not work considering it fluctuates. 
  • The names on the email will always be different, so there is no pattern you can hold on to.

Do you think there are solutions to this?


Thanks community!

Categories:
I have the same question (0)
  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @soy 

     

    Pls try the technique mentioned in my blog to extract data from html table in email body to array:

    Extract data from html table from email body in Power Automate - Microsoft Power Platform (manish-solanki.com)

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

     

  • soy Profile Picture
    118 on at

    Hi there,

    Thanks for your response.

    I am at Step 4, but the output seems like it is missing the actual table. It only extracted the bottom part of the email.

    soy_0-1710255693017.png

     




    "<table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\" width=\"100%\" style=\"width:100.0%\"><tbody><tr><td valign=\"top\" style=\"padding:0in 24.0pt 6.75pt 24.0pt\"><p class=\"MsoNormal\"><span style=\"font-size:11.5pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D\"><a href=\"https://www.ontario.ca/page/about-ontario\" target=\"_blank\"><span style=\"color:#096BC7; text-decoration:none\">about Ontario</span></a>&nbsp; &nbsp; &nbsp;<a href=\"https://www.ontario.ca/page/accessibility\" target=\"_blank\"><span style=\"color:#096BC7; text-decoration:none\"> accessibility&nbsp;</span></a> &nbsp; &nbsp;<a href=\"https://news.ontario.ca/newsroom/en\" target=\"_blank\"><span style=\"color:#096BC7; text-decoration:none\"> news</span></a>&nbsp; &nbsp; &nbsp;<a href=\"https://www.ontario.ca/page/privacy-statement\" target=\"_blank\"><span style=\"color:#096BC7; text-decoration:none\"> privacy</span></a>&nbsp; &nbsp; &nbsp;<a href=\"https://www.ontario.ca/page/terms-use\" target=\"_blank\"><span style=\"color:#096BC7; text-decoration:none\">terms of use</span></a><br><br><a href=\"https://www.ontario.ca/page/copyright-information\" target=\"_blank\"><span style=\"color:#096BC7; text-decoration:none\">© King's Printer for Ontario, 2023-24</span></a> </span><span style=\"font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D\"><br><br></span><span style=\"font-size:10.5pt; font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D\">You are receiving this email from <a href=\"mailto:apprenticeship@ontario.ca\">apprenticeship@ontario.ca</a> because you are a participant in Ontario's apprenticeship system. To ensure delivery to your inbox (and not to your junk or bulk mail folders), add <a href=\"mailto:apprenticeship@ontario.ca\">apprenticeship@ontario.ca</a> to your address book.<br><br><strong><span style=\"font-family:&quot;Open Sans&quot;,sans-serif\">Please do not reply to this email - this mailbox is not monitored.</span></strong> If you are not the intended recipient of this email, please delete this email from your email inbox. </span><span style=\"font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D\"></span></p></td></tr></tbody></table>"
  • soy Profile Picture
    118 on at

     

    <html><head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style>
    <!--
    @font-face
    	{font-family:Helvetica}
    @font-face
    	{font-family:Wingdings}
    @font-face
    	{font-family:"Cambria Math"}
    @font-face
    	{font-family:Aptos}
    @font-face
    	{font-family:"Open Sans"}
    @font-face
    	{font-family:Georgia}
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    	{margin:0in;
    	font-size:12.0pt;
    	font-family:"Aptos",sans-serif}
    h1
    	{margin:0in;
    	text-align:center;
    	font-size:1.0pt;
    	font-family:"Helvetica",sans-serif;
    	color:#222222;
    	font-weight:bold}
    h3
    	{margin:0in;
    	font-size:15.0pt;
    	font-family:"Helvetica",sans-serif;
    	color:#444444;
    	font-weight:bold}
    a:link, span.MsoHyperlink
    	{color:blue;
    	text-decoration:underline}
    span.Heading1Char
    	{font-family:"Aptos Display",sans-serif;
    	color:#0F4761}
    span.Heading3Char
    	{font-family:"Aptos",sans-serif;
    	color:#0F4761}
    .MsoChpDefault
    	{font-size:10.0pt}
    @page WordSection1
    	{margin:1.0in 1.0in 1.0in 1.0in}
    div.WordSection1
    	{}
    ol
    	{margin-bottom:0in}
    ul
    	{margin-bottom:0in}
    -->
    </style></head><body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word"><div class="WordSection1"><p class="MsoNormal">&nbsp;</p><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="max-width:6.25in"><tbody><tr><td valign="top" style="background:white; padding:0in 6.0pt 0in 6.0pt"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="max-width:6.25in"><tbody><tr><td valign="top" style="padding:0in 6.0pt 0in 6.0pt"></td></tr></tbody></table></div><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%"><tbody><tr><td width="600" valign="top" id="templateBody" style="width:6.25in; padding:6.0pt 6.0pt 6.0pt 6.0pt"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="max-width:6.25in"><tbody><tr><td valign="top" style="padding:0in 6.0pt 0in 6.0pt"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; background:black"><tbody><tr><td valign="top" style="padding:0in 0in 0in 0in"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%"><tbody><tr><td valign="top" style="padding:0in 0in 0in 0in"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif"><a href="https://www.ontario.ca/page/government-ontario" target="_blank"></a></span><a href="https://www.ontario.ca/page/government-ontario" target="&quot;_blank&quot;"><img border="0" width="133" height="53" src="cid:attachedimage1" align="left" alt="ontario_logo" title="" style="width:1.3888in; height:.5555in"></a><a href="https://www.ontario.ca/page/government-ontario" target="_blank"></a><span style="font-family:&quot;Arial&quot;,sans-serif"></span></p></td></tr></tbody></table></td></tr></tbody></table><p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:&quot;Arial&quot;,sans-serif">&nbsp;</span></p><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; min-width:100%"><tbody><tr><td valign="top" style="padding:6.75pt 6.0pt 6.0pt 6.0pt"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%; max-width:100%; min-width:100%"><tbody><tr><td valign="top" style="padding:0in 13.5pt 6.75pt 13.5pt"><h1 align="left" style="text-align:left"><span style="font-size:18.0pt; font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">Achievement Incentive </span></h1></td></tr></tbody></table></td></tr></tbody></table><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">&nbsp;</span></p><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; min-width:100%"><tbody><tr><td valign="top" style="padding:6.75pt 6.0pt 6.0pt 6.0pt"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%; max-width:100%; min-width:100%"><tbody><tr><td valign="top" style="padding:0in 13.5pt 6.75pt 13.5pt"><p class="MsoNormal"><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">The Achievement Incentive is a grant program established to encourage employers to train apprentices toward program completion and trade certification. The program offers up to $17,000 for milestones completed by their apprentices. The milestone payments include: <br><br>Registration: </span></p><ul type="disc"><li class="MsoNormal" style="color:#4D4D4D"><span style="font-family:&quot;Open Sans&quot;,sans-serif">$1,000 registration payment for each newly registered apprentice to the ministry who is under the age of 25 and/or self-identifies as part of an under-represented or equity-deserving group (for a maximum of $2,000, if applicable).</span></li></ul><p class="MsoNormal"><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">In-Class Training Progression: </span></p><ul type="disc"><li class="MsoNormal" style="color:#4D4D4D"><span style="font-family:&quot;Open Sans&quot;,sans-serif">$1,000 milestone payment for each level of in-class training completed, up to four levels of schooling (where applicable).</span></li><li class="MsoNormal" style="color:#4D4D4D"><span style="font-family:&quot;Open Sans&quot;,sans-serif">An additional $1,000 milestone payment for each apprentice under the age of 25 and/or apprentice that self-identifies as being part of an under-represented or equity-deserving group (for a maximum of $12,000, where applicable).</span></li></ul><p class="MsoNormal"><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">Completion: </span></p><ul type="disc"><li class="MsoNormal" style="color:#4D4D4D"><span style="font-family:&quot;Open Sans&quot;,sans-serif">$1,000 milestone payment when your apprentice achieves the highest certification in their trade, either a Certificate of Apprenticeship or a Certificate of Qualification.</span></li><li class="MsoNormal" style="color:#4D4D4D"><span style="font-family:&quot;Open Sans&quot;,sans-serif">An additional $1,000 for each apprentice under the age of 25 and/or apprentice that self-identifies as being part of an under-represented or equity-deserving group (for a maximum of $3,000).</span></li></ul><p class="MsoNormal"><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">&nbsp;</span></p><h3>List of apprentices</h3><p class="MsoNormal"><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D"><br>According to ministry records, you are eligible for this payment for the apprentices listed below: </span></p><table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" width="100%" style="width:100.0%"><tbody><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><b><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">Last Name</span></b></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><b><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">Client ID</span></b></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><b><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">Milestone</span></b></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><b><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">Payment Amount</span></b></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">CHAPMAN</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">2848530</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Level 1</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$1000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">CONWAY</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">2748148</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Level 2</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$2000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">HAMELIN</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">1000006651</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Registration</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$1000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">HIRD</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">3030483</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Level 1</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$2000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">LESLIE</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">3099560</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Level 1</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$2000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">LO</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">3085211</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Registration</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$1000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">NEWMARCH</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">3082942</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Level 1</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$3000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">QUAN</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">3077094</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Level 1</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$2000</span></p></td></tr><tr><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">SUNDIN</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">1000006744</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">Registration</span></p></td><td style="padding:6.0pt 6.0pt 6.0pt 6.0pt"><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">$1000</span></p></td></tr></tbody></table><p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D"><br>You have already completed the online application and have been confirmed as eligible for the grant. If the information we have listed above is correct, you do not need to take any further action. The funds will be deposited into the account you have on file with the ministry in 2-4 weeks. If there are any errors in the information above, please contact the Employment Ontario Contact Centre at: 1-800-387-5656 / <a href="mailto:contactEO@ontario.ca"><span style="color:#096BC7; text-decoration:none">contactEO@ontario.ca</span></a> as soon as possible. Recipients of the grant may be subject to a program audit. </span></p><h3>Ministry contact info</h3><p class="MsoNormal"><span style="font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D"><br>If you have any questions about the program, or about completing the application form, please contact the Employment Ontario Contact Centre at: 1-800-387-5656 / <a href="mailto:contactEO@ontario.ca"><span style="color:#096BC7; text-decoration:none">contactEO@ontario.ca</span></a>. </span></p></td></tr></tbody></table></td></tr></tbody></table><p class="MsoNormal"><span style="font-family:&quot;Arial&quot;,sans-serif">&nbsp;</span></p><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; background:#EDEDED; min-width:100%"><tbody><tr><td valign="top" style="padding:6.75pt 6.0pt 6.0pt 6.0pt"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%; max-width:100%; min-width:100%"><tbody><tr><td valign="top" style="padding:9.0pt 24.0pt 15.0pt 24.0pt"><h1 align="left" style="text-align:left"><span style="font-size:15.0pt; color:#4D4D4D">Ministry of Labour, Training and Skills Development&nbsp;</span></h1><p class="MsoNormal"><span style="font-size:13.5pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D">Employment and Training Division</span><span style="font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D"><br></span><span style="font-size:13.5pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D">Program Delivery Support Branch</span><span style="font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D"> </span></p></td></tr></tbody></table></td></tr></tbody></table><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%"><tbody><tr><td valign="top" style="padding:24.0pt 6.0pt 6.0pt 6.0pt"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%"><tbody><tr><td valign="top" style="padding:0in 24.0pt 6.75pt 24.0pt"><p class="MsoNormal"><span style="font-size:11.5pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D"><a href="https://www.ontario.ca/page/about-ontario" target="_blank"><span style="color:#096BC7; text-decoration:none">about Ontario</span></a>&nbsp; &nbsp; &nbsp;<a href="https://www.ontario.ca/page/accessibility" target="_blank"><span style="color:#096BC7; text-decoration:none"> accessibility&nbsp;</span></a> &nbsp; &nbsp;<a href="https://news.ontario.ca/newsroom/en" target="_blank"><span style="color:#096BC7; text-decoration:none"> news</span></a>&nbsp; &nbsp; &nbsp;<a href="https://www.ontario.ca/page/privacy-statement" target="_blank"><span style="color:#096BC7; text-decoration:none"> privacy</span></a>&nbsp; &nbsp; &nbsp;<a href="https://www.ontario.ca/page/terms-use" target="_blank"><span style="color:#096BC7; text-decoration:none">terms of use</span></a><br><br><a href="https://www.ontario.ca/page/copyright-information" target="_blank"><span style="color:#096BC7; text-decoration:none">© King's Printer for Ontario, 2023-24</span></a> </span><span style="font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D"><br><br></span><span style="font-size:10.5pt; font-family:&quot;Open Sans&quot;,sans-serif; color:#4D4D4D">You are receiving this email from <a href="mailto:apprenticeship@ontario.ca">apprenticeship@ontario.ca</a> because you are a participant in Ontario's apprenticeship system. To ensure delivery to your inbox (and not to your junk or bulk mail folders), add <a href="mailto:apprenticeship@ontario.ca">apprenticeship@ontario.ca</a> to your address book.<br><br><strong><span style="font-family:&quot;Open Sans&quot;,sans-serif">Please do not reply to this email - this mailbox is not monitored.</span></strong> If you are not the intended recipient of this email, please delete this email from your email inbox. </span><span style="font-family:&quot;Helvetica&quot;,sans-serif; color:#4D4D4D"></span></p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></div></td></tr></tbody></table></div></td></tr></tbody></table></div><p class="MsoNormal">&nbsp;</p></div></body></html>

    This is my output when I remove your code, and just put Body.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard