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

[David Jenkins]

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]

Hi,

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

[#3 · Accepted 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