Formatting Phone Number i.e (###)-###-###

(0) Share

Report

Posted on by Nani

Hello guys,

I hope everyone is doing great !

This is Raj, Here I am working on App and I have a requirement to format the Phone number in such a way that (###)-###-####.

Will , Any one please help me in that .

Thank you in advance,

Raj

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

like this?
Text= Text(Value(TextInput1.Text),"[$-de-DE](000)-000-000")

Was this reply helpful? Yes No
Nani 18 on at

Like (0)

Report
Copy link

Link copied!

Hai Markus,
Thank you very much for your reply,

As you mentioned in reply Text= Text(Value(TextInput1.Text),"[$-de-DE](000)-000-000") is it only for "Text" data type , or any other data types like "Phone" . Because In my app I used Phone Datatype to PhoneNumber (Field).And it is Showing HtmlText instead Text. Will you help me with this scenario.
Thank you
Raj

Was this reply helpful? Yes No
AndyPennell Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Markus' suggestion will only work for numeric fields.

PowerApps have no concept of a "Phone" data type. Your data source will be exposed such a field as either a Text or Number.

If it is Text then you can format it using the various string operators.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

there is a different in view and edit, in view there is htmltext used.
but because there is showing ABC it seems a string/alphanumeric is used for phone type so Brackets and Plus/Minus can be saved with number. this "a href" is a web link with url. if you click the app for registered "tel:" opens.
i believe a formatted input control is on the wishlist.
maybe using 3 textinput boxes and make a new string with it, but its not user friendly.
you can add extra data area with your own components that not direct belongs your recordset if you will make tel. no. input.

Was this reply helpful? Yes No
Nani 18 on at

Like (0)

Report
Copy link

Link copied!

Hai Markus,
Thank you very much for your help.

Raj

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Nani
ok, i hope i helped, i am new to powerapps myself since 2-3 weeks 🙂

Was this reply helpful? Yes No
DrJasonScalmato 2 on at

Like (0)

Report
Copy link

Link copied!

The Air Mail Envelope on the Floor

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Nani
Yes, you can automatically format a phone number as the user types it by creating an “input mask.” It’s amazing to watch the phone number dashes appear automatically as you type! Check out this article to learn how.

Link to article:

https://www.matthewdevaney.com/power-apps-phone-number-formatting-in-a-form-input-mask/

Was this reply helpful? Yes No
Bstanley 6 on at

Like (0)

Report
Copy link

Link copied!

I must be missing something. I did exactly as written and the phone number does not appear. In fact after each digit is input, it disappears. There is a problem with one of the formulas but i cannot figure it out. Please Help!

Was this reply helpful? Yes No
HEATFreight 1,024 on at

Like (0)

Report
Copy link

Link copied!
Hi all!

I didn't like the complexity or functionality of any of the solutions I have found for this, so I wrote my own as follows. To start with I have hardcoded the output of a "Get My O365 Profile" request into a collection. I removed the O365 profile connector from my canvas apps and flow because I found it to be massively lagging the app launches, thus the hard-coded O365 profile JSON collected into the table which I'll be working with in the following code:
Concat(FirstN(Split(First(colO365Profile.mobilePhone).mobilePhone,""),3),ThisRecord.Result)&"-"& Concat(LastN(FirstN(Split(First(colO365Profile.mobilePhone).mobilePhone,""),6),3),ThisRecord.Result)&"-"& Concat(LastN(Split(First(colO365Profile.mobilePhone).mobilePhone,""),4),ThisRecord.Result)

This gives us a ###-###-#### format, but of course you could easily get other formats like:
"("& Concat(FirstN(Split(First(colO365Profile.mobilePhone).mobilePhone,""),3),ThisRecord.Result)&") "& Concat(LastN(FirstN(Split(First(colO365Profile.mobilePhone).mobilePhone,""),6),3),ThisRecord.Result)&"-"& Concat(LastN(Split(First(colO365Profile.mobilePhone).mobilePhone,""),4),ThisRecord.Result)
to get (###) ###-#### format.

The other solution I saw were here and here.

I was unable to get phone number input masking working for the default value of a text input field, which I'm prepopulating with calculated values from other fields and from that hard-coded O365 profile collection. It seems that input masking only works for labels and other non-editable fields, as I think I've seen others mention as well.

The above method is simple, quick, and easy code that's not difficult to parse. I couldn't parse the more complicated solutions at a glance, so that's a no-go for me, especially when an easier solution for my use case is so easily doable.

Hope it's helpful!

Was this reply helpful? Yes No