SharePoint Document Issues

How to Fix ICS File Dates Generated from a SharePoint List

Anum MushtaqAnum Mushtaq Nov 2, 2026 868 views

Question details

The user needs to correct the start and end dates in an ICS file generated via a custom SharePoint JSON column link.

How to Fix ICS File Dates Generated from a SharePoint List
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.
Before you start

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.

Solution 1Recommended

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.

1
Find the Internal Column Names

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.

2
Update the JSON Formatting Code

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.

3
Apply ISO 8601 Date Formatting

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.

4
Save and Test the ICS File

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.

Correct the JSON Date Formatting and Column References
Time Zone Considerations: If the time is correct but offset by a few hours, verify that your SharePoint site's regional settings match your local time zone. JSON date formatting relies heavily on site-level regional configurations.
Free Microsoft Office 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. 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
  2. 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. 3. Edit Seamlessly: Open the downloaded file using WPS Spreadsheet to quickly review event times, filter columns, and format your schedule.
Easily open, view, and organize exported SharePoint calendar lists and CSV files.Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint formats.Free, lightweight, and features a familiar tabbed interface for seamless migration.
microsoft office alternative - wps office

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.