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...
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.
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.