Bulk update rows in SharePoint list where I have changed the dropdown options in the "+New" form.

%3CLINGO-SUB%20id%3D%22lingo-sub-806930%22%20slang%3D%22en-US%22%3EBulk%20update%20rows%20in%20SharePoint%20list%20where%20I%20have%20changed%20the%20dropdown%20options%20in%20the%20%22%2BNew%22%20form.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806930%22%20slang%3D%22en-US%22%3EHi%2C%20I%20am%20changing%20the%20names%20of%20some%20options%20when%20adding%20a%20new%20row%20to%20a%20SharePoint%20list%2C%20see%20attached%20image.%20eg.%20Select%20Status%3A%20is%20being%20changed%20to%2000%20-%20Logged%20How%20can%20I%20change%20the%20options%20while%20also%20updating%20the%20current%20data%20to%20match%20the%20changed%20names%20in%20the%20dropdown%3F%20Hope%20that%20makes%20sense%3F%20Thanks%20for%20your%20time%2C%20Ollie%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-806930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807393%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20update%20rows%20in%20SharePoint%20list%20where%20I%20have%20changed%20the%20dropdown%20options%20in%20the%20%22%2BNew%26amp%3B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F71651%22%20target%3D%22_blank%22%3E%40Oliver%20McErlane%3C%2FA%3E%26nbsp%3BIf%20You%20want%20all%20existing%20values%20to%20be%20updated%20with%20the%20renamed%20value%20the%20answer%20is%20that%20You%20will%20have%20to%20update%20them%20manually%20or%20via%20a%20script.%20In%20order%20to%20make%20that%20easier%20You%20can%20create%20a%20filtered%20view%20that%20shows%20the%20items%20with%20the%20old%20values%20and%20open%20the%20view%20in%20Quick%20Edit%20and%20%22bulk%20edit%22%20them%20from%20there.%3C%2FP%3E%3CP%3EHope%20i%20understood%20Your%20need%20and%20that%20this%20helped%20you.%3C%2FP%3E%3CP%3EBest%20regards%2C%20Magnus%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-808275%22%20slang%3D%22en-US%22%3ERe%3A%20Bulk%20update%20rows%20in%20SharePoint%20list%20where%20I%20have%20changed%20the%20dropdown%20options%20in%20the%20%22%2BNew%26amp%3B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-808275%22%20slang%3D%22en-US%22%3EThanks%20for%20this.%20Have%20you%20got%20an%20example%20of%20a%20script%20that%20would%20do%20this%3F%20Ollie%3C%2FLINGO-BODY%3E
Highlighted
Contributor
Hi, I am changing the names of some options when adding a new row to a SharePoint list, see attached image. eg. Select Status: is being changed to 00 - Logged How can I change the options while also updating the current data to match the changed names in the dropdown? Hope that makes sense? Thanks for your time, Ollie
2 Replies
Highlighted

@Oliver McErlane If You want all existing values to be updated with the renamed value the answer is that You will have to update them manually or via a script. In order to make that easier You can create a filtered view that shows the items with the old values and open the view in Quick Edit and "bulk edit" them from there.

Hope i understood Your need and that this helped you.

Best regards, Magnus

Highlighted
Thanks for this. Have you got an example of a script that would do this? Ollie