Fix Power Automate SharePoint Calendar Dates Showing One Day Early
Question details
Users experience an issue where dates submitted via Power Apps appear one day earlier when added to a SharePoint calendar by a Power Automate flow.
- Product
- Power Automate, SharePoint
- Device & OS
- not provided
- Scenario
- Creating or updating SharePoint calendar events using Power Automate flows triggered by Power Apps input.
- Observed behavior
- The calendar event dates are recorded as one day earlier than the exact date submitted by the user, typically due to time zone conversion errors.
Verify your current local time zone settings in both your SharePoint site's regional settings and your Power Apps environment before modifying the flow.
Adjust Time Zone Settings in Power Automate
Use the Convert Time Zone action to ensure dates passed from Power Apps match your SharePoint calendar's regional settings.
Power Apps generally stores and transmits date values in UTC format. If your SharePoint site is set to a different time zone, dates can roll backward to the previous day when processed by the flow. Correcting this requires explicitly converting the time zone within the flow.
Open your Power Automate flow and find the specific step where the date value is passed from Power Apps to your SharePoint calendar action.
Insert a 'Convert time zone' action immediately before the SharePoint step. Set the 'Base time' to the dynamic date content coming from Power Apps.
Set the 'Source time zone' to UTC (Coordinated Universal Time) and the 'Destination time zone' to match your local SharePoint site's regional time zone setting.
Modify your 'Create item' or calendar event action in SharePoint to use the converted time output from the 'Convert time zone' step instead of the original Power Apps date.
Consult the Microsoft Power Automate Community
If regional settings are correct but dates still shift, the issue may require specialized flow troubleshooting.
Looking for a Lighter Office Suite? Try WPS Office
While specialized enterprise workflows often require complex SharePoint and Power Automate setups, everyday document, spreadsheet, and presentation tasks can be handled more smoothly with WPS Office. It's a lightweight, free alternative that offers full compatibility with Microsoft Office file formats.
- 1. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Open Your Office Files: Launch WPS Office and directly open any existing Microsoft Office files exported from SharePoint or OneDrive.
- 3. Edit Seamlessly: Enjoy editing your documents, spreadsheets, and presentations with perfect formatting retention.
Frequently Asked Questions
Why does Power Automate change my dates when sending them to SharePoint?
Power Apps typically stores and transmits date and time data in UTC (Coordinated Universal Time). If your SharePoint site is configured to a different local time zone (like EST or PST), the discrepancy can cause dates to shift by a day depending on the time of submission.
How do I check my SharePoint calendar's regional settings?
Navigate to your SharePoint site, click the gear icon for Settings, select 'Site information', then 'View all site settings'. Under 'Site Administration', click 'Regional settings' to view or change the default time zone.
Can WPS Office be used alongside Microsoft SharePoint?
Yes. While WPS Office is a standalone desktop and mobile office suite, you can easily download your .docx, .xlsx, and .pptx files from SharePoint and edit them locally using WPS Office without losing any formatting.
