"String or binary data would be truncated" error when deleting records from a custom table

This article provides guidance on resolving an error that occurs when you try to delete records from a custom table in Dynamics 365 Customer Service.

Symptoms

When you try to delete records from a custom table, you receive the following error message:

String or binary data would be truncated.

The error message usually specifies the table and column that cause the truncation error.

Cause

The issue occurs because the data in one or more columns exceeds the maximum allowed character limit for those columns. Specifically, the data length in the affected column(s) is larger than the defined maximum character count.

Resolution

To resolve this issue, follow these steps:

1. Select your environment in Power Apps.

2. In the left navigation, select Tables, and then select the table where the error occurs.

3. Select Columns, and locate the problematic column.

4. Expand Advanced options for the selected column.

   Tip

   You can also find the Advanced options in the table designer.

5. Increase the Maximum character count to accommodate the data length.

6. Save and publish the changes.

7. After updating the maximum character count, proceed to delete the records again.

If increasing the maximum character count doesn't solve the issue, you can try truncating the data in the column before deleting the records.