The text value is invalid, probably because it exceeds the 255 character limit

Symptoms

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

The text value is invalid, probably because it exceeds the 255 character limit.

Error code

Details

Solution

There are 2 possible solutions to this issue:

1. Change the destination column to be a Multiple lines of text column, which does not have the 255 character limit. This can be done by going in SharePoint in the destination list or library settings, then clicking on the column causing the problem and then selecting Multiple lines of text for the column's type.
2. Make sure that the source value does not exceed 255 characters. This can be done by exporting the metadata to Excel before copying and by editing the values to make sure that they are not over the limit. Once all the values are correct, you can import the Excel file in Sharegate to perform the copy using the updated metadata.