You’re offline. This is a read only version of the page.
Announcements
5
My flow is working all fine and as expected. My due date was originally populated correctly into Planner with the same formula. The only thing that has changed is I now have the Excel sheet hosted on SharePoint instead of OneDrive. The due date field is now coming up as 1 date ahead of the input date in Excel. I presume this is something to do with timezones but I'm unsure how to solve this.
E.g. excel date: 31/05/2024
Planner due date: 1/6/2024
Dates aren't matching.
Hi @natasha28 ,
Please subtract the regional time difference when creating a task.
It is better to say that I am in UTC+8 zone, then when I create the deadline, it should be addHours(items('Apply_to_each')?['DATE'],-8), start date It is addHours(addDays(items('Apply_to_each')?['DATE'],-7),-8).
Generally speaking, it is to subtract the time difference between your region and UTC.
Best Regards,
Sunshine Gu
Share
Report
All responses (
Answers (
