This blog is part of a series on Teams. For more articles, check back often

Written: 09/01/2021 | Updated: N/A

The speaker circuit is getting ready to go this year. My speaking schedule is already loaded for January and February and then we’ll go straight into Ignite in March. It’s going to be a wild one. You know, like, boom. Now two areas I love speaking about – and spoke about a lot at the back end of 2020 – is Teams and Lists. It’s pretty well known I love both apps and I use them a lot. However, one issue I came across this week was that I was building a list in Teams and wanted to have a column of email addresses which I could click on and then it would begin composing an email. The use case was this – as part of my job heading up an education practice I have a number of trainers I work with, and the list serves as both a skills matrix but has the trainers contact details too. Think of this as a way I – or any other team member who uses the list – can track the trainers who work for me whilst being able to easily identify and contact one should a specific course opportunity come up. Now, I wanted to send an email straight from the list. The hyperlink column didn’t work: it threw an invalid URL and there is no email column option. So how can we make this work?

This blog will cover

  • How to create hyperlinked emailed addresses in the Lists app in Teams

Pre-requisites

  • Teams and SharePoint Licence (In an Office/Microsoft 365 Subscription)

HOW TO CREATE HYPERLINKED EMAIL ADDRESSES IN THE LISTS APP IN TEAMS

1.) In Teams, start out with your List and create select Add Column

2.) Select Single Line of Text

3.) Complete the create a column fly out on the right including a name of email address and description if required. Once complete select Save. The new email address column is now created

4.) Whether via Edit in Grid View or by Selecting each individual List Item add the email addresses and Save. The end result should be a completed column of fields with email addresses that are just text and are not hyperlinked

5.) Here is where the magic happens. Click on the email address column and select Column Settings and then Format this column

6.) Select Advanced Mode at the bottom of the format email address column fly out on the right

7.) Remove anything in the box, add the following JSON and select Save

{ “$schema”: “http://columnformatting.sharepointpnp.com/columnFormattingSchema.json”, “debugMode”: true, “elmType”: “div”, “children”: [ { “elmType”: “a”, “txtContent”: “@currentField”, “attributes”: { “href”: { “operator”: “+”, “operands”: [ “mailto:”, “@currentField” ] } } } ]}

8.) Our work here is done. The email addresses in the email column are now hyperlinked

9.) Once you click on one it will open Outlook and begin composing an email

10.) This also pulls through to the Lists web app.

To apply within the web app, follow the same process as above. Go to the Lists web app, select or create the List, create the email address column as a single line of text column, populate, click on the column, select column settings, format this column, apply the JSON and then save

A small but vital feature. Enjoy!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.