Notes Migrator for SharePoint adds a value to choices list even though this choice value already exists
Aspace simbol at the end of the choice valuein the source record
Inthe database, some fieldsare multi-value checkboxes and some values have spaces after them. This shows up when you Preview the Notes Data Definition. SharePoint thinks these are new choices. The solution is to trim the trailing spaces using a formula. In the Notes Data Definition, for all fields that are mapping to Choice fields in SharePoint, change ColumnType to Formula. Move what was the ItemName down to Alias (so the mapping still works), and make Formula to be @Trim(fieldname). If you run a preview, there will be no trailing spaces.
