A field choice that is unchangeable even though the choice is not available in choice list

[ChuanYanF]

Dear experts,

I have encountered a problem which is during data migration, some data values for choice fields are not matching with the existing choices hence it will create another new choice. But when I deleted the wrongly added choices fields and try to change to the existing choice fields that I configured myself in the system, the field choices will not get updated and will maintain the choices from the data migration even though the choice is not in the choice list under the dictionary entry for the field. Like the screenshot below, the choices that are wrongly imported is coloured in blue, and the correct ones are black in colour. How do I fix this situation?

[Kieran Anson]

Can you share how you're trying to fix this (script?) you may be running into a data policy or business rule that is preventing your update.

[ChuanYanF]

Hi Kieran, I checked on the data policies and business rule, none are affecting this problem actually. So i also dont know what is the problem right now.

[AnveshKumar M]

Hello @ChuanYanF 

The choice field type works this way only. The data is stored as a string in the record, it is not a reference to the choice we created.

If the choice is deleted, the record will show that value in Blue colour. 

As it is not a reference, the data will not update on updating the choice list.

The way out is, use data management job (filter the records in list view which you want to update and right click the column header then data management and update). In the form opened check the filter conditions and add the fields which you wanted to update to right value. Make sure you created the right choice list values before you do this.

Let me know if you still face any issues.

[ChuanYanF]

Hi AnveshKumar, thanks for the reply. I tried using your approach to my problem but after I execute it the data management update job state is complete. But the problem still remains, the choice is still the old and wrong value and is still blue in colour.