How to get Field values of a list item using CSOM Powershell?

Question

How to get Field values of a list item using CSOM Powershell?

I am using below code:

foreach($field in $List.Fields)
{
    write-host $field
}

I am getting the values as output:

Microsoft.SharePoint.Client.Field
Microsoft.SharePoint.Client.FieldDataTime
Microsoft.SharePoint.Client.FieldLookup

But I want all field values like ID, Title, Created By etc.

Answer 1

Your code does not retrieve any list items. This is an example of how you do it:

$listItems = $list.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery())
$ctx.load($listItems)

$ctx.executeQuery()
foreach($listItem in $listItems)
{
    Write-Host "ID - " $listItem["ID"] "Title - " $listItem["Title"]
}  

Credits to: https://www.c-sharpcorner.com/article/list-item-operations-using-csom-with-powershell-for-sharepoi/

Answer 2

If you want to get list item values, you can use this

$web=Get-SPWeb "http://www.myspapp/sites/myspweb"
$list=$web.Lists["MyListNAme"]

foreach($item in $list.Items)
{
    Write-Host  $item["ID"] $item["Title"]
}

If you want to get column names only, you can use this

$web=Get-SPWeb "http://www.myspapp/sites/myspweb"
$list=$web.Lists["MyListNAme"]

foreach($field in $list.Fields)
{
    Write-Host $field
}

Answer 3

You need to get the item/s first (either by CAML query or by id) and the property values are accessible via:

$item.FieldValues

So you can get the values you are after like so:

$item.FieldValues.Title
$item.FieldValues.ID