How to Fix ICS File Dates Generated from a SharePoint List
Question details
The user needs to correct the start and end dates in an ICS file generated via a custom SharePoint JSON column link.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Creating an 'Add to Outlook' calendar link using custom JSON column formatting in a modern SharePoint List.
- Observed behavior
- The generated ICS file ignores the list's Start Time and End Time values and incorrectly defaults to the current system date and time.
Verify that you are using the internal column names for your Start Time and End Time fields in your SharePoint List, as display names will not work in JSON formatting.
Correct the JSON Date Formatting and Column References
Fixing the JSON payload ensures that SharePoint correctly parses the start and end times into valid ISO 8601 timestamps for the ICS file.
When creating an 'Add to Outlook' link via column formatting, modern SharePoint requires strict adherence to valid date formats. If the JSON syntax is incorrect, or if you reference the column's display name instead of its internal name, SharePoint defaults to generating the ICS file with the current date and time.
Navigate to your SharePoint List. Click the gear icon (Settings) and select 'List settings'. Scroll down to the Columns section and click on your 'Start Time' column. Look at the URL in your browser's address bar; the internal name is the text that appears after 'Field=' at the very end of the URL. Repeat this for the 'End Time' column.
Return to your list view, click the column header where your 'Add to Outlook' link resides, select 'Column settings', and then 'Format this column'. Click 'Advanced mode' to view your JSON.
Ensure your JSON references the exact internal column names (e.g., '[$EventDate]' or '[$EndDate]'). Wrap the date references in a date formatting function if necessary, or ensure the SharePoint list stores them as strict Date/Time values so they output as valid ISO 8601 timestamps with the correct time zone.
Click 'Save' at the bottom of the formatting pane. Click the newly formatted link to download the ICS file. Open the downloaded file in a text editor like Notepad to verify that the 'DTSTART' and 'DTEND' lines display the correct event dates.

Use Power Automate to Generate the ICS File
If modern SharePoint JSON formatting proves unreliable for calendar generation, Power Automate offers a robust alternative.
Manage Your Calendar Events and Documents with WPS Office
While configuring backend SharePoint lists requires Microsoft's ecosystem, you might frequently need to export event data or manage spreadsheet lists. WPS Office provides a lightweight, powerful, and completely free alternative for handling your office documents and data exports.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Export Your SharePoint Data: From your SharePoint list view, click 'Export' and select 'Export to Excel' or 'Export to CSV' to download your calendar data.
- 3. Edit Seamlessly: Open the downloaded file using WPS Spreadsheet to quickly review event times, filter columns, and format your schedule.

Frequently Asked Questions
How do I find the internal column name in a SharePoint list?
Navigate to List Settings, click on the specific column name, and look at the web address (URL) in your browser. The internal name is the exact text following 'Field=' at the end of the URL.
Why does my SharePoint JSON link output the current date instead of the event date?
This happens when SharePoint cannot interpret the date value in your JSON. It usually occurs if you referenced the display name instead of the internal column name, or if the column type is not strictly defined as Date/Time. SharePoint falls back to the current system date when parsing fails.
Can I use classic SharePoint calendar views instead of JSON formatting?
Yes, classic SharePoint calendar views automatically support the creation of ICS items without custom code. However, embedding classic views within a modern SharePoint site can cause layout inconsistencies and integration problems.




