Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Using Power Automate / Logic Apps to Convert HTML Table Email into CSV

I am developing a PowerAutomate script that will upon email received, convert the HTML table into a CVS or Excel file. More than likely the end script will be updating a SQL table with the data. Any suggestions, Examples for doing this? I have found a few examples but typically its creating expressions using a Split function to grab one or two things from the HTML email and then storing these into an excel spreadsheet. I need to loop through each table ROW and found in the HTML file and store each table row as a row in Excel/CSV.


Any help would be appreciated. Here is an HTML code from the email:


<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta content="text/html; charset=utf-8"></head>
  <table border="1">
        <th>Partner ID</th>
        <td align="center">&nbsp;EMEDNY8.DAT&nbsp;</td>
        <td align="center">&nbsp;2020-09-04&nbsp;</td>
        <td align="center">&nbsp;ttYankey22099.txt&nbsp;</td>
        <td align="center">&nbsp;2020-09-04&nbsp;</td>
        <td align="center">&nbsp;SEP2020_182937.837&nbsp;</td>
        <td align="center">&nbsp;2020-09-04&nbsp;</td>
        <td align="center">&nbsp;AugMedMed_678.txt&nbsp;</td>
        <td align="center">&nbsp;2020-09-04&nbsp;</td>
        <td align="center">&nbsp;JUExcel_med.DAT&nbsp;</td>
        <td align="center">&nbsp;2020-09-04&nbsp;</td>
Super User
Super User



You can use Muhimbi PDF Convert to Convert HTML to CSV..








Note: Muhimbi is a paid service, you find details about their pricing at 


If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!



Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (2,500)