Get-PnPListItem not retrieving column data

ComputerHabit Hi David, I will answer this in two parts First get all the list columns:

Use the below script:

Connect-PnPOnline https://yourorg.sharepoint.com/sites/demo/ -cred $cred
$ListName = "List1"
$Fields = Get-PnPField -List $ListName
$global:FieldsList = ""
$i =1
foreach($Field in $Fields)
{
$global:FieldsList = $global:FieldsList + $Field.InternalName + ','
Write-Host "Field Number " $i $Field.InternalName
$i++
}

Once you have all the columns select the columns you need :

Then use the below code:

Connect-PnPOnline https://yourorg.sharepoint.com/sites/demo/ -cred $cred
$ListName = "List1"
$Fields = Get-PnPField -List $ListName
$Items= (Get-PnPListItem -List $ListName -Fields "Title","GUID", "Modified","Created","ID")
$i=1
foreach($Item in $Items)
{
Write-Host "Item #" $i -ForegroundColor Yellow
Write-Host "Title :" $Item["Title"]
Write-Host "GUID :"$Item["GUID"]
Write-Host "Modified :"$Item["Modified"]
Write-Host "Created :"$Item["Created"]
$i++
}

Final output will be something like this