Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
5 years ago
Solved

Convert HTML to Text

Hi   I have a share point list that has comments in HTML. I have used the below formula to convert to plain text in Power Query   Html.Table([ColumnName] , {{"text",":root"}})   however there a...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi WJ876400 

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

    try Html.Table([ColumnName] , {{"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.

    Regards

    Phil

HenkyG0's avatar
HenkyG0
New Member
3 months ago

You can also use a browser-based tool like https://htmltotext.com/  — probably the easiest way to convert HTML to text.