Formatting Phone Number on Edit Form

(0) Share

Report

Posted on by EBMRay

1,712

Hello,

I have two separated SharePoint lists that contain the following columns:

List A:
Column:

Suppliers(Type: Lookup List B/Supplier Name)
PhoneNumber (Type: Number)

List B:
Column:

Supplier Name(Type: Single Line of text) and Phone Number(Type: Number)

When the user selects a particular supplier the phone number field will be populated based on the supplier selected.

The issue is the phone number is displayed in this format 96,112,312,312 which is wrong.

In PowerApps:

(The second column is how it should be displayed but this is a calculated column and I have no idea why it's returning blank when I map this column in the formula).

What I want to achieve is the following:

When the phone number is populated I want to display the phone number in this format (###)-##-###-### as it shows in the screenshot that I posted.

I have tried to use the following formula in the Default property of the Datacard (because it's on edit form) but it doesn't affect the results and it shows as a blank field.

LookUp(POSuppliers, Title = DataCardValue19.Selected.Value, Text(PhoneNumber, "[$-en-US](###)-(##)-(###)-(###)") )

What is the right formula that will display the phone number format that I mentioned?

Can someone please provide an example?

Any help will be greatly appreciated.
Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

GarethPrisk 2,828 on at

Like (1)

Report
Copy link

Link copied!

The code you have to reformat the number column to a phone format is correct.
However, phone numbers are inherently not numbers (could have leading 0's, typically have hyphens and parenthesis, etc.) Are you able to change your columns to store the phone numbers as strings/text? I realize this may not be possible, but it will save you potential hassle down the road.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Julien2 ,

Is the PhoneNumber field a Number type column in your SP List (List B)?

Based on the formula that you mentioned, I think the formula that you mentioned is proper. I think this issue is related to the Format property of the Text Input box within the Tel data card.

If the PhoneNumber field is a Number type column in your SP List, the Format property of the TextInput box within the Tel Data card would be set to TextFormat.Number in default. But the Text function returned is a Text value rather than a Number value, so the Tel Text Input box would show up Blank in your Edit form.

As fixed solution, please change the Format property of the TextInput box within the Tel Data card to following:

TextFormat.Text

then the formatted Phone Number value would be displayed as below:

If the issue still exists, please modify your formula as below:

Text( LookUp(POSuppliers, Title = DataCardValue19.Selected.Value).PhoneNumber, "[$-en-US](###)-##-###-###" )

Best regards,

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

Like (0)

Report
Copy link

Link copied!

Hi,
Same problem I'm also facing, I have PhoneNumber field is Single line of Text type column in my SP List and I tried that approach which are you mentioned like "PhoneNumber" field Default property set as Text(Parent.Default,"[$-en-US]###-###-####") (Because I want "123-345-4567" this format) but it's not working. Please advise me what kind of mistake I did.

Was this reply helpful? Yes No