This page explains how to configure a SharePoint list column so that email addresses display as clickable mailto: links — useful for any ALTA team member who manages SharePoint lists and wants to improve usability for end users.
You can make edit to allow clickable email in a SharePoint list by going to List > List Settings.
Then you can scroll down to choose a column that you use for email and click on it.
Next, please enter this JSON code into the
"Column Formatting" box and click "Ok" to save your progress. {"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "@currentField", "attributes": { "href": "='mailto:' + @currentField"}
Made with DASH A.i.This three-step process uses SharePoint's built-in Column Formatting feature to convert a plain-text email column into a clickable hyperlink. No coding experience is required — you simply paste a JSON snippet into the formatting box.
Column Formatting JSON — copy and paste this exactly:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "@currentField",
"attributes": {
"href": "='mailto:' + @currentField"
}
}
Before you paste: Make sure the column type is set to Single line of text (not "Person or Group"). Person/Group columns have a different formatting schema. If your column is already storing plain email addresses as text, you're good to go.
Testing your change: After saving, return to the list view and click an email address. Your default mail client (e.g., Outlook) should open a new message pre-addressed to that contact. If nothing happens, double-check that the JSON was pasted without extra spaces or line breaks outside the curly braces.
Reverting the format: If you need to undo this change, go back to the same Column Formatting box, clear all the JSON, and click OK. The column will return to plain-text display.
0 files attached to this page