I want to change choice column from Drop down to Checkbox using powershell []

  • It seems that behind the scenes this changes field from SPFieldChoice to SPFieldMultiChoice, but I don't know how to achieve it any way except UI – MikhailSP Dec 8 '15 at 11:57

I've been banging my head on this until I realised it's actually alarmingly easy.

$web = Get-SPWeb <site url>
$field = $web.Fields.GetFieldByInternalName(<field name>)
$field.Type = [Microsoft.SharePoint.SPFieldType]::MultiChoice

That's all.

| improve this answer | |

Is there a Calculated column that uses the value of this Choice column? It looks like Calculated columns can't reference Choice (checkbox) columns in their formulae, so if an existing Calculated column is currently referencing the Choice column, you're prevented from changing the Choice column's type to checkbox so as to avoid breaking the Calculated column's formula.

Remove the Choice column from the formula of any Calculated column in the list, then try to change the Choice column's type to "checkbox" again.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.