Home

How to add new value for multiple items in a multi selectable choice column of a SharePoint List?

%3CLINGO-SUB%20id%3D%22lingo-sub-682986%22%20slang%3D%22en-US%22%3EHow%20to%20add%20new%20value%20for%20multiple%20items%20in%20a%20multi%20selectable%20choice%20column%20of%20a%20SharePoint%20List%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682986%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20find%20any%20other%20post%20or%20solution%20about%20my%20problem%20so%20here%20my%20question%3A%3C%2FP%3E%3CP%3EI%20build%20a%20custom%20SharePoint%20List%20(Adress%20List).%20In%20this%20list%20I%20created%20a%20multi%20selectable%20choice%20column.%3CBR%20%2F%3ENow%20I%20want%20to%20update%20more%20then%20one%20item%20in%20that%20list%20(maybe%20ten%20or%20more).%20So%20I%20select%20all%20items%20I%20want%20to%20update%20and%20open%20the%20details%20pane%20on%20the%20right%20in%20SharerPoint%20modern%26nbsp%3Bexperience.%20Here%20I%20have%20the%20possibility%20to%20update%20all%20the%20selected%20Items.%20But%20when%20I%20update%20the%26nbsp%3Bmulti%20selectable%20choice%20column%2C%20all%20old%20values%20from%20the%20selected%20items%20get%20lost%20and%20will%20be%20overwritten%20with%20the%20new%20selection%20I%20did%20in%20the%20details%20pane.%3CBR%20%2F%3ESo%20how%20can%20I%20update%2Fadd%20a%20new%20value%20of%20the%20choice%20field%20for%20many%20selected%20items%2C%20without%20getting%20lost%20the%20old%20choices%20of%20the%20items%3F%20I%20just%20want%20to%20add%20a%20value%20of%20the%20choice%20field%20to%20the%20items%20and%20not%20overwrite%20it!%20Is%20that%26nbsp%3Beasily%20possible%20or%20do%20I%20have%20to%20use%20Flow%20for%20this%20workaround%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20understand%20my%20question.%20If%20not%20please%20ask%20me%20to%20explain%20it%20a%20bit%20more%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3EThanks%20a%20lot%3C%2FP%3E%3CP%3EMichael%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-682986%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-683344%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20new%20value%20for%20multiple%20items%20in%20a%20multi%20selectable%20choice%20column%20of%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F248588%22%20target%3D%22_blank%22%3E%40lotz-hellerau%3C%2FA%3E%26nbsp%3B%20Unfortunately%2C%20there%20is%20no%20OOTB%20way%20around%20for%20this.%20Did%20you%20try%20using%20Quick%20edit%20feature%2C%20it%20will%20preserve%20the%20old%20values%20but%20you%20have%20to%20manually%20select%20the%20new%20choice%20option%20in%20each%20row.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-684004%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20new%20value%20for%20multiple%20items%20in%20a%20multi%20selectable%20choice%20column%20of%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F29544%22%20target%3D%22_blank%22%3E%40unnie%20ayilliath%3C%2FA%3E%26nbsp%3Bthere%20is%20no%20way%20to%20do%20it%20manually%2C%20because%20the%20number%20of%20items%20for%20selection%20could%20be%20100%20and%20more%2C%20where%20all%20items%20have%20individual%20choices...%3C%2FP%3E%3C%2FLINGO-BODY%3E
lotz-hellerau
Occasional Contributor

Hi :)

 

I can't find any other post or solution about my problem so here my question:

I build a custom SharePoint List (Adress List). In this list I created a multi selectable choice column.
Now I want to update more then one item in that list (maybe ten or more). So I select all items I want to update and open the details pane on the right in SharerPoint modern experience. Here I have the possibility to update all the selected Items. But when I update the multi selectable choice column, all old values from the selected items get lost and will be overwritten with the new selection I did in the details pane.
So how can I update/add a new value of the choice field for many selected items, without getting lost the old choices of the items? I just want to add a value of the choice field to the items and not overwrite it! Is that easily possible or do I have to use Flow for this workaround?

 

I hope you understand my question. If not please ask me to explain it a bit more :)
Thanks a lot

Michael

2 Replies

@lotz-hellerau  Unfortunately, there is no OOTB way around for this. Did you try using Quick edit feature, it will preserve the old values but you have to manually select the new choice option in each row. 

@unnie ayilliath there is no way to do it manually, because the number of items for selection could be 100 and more, where all items have individual choices...

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies