How to use the Html.Table function to add a column that converts a HTML column into plain text

[pruvieros]

Hello,

I have a column with HTML :

And I need to add a column that converts this Column1.1 into plain text.

Is it possible to do that with the function Html.Table?

And How?

Thanks in advance

[Anonymous · Accepted solution]

Hi @pruvieros ,

Yes, please try

Html.Table([Column1.1] , {{"text",":root"}})

You can also deal with error by usng try ... otherwise like so

try Html.Table([Column1.1] , {{"text",":root"}}) otherwise null

So if you encounter an error at this point, Power Query will just return null and the query won't stop at this step. 

Reference: Solved: Convert HTML to Text - Microsoft Power BI Community

Convert Data From HTML To Plain Text In Power BI (c-sharpcorner.com)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.