Answered

all day schedule

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm just bigginer of flow and appreciating template "Outlook event sincronize to google calender"

https://japan.flow.microsoft.com/ja-jp/galleries/public/templates/e9ff7beaedef4aff866f4bf8494ae72d/outlookcom-%E3%82%AB%E3%83%AC%E3%83%B3%E3%83%80%E3%83%BC%E3%81%8B%E3%82%89-google-%E3%82%AB%E3%83%AC%E3%83%B3%E3%83%80%E3%83%BC%E3%81%B8%E3%81%AE%E3%82%A4%E3%83%99%E3%83%B3%E3%83%88%E5%90%8C%E6%9C%9F/

My problem is

When I scheduled event as all day ex (1st June), Google schedule shows schedule from 9:00 1st June and 9:00 2nd June.

(I guess offset 9:00 come from Japan STD time difference from GMT)

Please give me advice how to correct this error.

Regards

Categories:

Power Automate Mobile App

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

As you said ,the offset 9:00 come from Japan STD time difference from GMT, if you have choose the Time zone when create the event in outlook, and don't want offset to be exist in google calendar, you could subtract the 9 hours befroe create the event in google calendar.

The expression in the "Start time" field of "Create an event" action of google calendar as below:

addHours(body('Create_event_(V2)')['Start'],-9)

The expression in the "End time" field of "Create an event" action of google calendar as below:

addHours(body('Create_event_(V2)')['End'],-9)

The flow would run successfully as below:

Please let me know if your problem could be solved.

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for invaluable your advice.
Please let me know in case mixed specified time to time,
Ex am 9:00 to am 10:00 and all day.
At the moment there is no problem when I specify time to time.
No offset occurs.
I understand in case all day, I adopt your suggestion offset 9:00hr.
How should I divide time to time, and all day

Best regards

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

You could add a Condition to check if the event is an all day event.

I have made a test on my side, you could refer to screenshot below to add the Condition:

If the event is an all day event the flow would run successfully as below:

If the event isn't an all day event, the flow would run successfully as below:

Please let me know if your problem could be solved.

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Alice
Thank you for your invaluable advice.
I'll redesign your advice from Office365 outlook to Outlook com since due to our security policy
We cannot use combination Office365 outlook and Google.
After succeed, I will repot result.

Best regards

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Dear all

Thanks to your advice, I could clear all days issue.

addHours(@items('Create_events_in_Google_Calendar_')?['Start'],-9)
addHours(@items('Create_events_in_Google_Calendar_')?['End'],-9)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Dear
Could you give me advice for correct formula since I face formula error.

{
  "error": {
    "errors": [
      {
        "domain": "global",
        "reason": "invalid",
        "message": "Invalid value for: Invalid format: \"addHours(@items('Create_events_i...\""
      }
    ],
    "code": 400,
    "message": "Invalid value for: Invalid format: \"addHours(@items('Create_events_i...\""
  }
}

Best regards

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

As so far, I could not find appropriate formula, I concluded as temporaly solution below.

Incase of All day schedule,
Starttime : Starttime
Endtime : Starttime

Thank you and Regards

Was this reply helpful? Yes No