SOLVED

Cannot retrieve details from Multiple lines text when Append Changes is enabled

%3CLINGO-SUB%20id%3D%22lingo-sub-1185145%22%20slang%3D%22en-US%22%3ECannot%20retrieve%20details%20from%20Multiple%20lines%20text%20when%20Append%20Changes%20is%20enabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1185145%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20column%20I'd%20like%20to%20export%20the%20data%20from.%26nbsp%3B%20The%20column%20is%20a%20%22Multiple%20lines%20of%20text%22%20and%20has%20%22Append%20Changes%20to%20Existing%20Text%22%20enabled.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20unable%20to%20get%20the%20data%20from%20this%20field.%26nbsp%3B%20I've%20tried%20Sharepoint%20PNP%20and%20Exchange%202013%20Powershell%20to%20attempt%20to%20get%20the%20data.%26nbsp%3B%20I%20get%20the%20column%20but%20no%20data%20is%20presented.%26nbsp%3B%20When%20looking%20at%20the%20web%20page%20itself%20the%20data%20is%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1186076%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20retrieve%20details%20from%20Multiple%20lines%20text%20when%20Append%20Changes%20is%20enabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1186076%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20add%20the%20column%20to%20the%20view%20and%20Have%20you%20tried%20using%20the%20%22Export%20to%20Excel%22%20option%20from%20command%20bar%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1187125%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20retrieve%20details%20from%20Multiple%20lines%20text%20when%20Append%20Changes%20is%20enabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1187125%22%20slang%3D%22en-US%22%3E%3CP%3EI%20think%20I%20have%20my%20answer.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI%20guess%20when%20Append%20Changes%20is%20enabled%20its%20like%20versions.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%24item%5B%22Status_x0020_Comments%22%5D%3CBR%20%2F%3E%23%24item.Fields%20%7C%20fl%3C%2FP%3E%3CP%3E%24VersionData%20%3D%20''%3CBR%20%2F%3Eforeach(%24version%20in%20%24item.Versions)%3CBR%20%2F%3E%7B%3CBR%20%2F%3E%23%24VersionData%2B%3D%20%24version%5B%22Comments%22%5D%3CBR%20%2F%3E%24VersionData%2B%3D%20%24version%5B%22Status_x0020_Comments%22%5D%3CBR%20%2F%3E%7D%3CBR%20%2F%3EWrite-Host%20%24VersionData%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFound%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsharepoint.stackexchange.com%2Fquestions%2F201043%2Fextract-all-lines-from-multiline-item%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepoint.stackexchange.com%2Fquestions%2F201043%2Fextract-all-lines-from-multiline-item%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

 

I have a column I'd like to export the data from.  The column is a "Multiple lines of text" and has "Append Changes to Existing Text" enabled.

 

I'm unable to get the data from this field.  I've tried Sharepoint PNP and Exchange 2013 Powershell to attempt to get the data.  I get the column but no data is presented.  When looking at the web page itself the data is there.

 

 

 

 

2 Replies
Highlighted

Hi,

 

Can you add the column to the view and Have you tried using the "Export to Excel" option from command bar?

Highlighted
Best Response confirmed by David Jenkins (Occasional Contributor)
Solution

I think I have my answer.

I guess when Append Changes is enabled its like versions.  

 

$item["Status_x0020_Comments"]
#$item.Fields | fl

$VersionData = ''
foreach($version in $item.Versions)
{
#$VersionData+= $version["Comments"]
$VersionData+= $version["Status_x0020_Comments"]
}
Write-Host $VersionData

 

Found here: https://sharepoint.stackexchange.com/questions/201043/extract-all-lines-from-multiline-item