How can I make my phone number column pick up numbers correctly?

Question

How can I make my phone number column pick up numbers correctly?

Tevon2.0 1,106

SharePoint Server 2019 On Primise

I am trying to set up a column so that when a user adds an item to my SharePoint list; the home phone column will set the inserted number as in the format of (000)-000-0000

I thought to use the formula below but that didn't work.

=TEXT([Home Phone],"(000)-000-0000")

I also tried to set in the rules below to restrict numbers to 10 digits long.

Formula for Phone number column validation

=LEN(Home Phone)=10

User Message for Column Formula

Home Phone Number must be exactly 10 Digits Long

Is it possible to utilize multiple formulas in a column? If not which is a better option for a phone number column?

Theodoros Yiorkas 35 Reputation points

2024-03-24T18:01:51.3+00:00

@Xyza Xue_MSFT How can I make this a clickable link?

Accepted answer

1 additional answer

Your answer

Theodoros Yiorkas 35 Reputation points

2024-03-24T18:01:51.3+00:00

@Xyza Xue_MSFT How can I make this a clickable link?

Answer 1

Xyza Xue_MSFT 30,176 Microsoft External Staff

Hi @Tevon2.0 ,

Set the Home Phone column in the format of (000)-000-0000, which can be achieved through JSON format:

User's image


{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "a",
      "style": {
        "padding-right": "8px",
        "display": "=if(indexOf(@currentField,'@') > -1, 'block','none')"
      },
      "txtContent": "@currentField",
      "attributes": {
        "target": "_blank",
        "href": {
          "operator": "+",
          "operands": [
            "mailto:",
            "@currentField"
          ]
        }
      }
    },
    {
      "elmType": "span",
      "txtContent": "=if(indexOf(@currentField + '^', '^') == 10,'('+substring(toString(@currentField),0,3)+') '+substring(toString(@currentField),3,6)+'-'+substring(toString(@currentField),6,10),if(indexOf(@currentField + '^', '^') == 7,substring(toString(@currentField),0,3)+'-'+substring(toString(@currentField),3,8),@currentField)",
      "attributes": {
        "class": ""
      }
    }
  ]
}

User's image

The steps to set the Home Phone number must be exactly 10 digits are as follows:

List settings->Validation settings->=LEN([Home Phone])=10

User's image

In this way, at the same time, the Home Phone column can be set in the format of (000)-000-0000 and the length of the restricted number must be 10.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Cipriano, Michael 0 Reputation points

2023-07-19T16:20:39.1566667+00:00

This was extremely helpful, specific to phone numbers. I want to do something similar in another number column where I have 17 digit numbers and I'd like to format to:

Cipriano, Michael 0

Disregard!

I was able to get there with this:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "a",
      "style": {
        "padding-right": "8px",
        "display": "=if(indexOf(@currentField,'@') > -1, 'block','none')"
      },
      "txtContent": "@currentField",
      "attributes": {
        "target": "_blank",
        "href": {
          "operator": "+",
          "operands": [
            "mailto:",
            "@currentField"
          ]
        }
      }
    },
    {
      "elmType": "span",
      "txtContent": "=if(indexOf(@currentField + '^', '^') == 17,substring(toString(@currentField),0,3)+'-'+substring(toString(@currentField),3,10)+'-'+substring(toString(@currentField),10,17),@currentField)",
      "attributes": {
        "class": ""
      }
    }
  ]
}

Kevin Morenzi 0 Reputation points

2023-10-10T14:50:08.78+00:00

Worked, but took a while for it to save! Anyone else have this issue?
Christa Anderson 0 Reputation points

2023-10-18T13:36:56.8966667+00:00

This worked great, the column is setup just as described. Is it possible to enable this phone number column to allow cell phone users of this Sharepoint page to click on the number in the column and the phone will recognize it and suggest to dial the number? I tried on my phone and the way I set it up, it does not suggest dialing it. I used NUMBER as the column type.
63608335 126 Reputation points

2023-11-27T16:34:27.2033333+00:00

Great post. Thanks
Tony French 0 Reputation points

2024-08-30T18:22:03.2+00:00

I have been just trying to get my numbers formatted on my sharepoint list.
I have SLT coloumn, imported from excel that has 10 digits.

Where do I modify this JSON just for the phone number formatting. I see and understand the txtcontent, but when I type that in by itself it dosent work.

Answer 2

rosa 0

pero nunca me dijeron que como me comunico con ustedes

Share via

How can I make my phone number column pick up numbers correctly?

1 additional answer

Your answer