{"id":37,"date":"2014-06-27T17:29:55","date_gmt":"2014-06-28T01:29:55","guid":{"rendered":"http:\/\/www.jeaz.org\/?p=37"},"modified":"2014-06-27T17:29:55","modified_gmt":"2014-06-28T01:29:55","slug":"remove-workflow-status-columns","status":"publish","type":"post","link":"https:\/\/www.jeaz.org\/?p=37","title":{"rendered":"Remove Workflow Status Columns"},"content":{"rendered":"<p>Working in SharePoint 2010, I used the Content and Structure Tool to copy list items from a list with workflows to one without<\/p>\n<p>Unfortunately, the workflow status column was also created in the destination list.<br \/>\nClearly, this wasn't a useful column and I didn't want it in my fields.<\/p>\n<p>How do you remove a workflow status column?<br \/>\nIt's pretty easy with some PowerShell<\/p>\n<p><code>PS C:\\> $web = Get-SPWeb https:\/\/site.domain.com\/web<br \/>\nPS C:\\> $list = $web.Lists[\"List Name\"]<br \/>\nPS C:\\> $field = $list.Fields[\"Workflow Status Column Name\"]<br \/>\nPS C:\\> $field.Hidden<br \/>\nFalse<br \/>\nPS C:\\> $field.ReadOnlyField<br \/>\nTrue<br \/>\nPS C:\\> $field.ReadOnlyField = $false<br \/>\nPS C:\\> $field.Update()<\/code><\/p>\n<p>Once the field is no longer a <code>ReadOnlyField<\/code> you can delete it like any other column<br \/>\nYou can also throw in <code>$field.Delete()<\/code> at the end<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Working in SharePoint 2010, I used the Content and Structure Tool to copy list items from a list with workflows to one without Unfortunately, the workflow status column was also created in the destination list. Clearly, this wasn&#8217;t a useful column and I didn&#8217;t want it in my fields. How do you remove a workflow [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,14,4],"tags":[8,16,15],"class_list":["post-37","post","type-post","status-publish","format-standard","hentry","category-scripting-tips","category-sharepoint","category-why-why-why","tag-powershell","tag-sharepoint","tag-workflow"],"_links":{"self":[{"href":"https:\/\/www.jeaz.org\/index.php?rest_route=\/wp\/v2\/posts\/37","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jeaz.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jeaz.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jeaz.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jeaz.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=37"}],"version-history":[{"count":0,"href":"https:\/\/www.jeaz.org\/index.php?rest_route=\/wp\/v2\/posts\/37\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jeaz.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jeaz.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jeaz.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}