When attempting to copy an item, Sharegate displays the following error message:
The following values are unavailable: 'MyValue1, MyValue2'. Please specify another value.
The error should appear on a given property, for example, Property Status: The following values are unavailable: 'MyValue1, MyValue2'. Please specify another value.
The error occurs because the specified values are not valid values for the destination lookup column. The most common cause for this is when the contents of the source list referenced by the lookup column is not the same as the destination.
Another potential cause to this error is when the referenced column is a calculated column. These type of columns are difficult to copy between environments because of limitations in SharePoint.
There are 3 possible solutions to this issue:
- Copy the contents of the list referenced by the lookup column from the source to the destination. For example, if the list Employees has a lookup column called Building that references the Buildings list, the contents of the Buildings list should be copied before copying the contents of the Employees list.
- Set a default value in Sharegate to use when the source item contains an invalid value for the destination lookup column. This can be done by creating a Property Template and setting the column to "Set mapped value or default". Doing this will replace every value that is no longer valid with the specified default value, so the data will be altered.
- Export the contents of the list to Excel, correct the values that were flagged as unavailable and import the Excel file to your destination by Copying Content with Excel.