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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I want to extract HTML...
Power Automate
Answered

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

(1) ShareShare
ReportReport
Posted on by Tourist 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 

Categories:
Building flows
I have the same question (0)
  • Paulie78 Profile Picture
    Paulie78 8,422 Moderator on at

    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

  • Tourist Profile Picture
    Tourist 65 on at

    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>
  • Verified answer
    Paulie78 Profile Picture
    Paulie78 8,422 Moderator on at

    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
    Tourist 65 on at

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

  • pramodklal Profile Picture
    pramodklal 14 on at

    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>

  • Kanchan12 Profile Picture
    Kanchan12 8 on at

    kfk

  • prathamesh26 Profile Picture
    prathamesh26 18 on at

    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 - ^ "
    ]
  • prathamesh26 Profile Picture
    prathamesh26 18 on at

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

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans