Extract HTML Table from Email in Power Automate

Learn how to use Xpath, XML, IndexOf and Substring expressions in Power Automate in order to extract an HTML table from an incoming email, convert to a JSON array, and import into a new Excel File containing a table. I will talk you though the basics of HTML Tables, how to read the tags and understand how XPath might help you with your data extraction.

#PowerAutomate #JSON #HTML #Table #Excel

00:00 Intro
01:01 Let's get started
02:25 HTML Tables W3Schools
03:31 How to Use Xpath in Power Automate
05:35 Quick Overview of HTML to JSON Array
06:14 Explore the solution in detail
10:22 Further explanation of XPath
11:03 Select vs Apply to Each method of extracting data from HTML
18:12 Create Excel File and populate with HTML Table
20:15 A demo of the solution, HTML Table to JSON to Excel
21:23 Summary and thanks for watching

Download Flow https://github.com/DamoBird365/PowerA...

Create and Populate and Excel File FAST    • Create & Populate Excel File Fast - O...  
Create a new Excel File in Power Automate    • Create a new Excel File in Power Auto...   Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕