Sharepoint List (Tel and Mail Hyperlinks)

Question

Hi all, new to this place so please afford me a moment.

Sharepoint List

I've found methods on how to add a href to an email address. My main aim though is to use a column for email addresses + tel numbers. I basically have 3 columns named 'Comms 1, Comms 2 and Comms 3' - as the communication method will vary per vendor/org on the list with how much or how little information is available.

 

I currently have this for email - Sharepoint 365 - Adding clickable email to list - Microsoft Community Hub

 

 I wish to have a 'tel' condition, too and use both. So if the current field has a telephone number, then the 'tel' href will apply. If it is an email address, then the mailto href will apply (a conditional formatting json)

Please could someone give me some tips on how to accomplish this :)

Thank you :)

Answer 1

Hi @Greg Spinks ,

Per my test, the following Json code can be used in a column alone.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "txtContent": "@currentField",
  "attributes": {
    "href": "='tel:' + @currentField"
  }
}

But when I set the conditions, the effect is not very good, it cannot be performed as expected. You can use this method as a workaround first, I will continue to do some research, and I will update it as soon as there is any progress.

Thanks for your understanding!

Updated on 3/15/2023

You can use this code make conditions.

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "@currentField",
"attributes": {
"href": "=if(indexOf(@currentFeild, '@')<0, 'tel:' + @currentField, ' mailto:' + @currentField)"
}
}

---

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.