Applies to Product - Microsoft Dataverse
What’s happening?
Customers are unable to increase the character limitation for specific columns in Dataverse tables, particularly for primary name fields and other single line text fields, which are often restricted to a maximum of 255 characters or less.
Reason:
The inability to change the character length for certain fields is due to inherent limitations within the Dataverse environment. Specifically, once a field is created, its properties cannot be modified without deleting and recreating the field. Additionally, certain fields may have dependencies on other fields, which can prevent changes from being applied.
Resolution:
- For primary name fields in out-of-the-box (OOTB) tables, the maximum length is set to 255 characters and cannot be changed.
- For other single line text fields, if an attempt to increase the character limit results in an error, it is recommended to:
- Check if the field is part of a calculated field or if it has dependencies on other fields. If so, remove those dependencies before attempting to change the character limit.
- If the error persists, consider reducing the number of columns in the entity or setting the character limit to under 450 characters to avoid exceeding index size limits.
- If necessary, create a new field with the desired character limit and migrate data from the old field to the new one, ensuring that all dependencies are addressed.