Forum Discussion
Solved
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? ...
jacobite Yes, it is possible to convert the text field to clickable text in list view using column formatting. Follow below steps:
- Create a single line of text field in your list to enter email address.
- From list view, select column name header, select "Column settings" and then select "Format this column".
- Click on "Advanced mode" from right side panel.
- 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.
jacobite Yes, it is possible to convert the text field to clickable text in list view using column formatting. Follow below steps:
- Create a single line of text field in your list to enter email address.
- From list view, select column name header, select "Column settings" and then select "Format this column".
- Click on "Advanced mode" from right side panel.
- 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.
Your solution is very useful. I have multiple persons in my Assigned to column and when i click on the link the email pops up with each person's email in the Send to: field. I need, if possible, to have each person receive an individual email as part of the Approval process.
In case of multiple selection person column, you will have to generate the mailto link for each user using "forEach" and click on each link manually to send email to respective user.
Check this JSON sample for your requirements: Multi-Person Mail To Link
Output:
Please consider giving a Like if my post helped you in any way.