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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract a data table f...
Power Automate
Unanswered

Extract a data table from an email with power automate desktop

(0) ShareShare
ReportReport
Posted on by

I receive emails daily that have information in the form of a data table, i have attached a sample of what it looks like.  Any suggestion how i would extract the data table into a data table variable or just take certain information from the datable since I don't need all the information.

datatablemail.PNG

Categories:
  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    Are these emails in HTML format?  Can you post a sample email body contents?

  • Natron26 Profile Picture
    on at

    Good Morning what do you need as far as the sample email body contents?

  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    the HTML - specifically the part that describes the table.

  • Natron26 Profile Picture
    on at

    How should i do that to make it easier for you?

  • Natron26 Profile Picture
    on at

    I was able to go through the emails and retrieve the data, i only need certain information.  My idea now is to pull the get the data and then use a regular expression to extract the wanted information. I'm not sure how to use regular expressions in Power automate yet.  Below is a sample of the information that will be coming through and all the email will be structured this way.  Can you help with creating a regular expression to pull the text that are in bold from the text string?  

     

     

     

    opportunity: CLMS – Natron Publications
    Account: Brady 101
    Contract Months : 42
    Subscription Term : Man
    Closed Date : 7/7/2023
    Total Contract Value : $45
    Owner : Kirk Cousins
    Billing Term :
    Billing Contact Name 1 : Aron Rogers
    Billing Contact Email 1 : nothing@yahoo.com

    Billing Contact Name 2 : Patrick Mahomes
    Billing Contact Email 2 :
    Email for Invoices : hello at yahoo.com
    Billing Mailing Address : 900 Half way house
    Client PO Number :

  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    You can certainly go the regexp route. I would think parsing the HTML is easier as you can address the DOM elements directly.

  • Natron26 Profile Picture
    on at

    Can you provide a workflow?

  • lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    Can you provide a sample HTML?

  • Natron26 Profile Picture
    on at

    How do i provide a HTML?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 227 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 213 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 151

Last 30 days Overall leaderboard