Answered

Is there anyway to remove commas from Numerical data types

(0) Share

Report

Posted on by Benjy_97

Client has asked that the commas displayed for Northings and Eastings in this view be removed to more accurately represent coordinates. We have discussed the possibility of making it a text field, however, there are numerous dependencies within a PowerApp and other processes such as locational algorithms and what3words that require numbers and it will break a lot of stuff to change it to text.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

AhmedSalih

6,678 Moderator on at

Like (1)

Report

Hello, @Benjy_97, the best way to do this, is to change your system setting number format:

Set the Digit Grouping Symbol to Blank:

** Don't forget to Publish All Customization after this change.

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

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

stevenpetersmi 207 on at

Like (0)

Report

Is there a way to avoid the system setting as I just want one column to have numbers to remove commas but keep the rest of the commas for another column?

Was this reply helpful? Yes No
VidyadharB 4 on at

Like (1)

Report

@stevenpetersmi Use calculated column or formula column(fx) to achieve your requirement

Example by using formula column in dataverse

If my reply helped you, please give a
, & if it solved your issue, please
& Accept it as the Solution to help other community members find it mor
Visit my Blog:VidyadharB

Was this reply helpful? Yes No
stevenpetersmi 207 on at

Like (0)

Report

Does that mean I have to create a new column? and change into text version. not decimal one

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

HI @Benjy_97

Yes you need to create a field with TEXT and You can use Flow/Process/Plugin/JS to update the same value

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Verified answer

stevenpetersmi 207 on at

Like (1)

Report
Thanks for the details, I have used javascript and it is working fine.
function ValidateNumberOnly(executionContext) { 'use strict'; var formContext = executionContext.getFormContext(); var fieldText = formContext.getAttribute("numberonly").getValue(); if (fieldText === null) return; if (!fieldText.match("^[0-9]*$")) { formContext.getControl("numberonly").setNotification("Please enter only numbers", 102); return false; } else { formContext.getControl("numberonly").clearNotification(102); return true; } }

Was this reply helpful? Yes No