I am trying to get records from Office 365 SharePoint list using Powershell Script, through "Microsoft.SharePoint.Client.CamlQuery" query. It fetches all the items and the values. However, there are certain columns that is not available in the list item object returned by the query.

Why are few columns in a Sharepoint list not available through Powershell scripts? Is there some means by which SharePoint disallows the access to certain columns in a list from Powershell query?

My Code is here:

$qry = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()
$items = $list.GetItems($qry)

Any support would be highly appreciated.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.