Flow not writing to correct day/time in SharePoint calendar

%3CLINGO-SUB%20id%3D%22lingo-sub-994164%22%20slang%3D%22en-US%22%3EFlow%20not%20writing%20to%20correct%20day%2Ftime%20in%20SharePoint%20calendar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-994164%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%3EHi%20everyone%2C%20I'm%20hoping%20someone%20here%20can%20help%20me.%26nbsp%3B%20Here's%20the%20situation.%26nbsp%3B%20I%20created%20a%20Flow%20for%20PTO%20requests.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CUL%3E%3CLI%3EEmployee%20enters%20PTO%20request%20in%20SharePoint%20list%3C%2FLI%3E%3CLI%3EAn%20approval%20request%26nbsp%3Bemail%20is%20then%20sent%20to%20the%20employee's%20manager%20or%20director%3C%2FLI%3E%3CLI%3EOnce%20the%20manager%20approves%26nbsp%3Bthe%20request%2C%20an%20email%20is%20generated%20to%20let%20the%20employee%20know%20AND%20the%20approved%20PTO%20is%20automatically%26nbsp%3Bwritten%20to%20a%20SharePoint%20calendar.%3C%2FLI%3E%3C%2FUL%3E%3CDIV%3EThis%20was%20all%20working%20perfectly%20up%20until%20the%20beginning%20of%26nbsp%3Bthis%20week.%26nbsp%3B%20The%20only%20thing%20I%20can%20think%20of%20is%20maybe%20this%20has%20something%20to%20do%20with%20daylight%20savings%20time.%26nbsp%3B%20Now%20everything%20in%20the%20Flow%20works%2C%20%3CEM%3Ebut%3C%2FEM%3E%20when%20it%20gets%20to%20the%20part%20where%20it's%20supposed%20to%20automatically%26nbsp%3Bwrite%26nbsp%3Bthe%20approved%20PTO%20to%20the%20SharePoint%20calendar%2C%20it%20is%20writing%20it%20to%20the%20day%20before%20and%20with%20weird%20hours%20included.%26nbsp%3B%20For%20example%3A%26nbsp%3B%20the%20request%20is%20for%20Wednesday%2011%2F13%20(all%20day)%2C%20but%20it%20is%20being%20written%20to%2011%2F12%20starting%20at%204pm%20to%20like%2012am%20or%20something%20like%20that.%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-994164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-994191%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20not%20writing%20to%20correct%20day%2Ftime%20in%20SharePoint%20calendar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-994191%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F426871%22%20target%3D%22_blank%22%3E%40Nina_G_Serrano%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20haven't%20already%20tried%20it%2C%20use%20%3CSTRONG%3EConvert%20time%20zone%3C%2FSTRONG%3E%20to%20properly%20set%20the%20calendar%20time%2Fdate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155764i3E1863B0BB08E2BC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20191108122357388.png%22%20title%3D%22capture20191108122357388.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShould%20help%20with%20your%20calendar%20issues.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995749%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20not%20writing%20to%20correct%20day%2Ftime%20in%20SharePoint%20calendar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995749%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3EHi%20Damien.%26nbsp%3B%20I%20tried%20it%2C%20and%20it%20didn't%20work.%26nbsp%3B%20Thanks%20though.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1032557%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20not%20writing%20to%20correct%20day%2Ftime%20in%20SharePoint%20calendar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1032557%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F426871%22%20target%3D%22_blank%22%3E%40Nina_G_Serrano%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20use%20UTC%20as%20the%20source%20time%3F%20It%20needs%20to%20be%20UTC%20for%20it%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20find%20an%20answer%20to%20your%20issue!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hi everyone, I'm hoping someone here can help me.  Here's the situation.  I created a Flow for PTO requests.
 
  • Employee enters PTO request in SharePoint list
  • An approval request email is then sent to the employee's manager or director
  • Once the manager approves the request, an email is generated to let the employee know AND the approved PTO is automatically written to a SharePoint calendar.
This was all working perfectly up until the beginning of this week.  The only thing I can think of is maybe this has something to do with daylight savings time.  Now everything in the Flow works, but when it gets to the part where it's supposed to automatically write the approved PTO to the SharePoint calendar, it is writing it to the day before and with weird hours included.  For example:  the request is for Wednesday 11/13 (all day), but it is being written to 11/12 starting at 4pm to like 12am or something like that.
3 Replies
Highlighted

Hi @Nina_G_Serrano 

 

If you haven't already tried it, use Convert time zone to properly set the calendar time/date.

 

capture20191108122357388.png

 

Should help with your calendar issues.

 

Cheers

Damien

 

Highlighted

@Damien RosarioHi Damien.  I tried it, and it didn't work.  Thanks though. 

Highlighted

Hi @Nina_G_Serrano 

 

Did you use UTC as the source time? It needs to be UTC for it to work.

 

Hope you find an answer to your issue!

 

Cheers

Damien