Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 18DlTRtHTPwOeJ5TIAsRRx
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,030 Most Valuable Professional

Leaderboard
Loading started