Views:

What's happening?

Unable to delete certain records from a custom table due to an error indicating that string or binary data would be truncated.

Reason:

This behavior occurs because the data in a specific column exceeds the maximum allowed character limit, causing a truncate error. Specifically, the column data length is larger than the defined maximum character count.

Resolution:

To resolve this behavior, follow these steps:

  1. Navigate to Power Apps and select your environment.
  2. Click Tables, then select the affected table.
  3. Select Columns, then select the problematic column.
  4. Expand  "Advanced options".
  5. Increase the "Maximum character count" to accommodate the data length.
  6. Save and publish the change
  7. After updating the maximum character count, proceed to delete the records again.

Following these steps will allow the records to be updated and subsequently deleted successfully.