cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kosenurm
Super User
Super User

Change column type from text to number

Hi all,

 

We have a Dataverse table which has around 300k rows of data in it. 

 

We want to change one of the column types from Text to Number. If I delete the column which is text and create it again as Number, do I have to reimport all the data all over again?

 

Thanks

K.

1 ACCEPTED SOLUTION

Accepted Solutions
AhmedSalih
Super User
Super User

Hello, @Kosenurm, Create a new Formula Fx column and try to use the function Value(OldTextColumn) to the get the new values as Numbers.

 

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

View solution in original post

1 REPLY 1
AhmedSalih
Super User
Super User

Hello, @Kosenurm, Create a new Formula Fx column and try to use the function Value(OldTextColumn) to the get the new values as Numbers.

 

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,629)