Forum Discussion

jacobite's avatar
jacobite
Copper Contributor
Aug 03, 2022

Sharepoint 365 - Adding clickable email to list

Hi Guys - is there a way of adding a selectable/dynamic email address to a list where that address isn't part of the same domain as SharePoint i.e. the email address of a project partner / client? ...
Lists
Microsoft Lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Aug 04, 2022

    jacobite Yes, it is possible to convert the text field to clickable text in list view using column formatting. Follow below steps:

    1. Create a single line of text field in your list to enter email address.
    2. From list view, select column name header, select "Column settings" and then select "Format this column". 
    3. Click on "Advanced mode" from right side panel.
    4. Copy-paste below JSON on textbox by removing existing JSON and click Save

     

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

     

    Output: 

    Documentation: SharePoint column formatting 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

bryanfrumkin47's avatar
bryanfrumkin47
Copper Contributor
ganeshsanap
That was helpful, thank you.
In SharePoint column formatting, can you directly embed images in the email body using HTML content within a mailto link, or does The mailto link only supports plain text content and not support HTML formatting or embedded images?
ganeshsanap's avatar
ganeshsanap
MVP
Aug 30, 2023

bryanfrumkin47 You cannot pass the HTML, images, hyperlinks, or attachments using mailto protocol as it only accepts string/text values as input.

 

Check my answers at:

  1. Is there any way to pass html content while triggering mailto: option? 
  2. JSON formatting: make some words inside body text of email bold 
  3. How do I pass HTML table inside mailto in anchor tag? 
  4. SharePoint JSON email attachment 
  5. SharePoint JSON hyperlink text in email 

Please consider giving a Like if my post helped you in any way.

Resources