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

Brass 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

@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

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