Scheduling Dialog Links to MS Teams and Outlook

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "display": "flex", "flex-direction": "row" }, "attributes": { "class": "ms-fontSize-xxl" }, "children": [ { "elmType": "a", "style": { "text-decoration": "none" }, "attributes": { "href": "= 'https://teams.microsoft.com/l/meeting/new?subject=' + [$Title] + '&content=' + [$Content] + '&startTime=' + getYear([$Start])+'-'+padStart(toString(getMonth([$Start])+1),2,'0')+'-'+padStart(toString(getDate([$Start])),2,'0')+'T'+if(indexOf(toLocaleTimeString([$Start]),'PM')!=-1,padStart(toString(Number(substring(toLocaleTimeString([$Start]),0,indexOf(toLocaleTimeString([$Start]),':')))+12),2,'0'),padStart(substring(toLocaleTimeString([$Start]),0,indexOf(toLocaleTimeString([$Start]),':')),2,'0'))+':'+substring(toLocaleTimeString([$Start]),indexOf(toLocaleTimeString([$Start]),':')+1,indexOf(toLocaleTimeString([$Start]),' ')) + '&endTime=' + getYear([$End])+'-'+padStart(toString(getMonth([$End])+1),2,'0')+'-'+padStart(toString(getDate([$End])),2,'0')+'T'+if(indexOf(toLocaleTimeString([$End]),'PM')!=-1,padStart(toString(Number(substring(toLocaleTimeString([$End]),0,indexOf(toLocaleTimeString([$End]),':')))+12),2,'0'),padStart(substring(toLocaleTimeString([$End]),0,indexOf(toLocaleTimeString([$End]),':')),2,'0'))+':'+substring(toLocaleTimeString([$End]),indexOf(toLocaleTimeString([$End]),':')+1,indexOf(toLocaleTimeString([$End]),' '))", "target": "_blank", "iconName": "TeamsLogo", "class": "ms-fontColor-themePrimary" } }, { "elmType": "a", "style": { "text-decoration": "none", "margin-left": "15px" }, "attributes": { "href": "= 'https://outlook.office.com/owa/?path=/calendar/action/compose&subject=' + [$Title] + '&body=' + [$Content] + '&startdt=' + getYear([$Start])+'-'+padStart(toString(getMonth([$Start])+1),2,'0')+'-'+padStart(toString(getDate([$Start])),2,'0')+'T'+if(indexOf(toLocaleTimeString([$Start]),'PM')!=-1,padStart(toString(Number(substring(toLocaleTimeString([$Start]),0,indexOf(toLocaleTimeString([$Start]),':')))+12),2,'0'),padStart(substring(toLocaleTimeString([$Start]),0,indexOf(toLocaleTimeString([$Start]),':')),2,'0'))+':'+substring(toLocaleTimeString([$Start]),indexOf(toLocaleTimeString([$Start]),':')+1,indexOf(toLocaleTimeString([$Start]),' ')) + '&enddt=' + getYear([$End])+'-'+padStart(toString(getMonth([$End])+1),2,'0')+'-'+padStart(toString(getDate([$End])),2,'0')+'T'+if(indexOf(toLocaleTimeString([$End]),'PM')!=-1,padStart(toString(Number(substring(toLocaleTimeString([$End]),0,indexOf(toLocaleTimeString([$End]),':')))+12),2,'0'),padStart(substring(toLocaleTimeString([$End]),0,indexOf(toLocaleTimeString([$End]),':')),2,'0'))+':'+substring(toLocaleTimeString([$End]),indexOf(toLocaleTimeString([$End]),':')+1,indexOf(toLocaleTimeString([$End]),' '))", "target": "_blank", "iconName": "OutlookLogo", "class": "ms-fontColor-themePrimary" } } ] }

From the contributor

How to use this sample

Summary

This sample demonstrates creating deep links to the scheduling dialog in Microsoft Teams and Microsoft Outlook.

screenshot of the sample

View requirements

This format can be applied to any column type but expects the following columns to be part of the view:

Type	Internal Name	Required
Single line of text	Title	Yes
Multiple line of text	Content	No
Date and Time	Start	Yes
Date and Time	End	Yes
Calculated Column	FormattedStart
Calculated Column	FormattedEnd

You need FormattedStart and FormattedEnd Calculated Columns so that it shows ISO 8601 format date. The formula for these calculated columns is below:

=TEXT([Start],"yyyy-mm-ddThh:mm:ss")

=TEXT([End],"yyyy-mm-ddThh:mm:ss")

Advanced Format

Alternatively, an additional format (generic-scheduling-link-advanced.json) is included that will eliminate the need for the Calculated Columns (FormattedStart & FormattedEnd). This is done by parsing the results of the toLocaleTimeString operation and is assuming results return in the format h:mm:ss tt (12 hour clock with minutes, seconds, and the ante/post meridiem indicator). This matches the local time format in the United States and several other countries.

These formulas have been put into the separate format because they are difficult to read and are not universally applicable. If you are targeting multiple regions with varying locale formats it is advised to use the calculated columns and the standard version of the format.

Sample

Solution	Author(s)
generic-scheduling-link.json	Tetsuya Kawahara
generic-scheduling-link-advanced.json	Tetsuya Kawahara & Chris Kent

Version history

Version	Date	Comments
1.0	January 28, 2021	Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Additional notes

Create deep links to content and features in Microsoft Teams

Get this format

How to use this sample

Summary

View requirements

Advanced Format

Sample

Version history

Disclaimer

Additional notes

More formats like this

Missing Information Callout

Publishing Status

File Preview Callout with the embed Action