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 / 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:
I have the same question (0)
  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 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,474 Super User 2025 Season 2 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,474 Super User 2025 Season 2 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,474 Super User 2025 Season 2 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

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 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard