Skip to main content

Notifications

Community site session details

Community site session details

Session Id : y5RqG/bdgpKM9SC6oUDlOb
Power Automate - Building Flows
Answered

I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

Like (1) ShareShare
ReportReport
Posted on 15 May 2021 19:42:42 by 65

I want to extract HTML Table data which is coming in my Outlook mail to Parse JSON, the problem is it is embedded in the email body, and it has CSS too. So how can I extract the table values with their keys from that table to use ??

@Pstork1 @CFernandes @Paulie78 

  • prathamesh26 Profile Picture
    16 on 01 Mar 2024 at 09:46:17
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    @Paulie78 FYI - love your videos on YouTube, I am a subscriber!

  • prathamesh26 Profile Picture
    16 on 01 Mar 2024 at 09:45:04
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    Hi @Paulie78 

    I am stuck at the below filter array action output and now need to further extract accordingly. Could you please help me, I am stuck here.

    [
      "Job function code^ AMR 2871^ ",
      " SVP area^ CMC Development and Scaling - 008927^ ",
      "Department^ Chemistry Pilot Plant - 2871^ ",
      " Job Function Type^ Task^ ",
      " New jobfunction code^ OHS-Resp-API PILOTS^ ",
      " New SVP area^ ^ ",
      " New department^ CMC APIPilots - 533^ ",
      " New Job Function type^ ^ ",
      " New Job function title^ OHSRepresentative in CMC API Pilots^ ",
      " New Organisation^ ^ ",
      " New Applies to^Applies to all OHS representative in CMC API Pilots^ ",
      " Add/Remove Maintained by^^ ",
      " Maintained by^ ^ ",
      " Job Function modules^ NN-HS-MACHIN-PRE-INS - Add -NN-HS-EQUIP-REQUIRE - Add - ^ "
    ]
  • Kanchan12 Profile Picture
    8 on 15 Sep 2023 at 13:25:32
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    kfk

  • pramodklal Profile Picture
    14 on 31 Mar 2022 at 15:10:06
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    Hi @Paulie78  ,could you please share expression of Rows  explained in the video.

    could you please guide to store table content in Sharepoint list, table 1st row is heading but remaining rows could by dynamic or not fixed

    below is HTML 

    <table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse\">
    <tbody>
    <tr>
    <td width=\"208\" valign=\"top\" style=\"width:155.8pt; border:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">Error
    </p>
    </td>
    <td width=\"208\" valign=\"top\" style=\"width:155.85pt; border:solid windowtext 1.0pt; border-left:none; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">Instrument
    </p>
    </td>
    <td width=\"208\" valign=\"top\" style=\"width:155.85pt; border:solid windowtext 1.0pt; border-left:none; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">
    <span style=\"color:#002060\">Back-up Plan Name</span>
    </p>
    </td>
    </tr>
    <tr>
    <td width=\"208\" valign=\"top\" style=\"width:155.8pt; border:solid windowtext 1.0pt; border-top:none; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">
    <span style=\"color:#002060\">Backup Missing</span>
    </p>
    </td>
    <td width=\"208\" valign=\"top\" style=\"width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">
    <span style=\"color:#002060\">SGSI2MMSHP6D5</span>
    </p>
    </td>
    <td width=\"208\" valign=\"top\" style=\"width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">
    <span style=\"color:#002060\">SGSI2MMSHP6D5_Data_Auto</span>
    </p>
    </td>
    </tr>
    <tr>
    <td width=\"208\" valign=\"top\" style=\"width:155.8pt; border:solid windowtext 1.0pt; border-top:none; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">
    <span style=\"color:#002060\">Backup status is unknown</span>
    </p>
    </td>
    <td width=\"208\" valign=\"top\" style=\"width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">
    <span style=\"color:#002060\">SGSI2MMSHP6D522.test.com</span>
    </p>
    </td>
    <td width=\"208\" valign=\"top\" style=\"width:155.85pt; border-top:none; border-left:none; border-bottom:solid windowtext 1.0pt; border-right:solid windowtext 1.0pt; padding:0in 5.4pt 0in 5.4pt\">
    <p class=\"MsoNormal\">
    <span style=\"color:#002060\">NA</span>
    </p>
    </td>
    </tr>
    </tbody>
    </table>

  • Tourist Profile Picture
    65 on 16 May 2021 at 09:12:21
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    Thank you so much @Paulie78 . It resolved my issue😀😀

  • Verified answer
    Paulie78 Profile Picture
    8,407 Super User 2025 Season 1 on 16 May 2021 at 07:45:04
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    Hi @Tourist 

    Because you are a new member and there are somewhat advanced concepts involved in doing this, I made you a video:

    https://www.youtube.com/watch?v=f68e4RP2QTs

    See how you get on, if you get stuck I will post the code also for you.

     

    Blog: tachytelic.net

    YouTube: https://www.youtube.com/c/PaulieM/videos

    If I answered your question, please accept it as a solution 😘

  • Tourist Profile Picture
    65 on 16 May 2021 at 05:00:28
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    Hi @Paulie78 

    <html>
    
    <head>
     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
     <meta content="text/html; charset=iso-8859-1">
     <style type="text/css" style="display:none">
     <!--
     p {
     margin-top: 0;
     margin-bottom: 0
     }
     -->
     </style>
    </head>
    
    <body dir="ltr">
     
     <div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
     <table cellspacing="0" cellpadding="1" style="border-collapse:collapse">
     <tbody>
     <tr style="background-color:rgb(255,255,255)">
     <th
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Roll No</th>
     <th
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Name</th>
     <th
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Marks</th>
     <th
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     City</th>
     </tr>
     <tr style="background-color:rgb(255,255,255)">
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     101</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Ayush</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     10</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171); height:18px">
     Jaipur</td>
     </tr>
     <tr style="background-color:rgb(255,255,255)">
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     102</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Dushyant</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     20</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Jaipur</td>
     </tr>
     <tr style="background-color:rgb(255,255,255)">
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     103</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Rishika</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     5</td>
     <td
     style="width:120px; border-width:1px; border-style:solid; border-color:rgb(171,171,171)">
     Jaipur</td>
     </tr>
     </tbody>
     </table><br>
     </div>
     
     
    </body>
    
    </html>
  • Paulie78 Profile Picture
    8,407 Super User 2025 Season 1 on 15 May 2021 at 21:48:57
    Re: I want to extract HTML Table data which is coming in my outlook mail to Parse JSON

    Hi @Tourist 

     

    If you want help with your specific example, then it would be helpful if you could provide some sample HTML. In the mean time, I did a video on how to extract data from HTML emails

     

    Have a watch of that to get the general idea and then post a sample if you would be so kind.

     

    Paulie

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 179 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 161 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 143

Overall leaderboard
Loading started