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.
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
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.
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
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
Hi @JasonSealy ,
Could you please tell me:
How does the user enter numbers? Canvas app or Model driven app?
Best Regards,
Bof
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1
stampcoin
9