Forum Discussion
Changing drop down on existing list entries
We have a SP list with thousands of items and would like to rename one of the options people have been choosing in one of the fields. We can change it now and it'll reflect all future entries, but is...
jwa33 When you change the choice option in column settings, it will not change the selection for existing items automatically.
How many items are there with that particular choice option selected?
Here are few options:
- From UI: Open All items list view (without any filters) --> Apply filter on choice column, filter by the old choice option --> Switch to "Edit in grid view" --> Change the old choice option to new option for 1st row --> drag the new option cell vertically for all items/rows. Check: How do we vertically delete values from a single column?
- Bulk update the list items with new option using PowerShell or Power Automate flow or Power Apps functions or SharePoint REST API (or any other programming techniques you are good with).
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- It's thousands of entries (5-10k).
Yeah, running something via PowerAutomate seems like the best option at this point if there isn't a straightforward way, we're missing that allows a mass change of something.jwa33 Yes, you can do it using Power Automate flow.
- Add indexing on this list column from list settings.
- Use power automate to fetch the list items with that particular option selected - you can use pagination in Get items action to fetch up to 100000 items. However, I will suggest you to do it in smaller batches to avoid any issues.
- Then in apply to each loop, you can update the item with new choice option.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
