{"id":797,"date":"2013-01-28T12:54:51","date_gmt":"2013-01-28T12:54:51","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=797"},"modified":"2024-04-26T12:50:16","modified_gmt":"2024-04-26T12:50:16","slug":"quickly-determine-unique-values-in-a-sharepoint-field","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/quickly-determine-unique-values-in-a-sharepoint-field\/","title":{"rendered":"Quickly determine unique values in a SharePoint field"},"content":{"rendered":"<h4>Report on unique values in a SharePoint field<\/h4>\n<p>Ever need to know which values are in use for a multi-select field? Here\u2019s a quick and easy way to do it:<\/p>\n<pre lang=\"php\">$web= Get-SPWeb \"http :\/\/SharePoint\/SPWeb\/\"\r\n$FieldName=\"Activity\" # use your own field name\r\n$list = $web.Lists[\"ListName\"]\r\n$activities = @()\r\nforeach($doc in $list.Items) { $activities += $doc[$FieldName] }\r\n$activities | Select-Object -Unique | Sort-Object\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Report on unique values in a SharePoint field Ever need to know which values are in use for a multi-select field? Here\u2019s a quick and easy way to do it: $web= Get-SPWeb &#8220;http :\/\/SharePoint\/SPWeb\/&#8221; $FieldName=&#8221;Activity&#8221; # use your own field name $list = $web.Lists[&#8220;ListName&#8221;] $activities = @() foreach($doc in $list.Items) { $activities += $doc[$FieldName] } [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":935,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[26],"tags":[],"class_list":["post-797","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=797"}],"version-history":[{"count":1,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/797\/revisions"}],"predecessor-version":[{"id":799,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/797\/revisions\/799"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/935"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}