Forum Discussion

Bronze Contributor

Nov 26, 2019

Flow save failing on popular template due to obscure date format issue

In using https://us.flow.microsoft.com/en-us/galleries/public/templates/0bc115a00d6911e78c2e9d11ef1d0c12/copy-specific-category-of-appointments-from-office-365-to-google-calendar I'm getting this err...

Copper Contributor

Jun 29, 2021

Did you ever find an answer for this? I'm encountering the exact same issue

Copper Contributor

Jul 29, 2021

JoeK13F SamTech

I was experiencing the same issue. I resolved it by using the 'Convert Time Zone' action on my date field. I just chose the same time zone for both parameters but specified the format to be 'Sortable date/time pattern'. Then I was able to feed the output directly into my next step (Create Teams Meeting). Hope this helps you, too.

Danyia_Zia
Copper Contributor
Apr 13, 2023
Where exactly did you add the convert time zone, I am having the same issue after adding this under my create event. lthomas138
- RandyH80
  Copper Contributor
  Apr 17, 2023
  Danyia_Zia Here is an example of my flow:
  The format start time is an expression,
  formatDateTime(triggerOutputs()?['body/EventDate'])
  Convert time zone settings:
  Format string: Round-trip date/time pattern - 2009-06-15T13:45:30.0000000-07:00 [o]
  UTC
  UTC+1
  Keep an eye on the format string.
  Afterwards I did a new test with a positive result
RandyH80
Copper Contributor
Sep 02, 2021
lthomas138
This is the solution for my problem, Thank you very much!

I think the conversion isn't working like as it should be because when I choose the correct source time zone, it just keeps adding the times to the original one form the calendar event. I have UTC+1, but when I left it to UTC+1 it just added 2 hours on the planning - not so good 🙂
The only thing that works fine is just reset it to UTC to UTC with no time zone selected, then it will keep the correct hour. Odd. Did you have the issue? (create event v4 for SP Online)

Br, R

Resources