SharePoint 2010 : Query SharePoint List Items missing required fields.

In most of the organizations Content Managers decides the fields and its property for the List or Library. They are Power Users and have certain limitations to fetch reports.

We started discussing about Power Query and ended up in PowerShell.

Need to fetch Document Library Items which miss some required fields.

We all know that SharePoint will not allow us to submit the item if we miss the required fields. However in some cases content managers might have changed the settings and revert. During this interval we may have few items created with no required fields.


$web = Get-SPWeb ''
$list = $web.Lists["LibraryName"]
$data = $list.Items | ? {$_.MissingRequiredFields -eq $true}
$data | Select Title , MissingRequiredFields , ID | 
Export-Csv D:\MissingRequiredFields.csv -NoTypeInformation -Encoding UTF8


Leave a Reply

Your email address will not be published. Required fields are marked *