This value is required

You can set a list column to require a value when a new item is created.

Symptoms

When attempting to copy an item, ShareGate Migrate displays the following error:

This value is required.

Error code

• IN-142-106
• DA-073-106
• DA-075-106
• Error codes ending with: -106

Details

You can set a column to require a value at any time in SharePoint. You usually get this error when a column was set not to require a value when it was created, items were created without a value, and then the setting was activated for that column.

When you migrate items in that list, the destination will refuse them because that column requires a value and your old items does not have one for that property.

Solutions

Set your column so it does not require information during your migration

1. Open the list directly in SharePoint.
2. Click on the gear icon in the top right corner.
3. Select List settings from the menu that appears.
4. Scroll down to the Columns section.
5. Click on the name of the affected column that requires information.
6. Set Require that this column contains information to No.
   
7. Go to ShareGate Migrate.
8. Run your migration again.
9. Go back to your column settings.
10. Set Require that this column contains information back to Yes.

Set a default value for your items missing information in the required column

1. In the Copy content only screen, click on Options.
2. Select the Metadata tab.
3. Expand the content type that contains the affected column.
4. Locate the affected column.
5. Select Set mapped value or default in the dropdown.
6. In the new dropdown that appears at the right, select the default value you want ShareGate Migrate to use when a required value is missing.
7. Click on the green checkmark in the top-right corner to save your settings and close the options panel.
8. Run your migration again.
9. Items with no value for your required field will get the default value you selected while items that already have a value will keep that value from the source.