When attempting to copy an item, Sharegate displays the following error:
The text value is invalid, probably because it exceeds the 255 character limit.
|Any error code ending with: -118|
The error occurs because the specified value is not valid for a text column. The most common cause for this is if the value exceeds 255 characters, which is the limit set by SharePoint for the value of a Single line of text column.
There are 2 possible solutions to this issue:
- 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.
- 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.