Create ICS file from Sharepoint Online List

JillH87 1

Hi,

I posted the question below on another Microsoft Community forum and was signposted here instead. I have created a list in modern Sharepoint Online for events with a column with a link to download an ics file for users to add the event to their own Outlook calendars (this is to get around limitations with the built-in Events and Calendar webparts).

It's close to working but the ics file (created using JSON) doesn't pick up the start and end times from the columns in the list. If anyone has any suggestions on how to rectify that they would be much appreciated

https://answers.microsoft.com/en-us/msoffice/forum/all/creating-ics-file-from-a-sharepoint-list/712d53c9-a3a2-45cb-a746-00f61978dc74

Thanks

Elsie Lu_MSFT 9,756 Reputation points

2021-04-30T06:26:03.087+00:00

Hi @JillH87 , welcome to Q&A forum!

Based on the description, would you like to share the JSON you use with us to do some tests and research?
JillH87 1 Reputation point

2021-04-30T17:48:38.973+00:00
I have removed the Site Address and List ID from the code below

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "a",

"txtContent": "[link text]",

"attributes": {

"target": "_blank", "href": "=’[Site Address]/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List=[LISTID]&CacheControl=1&ID=' + [$ID] +'&Using=event.ics' +@currentField + '/'"

}

}