web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Changing Field data type from singel line of text to multiline text

(0) ShareShare
ReportReport
Posted on by

I have a managed solution deployed in customer place, we had a "Single Line text" field in a custom entity, now we want to change the field type to "Multi line text" due to character limit.

how can we achieve this, without effect on schema

Please help

I have the same question (0)
  • Suggested answer
    ajyendra Profile Picture
    1,738 on at

    Hi,

    You cannot change the type of field after its creation.there is only one way is to create new field.

  • Rav_Singh Profile Picture
    75 on at

    Yes, there is no way to change the data type of a field once it is created.

    Only solution is to create a new field.

  • Suggested answer
    Naveen Ganeshe Profile Picture
    3,397 User Group Leader on at

    Hi,

    You cannot do this as Dynamics CRM does not allow to change the field datatype after field creation.

  • Suggested answer
    Rajesh Chungath Profile Picture
    467 on at

    Create a new singleline text filed and copy data from your existing filed to new filed. 

    Create a on demand workflow or console app,or xrm toolbox bulk update tool to update all records. 

    now delete the old filed and create a multi line text filed. You can use the same schema name. 

    There will not be any other impacts on existing customization. 

    Now copy the data from your dummy filed to the text field.

    Deployment 

    1) Create a new solution to add the dummy filed to the entity and do a managed deployment to the solution.

    2) Perform the Data copy from the existing filed to the dummy filed

    3) Create a new clone of the solution in the develop environment and remove the filed dependency from all forms, views etc. If the filed is existing in multiple solutions then it must removed from all solutions. Remove the filed from all cloned solutions

    4) new deploy all solutions to the target environment as managed

    5) Uninstall all old dependent solutions

    6) This will remove the filed from the target environment

    7) Now Increase the version number of the solution in development environment and create a new filed as multi line text and restore all removed customization

    8) deploy the solution to the target environment

    9) perform a data copy from dummy to the new filed

    10) Uninstall the dummy filed solution from the target environment 

        

     

  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at

    Hi,

    There is a tool in Xrm Toolbox to update the type of an attribute.

    Try that:

    www.xrmtoolbox.com/.../

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 83 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans