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 / Need help extracting d...
Power Automate
Answered

Need help extracting data from a table in email and post it sharepoint list

(0) ShareShare
ReportReport
Posted on by

I need to design a flow that will extract data from a Table in a email and save it into a SharePoint list. Attached the sample Table as we are getting via email.  Anyone kindly help on this.tempsnip.png

Categories:
I have the same question (0)
  • PrasadAthalye Profile Picture
    on at

    You can use HTML to text action to convert it to text format and then parse it using Substring function... See example below...

     

    PrasadAthalye_0-1622587687877.png

     

     

  • Santhosh_V_26 Profile Picture
    on at

    Hi Prasad,

     

    Below is my scenario, 

    Santhosh_V_26_0-1622619074362.png

     We're getting an email for every new high priority ticket. From that I need to extract data from the table present in the email and the need to create a new item in a share point list.

     

    Ex: I had already created column in the list for all the values in the first column of the table present in the email like below,

    Santhosh_V_26_1-1622619394709.png

    So I need help for extracting all data from the table present in the email and put it into the SharePoint list including the current progress data.

     

    Looking forward for help on this scenario 🙁

    Thanks.

  • PrasadAthalye Profile Picture
    on at

    Did you check my response above? Did you try HTML to text approach?

  • Santhosh_V_26 Profile Picture
    on at

    Yes, I had tried html to text but afterwards I was unable to split the things as expected ☹️

  • PrasadAthalye Profile Picture
    on at

    Can you send me some of the text from HTML to Text output ?

  • Santhosh_V_26 Profile Picture
    on at

    2021-05-12 06:49:58

    ABC- High Impact Outage notification

    Severity (P1/P2)

    P1

    Account Name

    XYZ

    Incident Number

    INC123456432


    Start Time of Incident (in IST)

    2021-05-31 06:49:58

    Impacted Region/Site

    Yet to be determined

    Service(s)/App(s) Impacted

                                         Mailhost Server Not Sending Messages from
    QST

    Assigned Technical Team

    Messaging Collaborative Services - XYZ

    Issue Description

                                         Mailhost Server Not Sending Messages from
    XYZ

    No of Users Impacted

    Yet to be determined

    Business Impact

                                         Mailhost Server Not Sending Messages from
    QST

    Estimated time to Resolve

    Yet to be determined

     

    Current Progress

    User is not able to send emails from - Sender IP - 12.35.57.23 Sender email
    address - abcf@drf.org

    Checked Mailhost servers are working fine and issue seems to be happening from
    application server end. Would suggest you to raise a Service request to get the
    sender IP address (12.35.57.23) whitelisted on Mailhost servers. It appears
    some connections from that address as being placed in the suspect list which
    throttles the connection.

    The mail is coming from a publicIP address - which we don't have these
    set up to accept all the messages from.  At some point, that public Amazon IP
    was listed as a suspect IP which limits the mail capabilities of the sending IP
    through Mailhost. Getting IPO/Security to review the IP address and approve
    white listing will avoid that throttling.

    Asked user to raise a Service request to get the sender IP address whitelisted
    on Mailhost servers and IPO needs to review why a public IP is attempting
    to send mail - and if that is approved or not.

    Keeping ticket in pending status while we discuss further with ETS to get this
    P1 downgraded.

     

     

     

    NOTE: Please reply to all so that my team can respond to your request when I am
    off shift.

     

    Regards,

    Santhosh Kumar V

    xyz 

    ABC Company.

     

    M +223983938

    xyz@abc.com

     

    ABC Technology India Private Limited - 9th Floor, Block-D , avcb
    ABC Technology Company -- This message is transmitted to you by or on behalf of
    ABC Technology Company or one of its affiliates. It is intended exclusively for
    the addressee. The substance of this message, along with any attachments, may
    contain proprietary, confidential or privileged information or information that
    is otherwise legally exempt from disclosure. Any unauthorized review, use,
    disclosure or distribution is prohibited. If you are not the intended recipient
    of this message, you are not authorized to read, print, retain, copy or
    disseminate any part of this message. If you have received this message in
    error, please destroy and delete all copies and notify the sender by return
    e-mail. Regardless of content, this e-mail shall not operate to bind ABC
    Technology Company or any of its affiliates to any order or other contract
    unless pursuant to explicit written agreement or government initiative expressly
    permitting the use of e-mail for such purpose.

  • Santhosh_V_26 Profile Picture
    on at

    Prasad,

     

    The above is the HTML to Text Output in my scenario. I need to extract for each data like Incident number, severity etc... including the current progress. And also i need remove the remove the text after the current progress updates.

     

    Thanks for time looking into this 🙂

  • Verified answer
    Paulie78 Profile Picture
    8,424 Moderator on at

    Hi @Santhosh_V_26 

    Check out this video I just finished to see if it helps you:

    https://youtu.be/IwRKWaTnl3U

     

    Blog: tachytelic.net

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

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

  • Santhosh_V_26 Profile Picture
    on at

    Hey Paul,

    Thank you so much, Finally I got the Solution and Implemented Successfully 😊

  • Paulie78 Profile Picture
    8,424 Moderator on at

    Great news - well done!

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
David_MA Profile Picture

David_MA 247 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 164 Super User 2026 Season 2

#3
trice602 Profile Picture

trice602 138 Super User 2026 Season 2

Last 30 days Overall leaderboard