Announcements
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.
Hi @osama_ayoub
The logic behind this should be to use string manipulation to extract the data from the email regarding table data.
The logic of extracting data from that email body should be like below
1. Split the email body based on <table> and then take the second element in the resultant array.
2. Using second element from the array got from split operation in Step 1, use that again to split the email body based on </table> tag then take the first element out of resultant array.
Now you have got the complete table data
3. Now you want to extract data row by row, for that split the output data from step 2 to split based on <tr>
Now you will get collection of individual rows.
For each row, split it by <th> (in case of header) or <td> (in case of values). And then take values respectively.
Problem was quite easier if regex feature was present in power automate 🙂
Let me know any help is needed.
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! 🙌
ok I used compose action to extract html code and this is what I got
could you tell me how can I convert it to table in excel file ?
Regards
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! 🙌
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
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 .
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?
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 |
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
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
