Office 365 Calendar to Google Calendar (2020) – Microsoft Flow

So, it appears that Microsoft pulled all the Microsoft Flow templates that used to work flawlessly and give you two way sync between Office 365 and Google Calendar.

This might not sound like a massive issue. That is unless you use Google Assistant or Alexa to deal with your day to day Calendar stuff. “Hey Google, remind me where my next meeting is” is rather crap with no information.

So, as a stopgap while Microsoft get their act together and publish some working templates, here is the answer….

Firstly, start with this template on the Flow website. Edit your calendar entries for the Office 365 and Google Calendars you want to sync up. But then you will get an error…..

Flow save failed with code ‘OpenApiOperationParameterValidationFailed’ and message ‘Input parameter ‘newEvent’ validation failed in workflow operation ‘Create_an_event’: The parameter with value ‘”@triggerOutputs()?[‘body/Start’]”‘ in path ‘newEvent/start’ with type/format ‘String/date-no-tz’ is not convertible to type/format ‘String/date-time’.’.

Which is a pretty sucky message to get…. and it took me ages to figure out how to fix it. Until I found a kind forum post hidden away on a site somewhere (which I cannot since relocate). But essentially the answer to fix the above is to remove some items in this section:

You remove the body/Start and body/End entries then add replacements for those, looking at the image below should assist…..

You add two expressions:

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

You can then remove the bottom part of the description to get rid of a load of rubbish metadata that is pulled over otherwise.

That worked for me anyway! 🙂

  4 Replies to “Office 365 Calendar to Google Calendar (2020) – Microsoft Flow”

  1. Michael altiero
    January 30, 2020 at 3:31 pm

    When I enter the expressions here I get an invalid expression error. Do you have any solutions?

    • CNM
      February 6, 2020 at 9:10 pm

      When you copy from the web, the single quote is actually a different character (angled single quote). Replace these characters with the regular single quotes.

      • Nick
        February 6, 2020 at 9:40 pm

        Thanks for pointing that out. I have put in preformatted mode now, does that work?

  2. Andreas
    March 12, 2020 at 8:57 pm

    This great, this made me get runnign again !
    have been strugling with this a few time without success !

    Now the next thing is:
    I have made a flow that would be able to also update and delete posts from outlook to google.

    But, as the “make event” lacks the “Event ID” is not required, it gets stuck when we try to do a update !

    Any solution for that ?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.