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

[gvg]

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?

[gvg]

Yes, you are right. Thank you! 

[nitishsh91 · Accepted solution]

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"