Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Changing the Field typ...
Sales forum

Changing the Field type of Existing field

Posted on by Microsoft Employee

Hi,

I want to change the field type of ID column from String to whole number.

I cannot do directly, Is there any alternative of doing the same.

Please suggest.

Thanks 

Categories:
  • Suggested answer
    chrispytwist Profile Picture
    chrispytwist 235 on at
    RE: Changing the Field type of Existing field

    In case anyone else happens upon this in their searches. The XRMToolbox app Attribute Manager can change an attribute/column type. However, be aware that if existing data conflicts with the data type of the new attribute, that data will not come across.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing the Field type of Existing field

    Hi Guido Preite,

    Yes, you are right.

    Can you please let me know is it possible to enter the string field value (values are integer only but stored as string) into whole number field and can it be done by workflow. I need to update all the previous records as well.

    I want to avaoid the use of export and reimport or any console application for this purpose.

    Thanks

  • Verified answer
    Guido Preite Profile Picture
    Guido Preite 54,081 Super User 2024 Season 1 on at
    RE: Changing the Field type of Existing field

    you can't change the type of an existing field. If is a custom field you can eventually delete it (and it will remove the data inside the field) and create it again (and in case you need to copy the values, create the new field first, copy the value, delete the old field)

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans