web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using PowerAutomate to...
Power Automate
Suggested Answer

Using PowerAutomate to bulk-upload Tasks into Planner - dates displaying incorrectly

(0) ShareShare
ReportReport
Posted on by
Date in excel file: 02/25/2026
PA Flow input: 2026-02-25T00:00:00.000Z
Power Automate Flow "output": 2026-02-25T00:00:00Z
Date displayed in Planner: 02/24/2026
 

I am pretty certain this has to do with something being set to UTC time zone, though I'm not clear on where exactly. The excel file that PowerAutomate is sourcing from is in OneDrive.

I have a workaround (add 5 hours to the date), so that the OUTPUT shows : 2026-02-24T05:00:00Z, which then displays in Planner as expected: 02/25/2026

Is anyone able to explain to me exactly why this is occurring, and if there is a better way to ensure the dates aren't changed during this process?

2024-12-04_17-00-22.png
Categories:
I have the same question (0)
  • Suggested answer
    David_MA Profile Picture
    13,241 Super User 2025 Season 2 on at
    What you are doing is what you need to do if it results in the correct date/time. You are on the right track with your thoughts on UTC, which is what dates are stored in within Microsoft 365. You can read about this at Date/time data and time zones - Finance & Operations | Dynamics 365 | Microsoft Learn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard