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 a couple of ways. Go into grid view and filter for the value you want to change, change the first one then copy the cell contents down the list.
The other way would be to build a flow in Power Automate, use a manual trigger, add a get items action and set the filter query to {value} eq {yourvalue}. Then add an apply to each and inside it add an update item action and set the value field to the new value. Save and run.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)