Рет қаралды 52,938
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 github.com/DamoBird365/PowerA...
Create and Populate and Excel File FAST • Create & Populate Exce...
Create a new Excel File in Power Automate • Create a new Excel Fil... Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕