Data Type regarding

[ELango]

We know that there is a datatype called phone . As we Know phone number contains only number but phone datatype can also accepts Alphabets

Is there any solution  of Phone number to accepts only number.

[DeviKrishna]

Hi @ELango ,

The Phone number field is set to Text to enable some formatting on the phone numbers like 

+91-9999999999

(001) -0033-123456

To allow only numbers, Add the field on form and change the Text Format in Properties to Number. Refer below screen.

This works 🙂

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/

My Youtube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A

Regards
Devi

[ELango]

I Gave  Phone Datatype only but it will also accepts String 

[DeviKrishna]

Hi @ELango ,

Please change the Text Format to Number. Refer below screen shot.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/
My Youtube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A

Regards
Devi

[ELango]

I don't want to Use in canvas app ,I have to use only Model driven App

[rampprakash · Accepted solution]

Hello @ELango,

Hope you are doing good.

As per OOB Behavior the phone number field will accept both text and numbers too. For Avoiding that we can use JavaScript on onChange of phone number field.

//MObile Number Validation
function MobileNumberOnChange(executionContext) {
    var formContext = executionContext.getFormContext();
    var phoneNo = formContext.getControl("mobilephone").getValue();
    phoneNo = phoneNo.replace(/\D/g, '');
    formContext.getAttribute('mobilephone').setValue(phoneNo);
    if (phoneNo.length == 10) {
        var formattedPhone = phoneNo.replace(/(\d{3})(\d{3})(\d{4})/, '$1-$2-$3');
        formContext.getAttribute('mobilephone').setValue(formattedPhone);
    } else {
        formContext.getAttribute('mobilephone').setValue(null);
        alert("Please enter valid number");
    }
}

Trigger MobileNumberOnChange function in onchange of respective Fields and

Change mobilephone to your field logical Name

Note :

The Above script will trigger as follows

1. If you enter 99ABC88 --> Output 9988

2. If you enter 1234567891--> OutPut 123-456-7891

3. If you enter 1234567891011 --> Error

For Registering Script please find my step by step video: https://www.youtube.com/watch?v=x8kYNCkikgs&t=14s

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[DeviKrishna]

HI @ELango ,

Got it. You need to write a javascript code and validate the phone number field on form.

Please follow this blog.

https://www.adyatantech.com/blog/how-to-format-phone-number-using-javascript-in-dynamics-365

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/

My Youtube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A

Regards
Devi

[ELango]

Hi @rampprakash 

It show error like these

[DeviKrishna]

Hi @ELango ,

Please see if you have set the form properties as in below screen shot,

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/
My Youtube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A

Regards
Devi

[rampprakash]

Hello @ELango,

Can you please click Show Details and Download the log file and share here?

Hope you followed the YouTube link which i have sent 

Let me Give a quick View here.

1. Navigate to https://make.powerapps.com

2. Expand Tables

3. Open the Table where phone Number Field available

4. Click Fields and Copy the Logical name (it looks like cradf_phonnumber or new_phonenumber)

5. Click Forms --> Open Main Form

6. Click On the Field(PhoneNumberField) --> Click Events --> Click Add Event handler --> Write a function name and make sure you selected PASS PARAMETER AS EXECUTION CONTEXT

7. if in 6th Point your webresouce not available add the webresouce at the left Last Option Library

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com