Forum Discussion

WJ876400's avatar
WJ876400
Icon for Helper IV rankHelper 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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello WJ876400 ,
You can refer to this link 

  • WJ876400's avatar
    WJ876400
    Icon for Helper IV rankHelper IV
    5 years ago

    Hi Anonymous 

     

    Thanks for the response, i have followed the steps but it hasn't worked. I don't get the options in the example on the drop down menu

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello WJ876400 
      Expand the column and check are you getting the expected result.
      You can refer this link