How to set field validations on Phone, Text field....

[skolisetti]

Hello, 

Can you advise how to set field validations on Model driven apps. I've table with 2 fields Order no and desc..

Order no should only accepts numericals and if we enter characters it should display tool tip saying "Characters not allowed"

And also for description field accepts only characters without numerical values. 

PFA

@Prakash4691 

[Mira_Ghaly]

@skolisetti 

To apply these type of validations you need to use JavaScript with Regular Expressions.

[skolisetti]

Any example of reference please ?

[Mira_Ghaly]

@skolisetti 

1. Open your form -> Switch to classic mode

2.Choose the field you want to run the validation upon and double click and go to the Events Tab and click Add

Click New

Give your file a name, select JS and Then Select Text Editor

Below is a sample javascript function to validate against regular expression

function ValidateAgainstRegularExpression(executionContext) {
    'use strict';
    var formContext = executionContext.getFormContext();
    var fieldText = formContext.getAttribute("FieldName").getValue();

    if (fieldText === null) return;

    if (!fieldText.match("^[0-9]*$")) {
        formContext.getControl("FieldName").setNotification("Please enter only Numbers", 102);
       
        return false;
    }
    else {
        formContext.getControl(fieldName).clearNotification(102);
        return true;
    }
       
}

You need to replace the field name with the field name you are validating against and the above regular expression matches numbers.

File now should be added to the form as below:

Click on Add Event-> Add the function name and set pass execution parameter and click ok, Then save and publish your form

Hope this helps!

[skolisetti]

Thank you I’ll try and update again . 

[skolisetti]

Thank you i've used input mask instead of Javascript

[EricRegnier · Accepted solution]

Hi @skolisetti, you might not need JavaScript. I assume your field type is single line of text. You can easily format to phone by with the Input Mask control. Here are the quick steps:

1. Open your solution that contains that entity and open the main form. Click the "switch to classic" button on the top
2. Select the phone number field and click "Change Properties"
3. Navigate to the Controls tab and click on "Add Control"
4. Select "Input Mask" and click add
5. Pick you field for the Field property
6. Enter the mask (00000000000) for the Mask property. You can also put dashes
7. Ensure the Input Mask control is selected for Web, Phone and Tablet.
8. Save all and publish all customization

Hope this helps! 

[chaffee]

The input mask is retired!

[EricRegnier]

Hey @chaffee, this solution dates back to 2021… not aware it is now retired but I checked the documentation and it doesn’t seem so, see https://learn.microsoft.com/power-apps/maker/model-driven-apps/additional-controls-for-dynamics-365-... 

Where did you see it was retired? Cheers!

[MD7]

Hi @Mira_Ghaly 

Are you able to take a look at my error here please: https://stackoverflow.com/questions/76787526/js-script-error-cr0c5-projectid-is-not-defined