SP List - update existing choice column to allow for multiple selectioins?

%3CLINGO-SUB%20id%3D%22lingo-sub-1529340%22%20slang%3D%22en-US%22%3ESP%20List%20-%20update%20existing%20choice%20column%20to%20allow%20for%20multiple%20selectioins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529340%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%26nbsp%3BSP%20list%20with%20%3CSTRONG%3Eexisting%3C%2FSTRONG%3E%20columns%20created%20as%20Choice.%26nbsp%3B%20I%20would%20like%20to%20update%20those%20columns%20to%20allow%20for%20multiple%20selections.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESP%20appears%20to%20want%20to%20let%20me%20but%20I%20get%20an%20error%20when%20trying%20to%20save.%26nbsp%3B%20Am%20I%20doing%20something%20wrong%20or%20are%20you%20only%20able%20to%20do%20this%20with%20new%20columns%20and%20you%20are%20not%20able%20to%20update%20an%20existing%20column%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20286px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206075iEBC4B783A8BD62D6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529340%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529364%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20List%20-%20update%20existing%20choice%20column%20to%20allow%20for%20multiple%20selectioins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529364%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325149%22%20target%3D%22_blank%22%3E%40Bryan123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20not%20done%20this%20for%20a%20while%20but%20in%20earlier%20versions%20of%20SharePoint%2C%20moving%20from%20a%20single%20choice%20to%20a%20multiple%20choice%20column%20would%20work%20quite%20easily.%26nbsp%3B%20How%20many%20options%20have%20you%20used%20in%20the%20column%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20doesn't%20work%2C%20than%20create%20as%20new%20the%20multiple%20choice%20field%20and%20use%20quick%20edit%20to%20copy%20paste%20the%20options%20over.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529520%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20List%20-%20update%20existing%20choice%20column%20to%20allow%20for%20multiple%20selectioins%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11625%22%20target%3D%22_blank%22%3E%40Steven%20Andrews%3C%2FA%3E%26nbsp%3B%20the%20issue%20is%20not%20going%20from%20a%20single%20choice%20to%20a%20multiple%20choice%20column.%20The%20issue%20is%20going%20from%20a%20multiple%20choice%20(single%20selection)%20to%20a%20multiple%20choice%20(multiple%20selection)%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%2030%2B%20columns%20so%20rebuilding%20all%20the%20columns%20to%20allow%20for%20multiple%20selections%20is%20not%20feasible%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a SP list with existing columns created as Choice.  I would like to update those columns to allow for multiple selections.

 

SP appears to want to let me but I get an error when trying to save.  Am I doing something wrong or are you only able to do this with new columns and you are not able to update an existing column?Capture.PNG

 

2 Replies

@Bryan123 

I've not done this for a while but in earlier versions of SharePoint, moving from a single choice to a multiple choice column would work quite easily.  How many options have you used in the column?

 

If it doesn't work, than create as new the multiple choice field and use quick edit to copy paste the options over.

@Steven Andrews  the issue is not going from a single choice to a multiple choice column. The issue is going from a multiple choice (single selection) to a multiple choice (multiple selection) column.

 

I have 30+ columns so rebuilding all the columns to allow for multiple selections is not feasible