Skip to main content

Notifications

Community site session details

Community site session details

Session Id : PPl8gKqJkN7GQH6Y2478WR
Power Apps - Microsoft Dataverse
Unanswered

Dataverse Table Phone Number formatting and validation.

Like (0) ShareShare
ReportReport
Posted on 29 May 2023 18:43:38 by 65

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:
  • v-bofeng-msft Profile Picture
    on 31 May 2023 at 01:23:45
    Re: Dataverse Table Phone Number formatting and validation.

    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.

    vbofengmsft_0-1685496182515.png

     

    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

  • JasonSealy Profile Picture
    65 on 30 May 2023 at 16:05:34
    Re: Dataverse Table Phone Number formatting and validation.

    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.

     

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 30 May 2023 at 09:57:47
    Re: Dataverse Table Phone Number formatting and validation.

    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 

  • Ethan_009 Profile Picture
    4,838 Super User 2025 Season 1 on 30 May 2023 at 04:38:19
    Re: Dataverse Table Phone Number formatting and validation.

    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

  • v-bofeng-msft Profile Picture
    on 30 May 2023 at 02:35:00
    Re: Dataverse Table Phone Number formatting and validation.

    Hi @JasonSealy ,

     

    Could you please tell me:

     

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

     

    Best Regards,

    Bof

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#2
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 9

Overall leaderboard

Featured topics