cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

all day schedule

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/o...

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

v-yuazh-msft
Community Support
Community Support

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.

Capture.PNG

 

 

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:

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

Best regards,

Alice

 

 

 

 

 

 

 

Anonymous
Not applicable

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

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:

Capture.PNG

 

 

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

Capture.PNG

 

 

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

Capture.PNG

 

 

Please let me know if your problem could be solved.

 

 

Best regards,

Alice

 

 

 

 

 

Anonymous
Not applicable

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

Anonymous
Not applicable

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)

スクリーンショット 2018-06-28 01.53.17.png

Anonymous
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (5,395)