cancel
Showing results for 
Search instead for 
Did you mean: 
calmaguer
Nintex Newbie

Renaming one of the choices without screwing up the rest of the list?

Nintex wizards, I probably have an easy challenge for you. I have a list with 2000+ items. The list has a choice field, and I want to update the verbiage of one of the choices.

However, if I do that in the list settings, all the existing list items that have that choice will have the "old" version of the choice, and if anyone tried to edit an unrelated field in those items, they wouldn't be able to save it unless they ALSO changed the "old" version of that field to the new.

I need a (hopefully simple way) to make this change for all items - I'm assuming it's going to involve something silly like a workflow that will run in a loop on all items, and a "run if" that will look for the old value, remove it and add the new value. 

Is there an easier way to do this?

Labels: (1)
0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: Renaming one of the choices without screwing up the rest of the list?

how many items do you need to change?

if not so many, you could create a view that shows just items with old value in choice field.

then prepare in a excel a column with all the new choice values.

copy&paste new values from excel to list in a quick edit mode.

0 Kudos
Reply
calmaguer
Nintex Newbie

Re: Renaming one of the choices without screwing up the rest of the list?

Thanks Marian!  There are quite a few, and to complicate things more, this is a multi-choice (checkbox) field, so some of the items have other choices selected in addition to the one value I need to change.

0 Kudos
Reply
shrinivasnaik
Nintex Newbie

Re: Renaming one of the choices without screwing up the rest of the list?

Hi Chris,

I guess there wont be an easy way and the approach you suggested might be the best possible option. I do think creating the workflow in Nintex to update this wont take that long.

If you had a lookup field then all the values in your list would have got updated as SharePoint stores only the reference to the lookup value but as this is choice field SP will store the actual value, so you would need to update all the values through some automation (Nintex or a PS script!). Unless there is someone who might have a OOB approach to do this in SP.

Regards,

Shrini

0 Kudos
Reply
Automation Master
Automation Master

Re: Renaming one of the choices without screwing up the rest of the list?

then I would maybe exported whole list to an excel, replace that single choice value, (cleared the list in SP) and imported it back to SP list.

for 2k+ items that shouldn't be a big deal.

only problem might be if you have any dependent lists/lookups on this list, since item IDs will change.

if this is as well not viable then the best approach really would be to create a small workflow that performs update.

0 Kudos
Reply
Stonehage
Nintex Newbie

Re: Renaming one of the choices without screwing up the rest of the list?

Your first lesson from this should be to use Lookups where you can

Yeah multiple ways to tackle this. You could workflow it to lookup all ID's with the old name and using For Each ID, update to the new name.

Another way is to just use the edit option on your list. Just copy and paste into the field your new name.

0 Kudos
Reply