Forum Discussion

Bronze Contributor

Nov 27, 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...

Microsoft Flow

SamTech

Copper Contributor

Nov 28, 2020

Any advice will be appreciate with my similar error:

(a) Using Dynamic Content "Event Start Date Time"

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_a_Teams_meeting': The parameter with value '"@triggerOutputs()?['body/start']"' in path 'item/start/dateTime' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'.

(b) Expression1 convertToUtc(triggerOutputs()?['body/start'], 'GMT Standard Time')

InvalidTemplate. Unable to process template language expressions in action 'Create_a_Teams_meeting' inputs at line '1' and column '22105': 'The template language function 'convertToUtc' expects its second parameter to be a time zone matching the time zone indicated by the timestamp. The provided value '(UTC+00:00) Dublin, Edinburgh, Lisbon, London' is not valid or does not match the timestamp '2020-11-30T14:00:00.0000000Z'. Please see https://aka.ms/logicexpressions#ConvertToUtc for usage details.'.

JoeK13F

Copper Contributor

Jun 29, 2021

SamTech

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

lthomas138
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