Report on unique values in a SharePoint field
Ever need to know which values are in use for a multi-select field? Here’s a quick and easy way to do it:
$web= Get-SPWeb "http ://SharePoint/SPWeb/"
$FieldName="Activity" # use your own field name
$list = $web.Lists["ListName"]
$activities = @()
foreach($doc in $list.Items) { $activities += $doc[$FieldName] }
$activities | Select-Object -Unique | Sort-Object
Want to talk?
Drop us a line. We are here to answer your questions 24*7.