Remove Commas From Dataverse Number Field

While working on a Power Apps Model-Driven App, the Contact Number field was created as a Number column in Dataverse. However, the numbers were displayed with commas as thousand separators, which made the contact numbers look confusing. The requirement was to remove these commas and display the numbers as a clean, continuous string.

In this Dataverse tutorial, I will show you how to remove commas from a Dataverse Number field.

Remove Thousand Separator from Dataverse Number Column

The screenshot below shows a Dataverse Number field named Contact Number. Initially, the numbers in this field were displayed with commas as thousand separators, such as 993,542,662, whenever a user entered a numeric value.

After removing the thousand separators, the numbers now appear as a continuous string without commas, like 993542662, making them easier to read and use.

For this example, I created a Dataverse table named Job Seekers Registration List. This list includes several fields, including a Number field called Contact Number.

Right now, the numbers in this field have commas, like 993,542,662, which doesn’t look clean.

To make it easier to read as a contact number, we need to remove all the commas. Follow the steps below to do this.

To do this, follow the steps below:

1. Go to the Power Apps portal. Click the Gear icon in the top-right corner, then select Advanced Settings.

2. On the next page, click the Gear icon again at the top right, and then select Options.

Then, a Set Personal Options window will appear. Here, you can change the default display settings to personalize Microsoft Dynamics 365 and manage your email templates.

You can view numerous tabs in this window, including General, Synchronization, Activities, etc. In the settings window, each and every option tab has a different set of unique settings.

3. Click on the Formats tab, then select the Customize button. The Current Format field will show a default value, such as English (United States). You can change this format by choosing another option from the dropdown menu.

4. In the Customize Regional Options pop-up, expand the Digit Grouping Symbol dropdown and select the blank value. Then, expand Digit Group and select 123456789.00.
5. Once everything is done, click on the Apply button.

You may now view the modified Number Format preview under the Number Format Preview section. Finally, click on OK.

After clicking the OK button, you will return to the Set Personal Options window. Here, you can review the Format Preview of all your settings. Once confirmed, click OK.

Next, open your Dataverse table (Job Seekers Registration List) and refresh it. You will now see that all the numbers no longer have commas as thousand separators.

This way, you can remove commas from a Dataverse Number field. For such requirements, I recommend using a Single Line of Text column for phone numbers instead of a Number field.

Additionally, you may like some more of the following Dataverse tutorials:

• Detect Text in Dataverse Using AI Builder
• Set Autonumber for Primary Name Column in Dataverse
• Create a Dataverse Table from Excel or CSV in Power Apps
• AttachmentContentNotValidBase64String Error in Power Automate
• Filter Power Apps Gallery By Dataverse Choice Column