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 ...
Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    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

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
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

 

Jaide17's avatar
Jaide17
Frequent Visitor
2 years ago

Hi, 
I am having the same issue, I tried the above solution, using the formula and it came back with the error: We cannot convert a value of type Record to type Text. 

Can you assist please? mahoneypat  Icey 

 

Thanks, 
Jaide