Dataverse Table Phone Number formatting and validation.

(0) Share

Report

Posted on by JasonSealy

Hello!

I am having trouble finding online how to format and validate phone numbers.

Validation: make sure the inputted number is exactly 10 digits

Formatting: the inputted number xxxxxxxxxx is formatted to (xxx)xxx-xxxx

Thanks, if anyone could help that would be great, I tagged the three below because they have been very helpful in past problems with Power Apps.

@EricRegnier

@dpoggemann

@ChrisPiasecki

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JasonSealy ,

Could you please tell me:

How does the user enter numbers? Canvas app or Model driven app?

Best Regards,

Bof

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @JasonSealy ,

You can use JavaScript validation on Form level by using Regex.
You can refer these steps: Blog | Logic and code will vary for you

You can also use Plugins when records Imported

Hope this helps

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @JasonSealy ,

Check out @EricRegnier response from a while back, is this helpful? https://powerusers.microsoft.com/t5/Microsoft-Dataverse/How-to-validate-phone-field-on-model-driven/td-p/601147

Was this reply helpful? Yes No
JasonSealy 65 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bofeng-msft,
1.) I was wondering if this data input could be done directly into the table itself (like how it would be done in excel) and not through an app.
2.) Is it bad practice to do it this way? If it is bad practice why is that?
For my purposes I think model-driven app is the right choice and I will look into doing that.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JasonSealy ,

1.) I was wondering if this data input could be done directly into the table itself (like how it would be done in excel) and not through an app.

You could do it in excel.

2.) Is it bad practice to do it this way? If it is bad practice why is that?

It can be done by JS , please check @Ethan_R and @dpoggemann 's answer.

Best Regards,

Bof

Was this reply helpful? Yes No