question

JillH87-1503 avatar image
0 Votes"
JillH87-1503 asked JillH87-1503 commented

Create ICS file from Sharepoint Online List

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

office-sharepoint-online
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JillH87-1503 , 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?

0 Votes 0 ·

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 + '/'"

}

}

0 Votes 0 ·

0 Answers