A very recent blog post and update came out from Microsoft which revealed you can now do something I know some people have wanted to do for the longest time – change the format of a field. Historically if you make a field a “Phone Number” or an “Email” then you’ve always been stuck with it in that same format which I’ve seen cause problems for people when they realise they were wrong.

Now, you can change that through the Dataverse API which you can read more about here: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/data-type-format-conversions

However… no-one wants to write bespoke code for little things like this and right now the User Interface of the maker portal still shows as ready only so I introduce to you my latest XrmToolBox tool – the Dataverse Format Changer.

Header tile of the tool

This tool does exactly what it says on the tin – allows you to select a number of columns in your table, change their formats and commit that to your Dataverse environment with a few clicks.

Screenshot of the tool

Firstly, you start by selecting the table you wish to edit in the top left which should populate the list of columns that are changeable. At the time of launch I’ve only included String and Memo but I will add the number/datetime ones in the coming days.

You can make the change using the drop down (thanks @Mark Carrington) which should show your request queued in the top right.

Example of queued changes

Once all your requests are queued, simply “Process Changes”. You’ll get an alert when all the changes have been processed – and if an error occurs it will also alert you of that too.

I know you’re going to try and change something to JSON so I can warn you now, if you do and it’s a relational table, it will error!

I’d love to hear your feedback on the tool. It is Open Source and you can reach me on Twitter or LinkedIn.

Finally, big thank you to Mark Carrington, Carl Cookson and Tanguy Touzard for your support during this development.


3 Comments

phillip dominey · November 28, 2022 at 3:32 pm

Hi
If I run the tool in my Dev environment then deploy the table in a solution will the field change in the target environment or do I have to run the tool against the target environment?

    Matt · June 19, 2023 at 12:08 pm

    Did you ever find your answer to this?

Introducing Dataverse Format Changer in XrmToolBox - 365 Community · September 13, 2021 at 10:16 am

[…] Introducing Dataverse Format Changer in XrmToolBox […]

Leave a Reply to Introducing Dataverse Format Changer in XrmToolBox - 365 Community Cancel reply

Avatar placeholder

Your email address will not be published. Required fields are marked *