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 / List row from HTML tab...
Power Automate
Unanswered

List row from HTML table in outlook mail in excel table ehich exist in sharepoint

(0) ShareShare
ReportReport
Posted on by 43

Hi,

I am recieving emails which have HTML table with constant header,and I have excel file in my sharepoint.

what I need to list the row from each outlook email in my inbox in this excel file.

write now I made a flow who flow the emails and convert html to text and put all the text in each cell in all columns,

but I need to only put each cell from each column in the mail table to its corresponding table in excel file .
any suggestions?

Thanks in advance.

osama_ayoub_1-1687797752428.png

 

 

osama_ayoub_0-1687797604865.png

 

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

    @Nived_Nambiar

    @Ahammad_Riyaz
    Could you help me please in this problem ?

    Regards

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @osama_ayoub 

     

    So what you need is you have an html table and you want to add same html table in a excel file right ?

  • osama_ayoub Profile Picture
    43 on at

    yes that is what i need,
    I have outlook emails with html table (same headers and 1 row of data) and I want to list each table (I mean here the second row of table) in the table I have created in excel file on sharepoint.

    Regards

  • osama_ayoub Profile Picture
    43 on at

    yes that is what i need,
    I have outlook emails with html table (same headers and 1 row of data) and I want to list each table (I mean here the second row of table) in the table I have created in excel file on sharepoint.

    Regards

    @Nived_Nambiar

  • Matthy79 Profile Picture
    4,180 Super User 2024 Season 1 on at

    Hello @osama_ayoub 

     

    I would suggest you post some sample data of such an HTML table from your email.

  • osama_ayoub Profile Picture
    43 on at

    Hello @Matthy79
    Thanks for your support
    this is a table from one mail as a sample .


    Code

    model

    Serial

    Case no

    warranty

    TV-1190895

    55U5965EA _ (TOSHIBA LED 4K smart 55 inch receiver)

    m20alaa22018a1

    CAS2023061930288699

    IN

  • Matthy79 Profile Picture
    4,180 Super User 2024 Season 1 on at

    Hello again.

     

    I meant the html code. If I view the source code of your post, would there be the exact html table you receive? And are there only 2 columns?

  • osama_ayoub Profile Picture
    43 on at

    I do not know How can I find the HTML code of the table , but yes the table has only 2 rows and 5 columns with always the same header .

  • osama_ayoub Profile Picture
    43 on at

    I do not know How can I find the HTML code of the table , but yes the table has only 2 rows and 5 columns with always the same header 

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @osama_ayoub 

     

    Normally an html table having table in email body looks like this 

     

    <table>

    <tr>

    <th>A</th>

    <th>B</th>

    <th>C</th>

    </tr>

    <tr>

    <td>A</td>

    <td>B</td>

    <td>C</td>

    </tr>

     

    So to get the html code , use compose action after trigger and add email body which is coming as dynamic content from trigger output and show the end result of the flow which displays the email body html format.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

     

     

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