How to - Convert HTML Table to JSON Power Automate

Since Power Automate and other RPA technology took hold I believe that one of the top integration tools is now Outlook/email. Yes I know it's not a integration tool, but it to Power Automate, it just another API, with almost universal access (so many systems now allow reports to be scheduled and sent by email). A common issue I see is how to get the data from the email, ideally it will be a .xlsx file, or maybe a csv (please not a .xls, thats been deprecated for 22 years and counting, all those software provides still sending .xls need to sort themselves out!), and quite often a simple html table. So how do you get the data from a html table into json so you can use it, luckily there are a few ways. Sadly the out of the box html conversion only converts to plain text, not tabular data, but there are 3 ways I know of

Apr 28, 2025 - 06:24

How to - Convert HTML Table to JSON Power Automate

Since Power Automate and other RPA technology took hold I believe that one of the top integration tools is now Outlook/email. Yes I know it's not a integration tool, but it to Power Automate, it just another API, with almost universal access (so many systems now allow reports to be scheduled and sent by email).

A common issue I see is how to get the data from the email, ideally it will be a .xlsx file, or maybe a csv (please not a .xls, thats been deprecated for 22 years and counting, all those software provides still sending .xls need to sort themselves out!), and quite often a simple html table. So how do you get the data from a html table into json so you can use it, luckily there are a few ways.

Sadly the out of the box html conversion only converts to plain text, not tabular data, but there are 3 ways I know of