Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sharepoint List Extracted Data

Hello,   I extracted data from a Sharepoint list and in some columns I am getting this "<div class=..."  instead of just the data that appears on a Sharepoint list. How can I be able to display in ...
  • mahoneypat's avatar
    5 years ago

    Anonymous  Instead of changing your SharePoint list column, you can add a custom column in the query editor with this formula to get the text from the HTML code.  Replace "RichText" with your column name.

     

    = Html.Table([RichText] , {{"text",":root"}}){0}[text]

     

    Pat