Comment Information from SharePoint

[ElaineO]

I am pulling information from a SharePoint Comment field which is type: Multiple lines of text. When the information is pulled into Alteryx this is what it looks like:

<DIV CLASS="EXTERNALCLASSB05A3F84B0594B838D2C6EC1EA4C3420"><P><SPAN STYLE="COLOR&#58;#1F497D;FONT-FAMILY&#58;&QUOT;CALIBRI&QUOT;,SANS-SERIF;FONT-SIZE&#58;11PT;">SINCE
A DIFFERENT PRIMARY WAS TO BE BILLED THAN THE PRIMARY THAT WAS BOOKED, THIS

SHOULD HAVE BEEN SUBMITTED AS A C&AMP;R AND NOT DONE AS A TRANSFER OF RESPONSIBILITY.</SPAN></P></DIV>

What do I need to do to fix this?

Any help is appreciated.

Thank you,

Elaine

[BrandonB · Accepted solution]

Maybe something like this? Workflow is attached. 

 

[ElaineO]

Thanks Brandon,

Your solution works to a point.  The comments are all different and some have other characters embedded in the middle of the text.  For example: status&#160;is unbilled. claim&#160;rejection. I am also having the issue of the long comments being truncated even though they are V_WString. We may need to go a completely different direction to resolve this.

I will keep you posted once this is resolved.

I am marking your resolution as accepted because it has resolved another issue I was having.

Thank you,

Elaine

[BrandonB]

Are you pulling the data from a webpage or from the API? These extra codes can be accounted for using a formula tool to convert into whatever you would like, but this is likely the result of where the data is being pulled from. 

[BrandonB]

It may be better to pull them via the API. I was searching around and saw it being discussed here: https://www.vrdmn.com/2017/07/working-with-page-comments-rest-api-in.html

[ElaineO]

Thanks Brandon.

We are pulling from the webpage.  I will forward your solutions to my SharePoint admin.

[james4252]

Microsoft introduced a brand new feature of Commenting in SharePoint on line lists and Microsoft lists. the use of this selection customers will be able to upload and delete comments on listing objects. users can view all remarks on a listing item and filter among perspectives that display comments or activity related to an item in details pane,