Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
gvg
Post Prodigy
Post Prodigy

How to parse <td> tags with HTML.Table ?

Hello,

I am trying to figure out how HTML.Table works. Microsoft description of this function is very basic. Let's say I have a simple HTML code "<td> 100.67</td>" from which I want to extract the value (100.67).  Trying this code, but it does not give me wanted result, although does not complain about syntax:

    = Html.Table("<td> 100.67</td>", { {"myValue", "td"}})

This one does not work either:

    = Html.Table("<td>100.67</td>", { {"myValue", "td"}}, [RowSelector="td"])

 

What am I missing here?

1 ACCEPTED SOLUTION
nitishsh91
Solution Supplier
Solution Supplier

Hi @gvg 

 

It looks like the issue might be with the way the HTML code is formatted. The Html.Table function expects the input HTML code to be in a specific format, with a table structure containing rows and columns. The code you provided is just a single cell in a table, without any surrounding table structure.

Note that in this example, the HTML code has a table structure, with a single row and a single cell containing the value 100.67.

Also, the second parameter of Html.Table is a list of name-selector pairs, not a record. So you should use

let
html = "<table><tr><td>100.67</td></tr></table>",
#"Extracted Table" = Html.Table(html, {{"myValue", "td"}})
in
#"Extracted Table"

 

View solution in original post

2 REPLIES 2
gvg
Post Prodigy
Post Prodigy

Yes, you are right. Thank you! 

nitishsh91
Solution Supplier
Solution Supplier

Hi @gvg 

 

It looks like the issue might be with the way the HTML code is formatted. The Html.Table function expects the input HTML code to be in a specific format, with a table structure containing rows and columns. The code you provided is just a single cell in a table, without any surrounding table structure.

Note that in this example, the HTML code has a table structure, with a single row and a single cell containing the value 100.67.

Also, the second parameter of Html.Table is a list of name-selector pairs, not a record. So you should use

let
html = "<table><tr><td>100.67</td></tr></table>",
#"Extracted Table" = Html.Table(html, {{"myValue", "td"}})
in
#"Extracted Table"

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors