Symptoms
When attempting to copy an item, ShareGate Migrate displays the following error message:
Property 'My property': The following values are unavailable: 'MyValue1, MyValue2'. Please specify another value.
Error code
DA-079-100
Details
In the context of this error, Property is a lookup column, and value is a metadata value from another list.
The error occurs when a source value referenced by the lookup column is unavailable in the destination.
The most common cause for this is when the referenced list or list item is missing in the destination.
Another potential cause is when the referenced column is a calculated column. Because calculated columns are highly customizable, some limitations can cause the values to differ in the destination.
Solution
You can use one of the following solutions to solve the error.
Migrate the missing content being looked up and retry your migration
Open the destination list in SharePoint.
Go to the list settings.
Click on the affected column (property) in the Columns section.
Check the name of the looked-up list under Get information from.
Look for the list or library on your site.
If the list exists, open it and verify whether the value in the error message is available in it.
If the list does not exist, use Copy structure and content to migrate the looked-up list from the source.
If the list exists and the values are unavailable, use Copy content only to migrate the missing list items or documents from the looked-up list at the source.
Run your original migration again.
Replace the missing value with a value that is available at the destination
In the Copy content only screen, click on Option.
Select the Metadata tab.
Expand the Content type that contains the affected column.
Locate the affected column (property).
Select Set mapped value or default in the dropdown.
In the new dropdown at the right, select the default value you want ShareGate Migrate to use when a lookup value is unavailable.
Click the green checkmark icon in the top-right corner to save your settings and close the options panel.
Run your migration again.
Your items will keep the available values at the destination, and those with unavailable values will get the default value you selected for that column.