cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IserLuick
Level: Powered On

Possible in-built error: Recurrence Time Zone doesn't work and Convert Time Zone can't fix it

Hi everyone!

I'm a beginner trying to make a simple flow which does the following:

1.- It triggers everyday at 00:00.
2.- It gets a list of the events programmed on Google Calendar for that day.
3.- It creates a task for every event in a Google Tasks list.

The problem I'm struggling with is that Flow is stuck in UTC time zone, and my time zone is UTC-6. I've been trying to fix this all day but I can't get it to work properly.

 

Let me explain this problem in detail with images and some code, as well as the solutions that didn't work:


For step 1, I set a Recurrence trigger:

 

Recurrence 1.png

 

For step 2, I set a "List the events on a calendar" action to get the events for today from Google Calendar:

 

Calendar 1.png

 

For step 3, I set a "Create a task in a task list" applied to each event in the list provided from step 2:

 

Task 1.png

 

This flow seems pretty straight forward and should work; however, it doesn't. When I run the flow, the events list that is generated from Google Calendar has the following code:

 

 

[
  {
    "kind": "calendar#event",
    "etag": "\"3099287415345000\"",
    "id": "7oujmmbp151ir55r7hpqa1sfcf",
    "status": "confirmed",
    "htmlLink": "https://www.google.com/calendar/event?eid=N291am1tYnAxNTFpcjU1cjdocHFhMXNmY2YgbHVpc2VyaWNreGNveUBt",
    "created": "2019-02-06T20:18:17Z",
    "updated": "2019-02-09T19:23:47.064Z",
    "summary": "Cita Endocrinólogo 18:00",
    "description": "Cita con el endocrinólogo.",
    "colorId": "11",
    "creator": "luiserickxcoy@gmail.com",
    "organizer": "luiserickxcoy@gmail.com",
    "start": "2019-02-09T00:00:00+00:00",
    "end": "2019-02-09T01:00:00+00:00",
    "iCalUID": "7oujmmbp151ir55r7hpqa1sfcf@google.com",
    "sequence": 0,
    "extendedProperties": {
      "private": {
        "everyoneDeclinedDismissed": "-1"
      }
    },
    "reminders": {
      "useDefault": false,
      "overrides": [
        {
          "method": "popup",
          "minutes": 10
        },
        {
          "method": "popup",
          "minutes": 15
        },
        {
          "method": "popup",
          "minutes": 5
        }
      ]
    },
    "location": "",
    "attendees": "",
    "endTimeUnspecified": false
  },
  {
    "kind": "calendar#event",
    "etag": "\"3099480479780000\"",
    "id": "533n8iml7vtmk4591699rtadlt_20190209T030000Z",
    "status": "confirmed",
    "htmlLink": "https://www.google.com/calendar/event?eid=NTMzbjhpbWw3dnRtazQ1OTE2OTlydGFkbHRfMjAxOTAyMDlUMDMwMDAwWiBsdWlzZXJpY2t4Y295QG0",
    "created": "2019-02-07T14:42:58Z",
    "updated": "2019-02-09T19:23:59.89Z",
    "summary": "Mantenimiento dermatológico tarde",
    "description": "\nLavarse la cara con el jabón especial\nPoner 6 disparos de Capilarium",
    "colorId": "11",
    "creator": "luiserickxcoy@gmail.com",
    "organizer": "luiserickxcoy@gmail.com",
    "start": "2019-02-09T03:00:00+00:00",
    "end": "2019-02-09T03:30:00+00:00",
    "recurringEventId": "533n8iml7vtmk4591699rtadlt_R20190209T030000",
    "originalStartTime": {
      "dateTime": "2019-02-09T03:00:00+00:00",
      "timeZone": "America/Mexico_City"
    },
    "iCalUID": "533n8iml7vtmk4591699rtadlt_R20190209T030000@google.com",
    "sequence": 1,
    "extendedProperties": {
      "private": {
        "everyoneDeclinedDismissed": "-1"
      }
    },
    "reminders": {
      "useDefault": true
    },
    "location": "",
    "attendees": "",
    "endTimeUnspecified": false
  },
  {
    "kind": "calendar#event",
    "etag": "\"3099100883760000\"",
    "id": "4ndb18msjpcatol241klr0o2dl_20190209T140000Z",
    "status": "confirmed",
    "htmlLink": "https://www.google.com/calendar/event?eid=NG5kYjE4bXNqcGNhdG9sMjQxa2xyMG8yZGxfMjAxOTAyMDlUMTQwMDAwWiBsdWlzZXJpY2t4Y295QG0",
    "created": "2019-02-07T14:15:52Z",
    "updated": "2019-02-07T14:40:41.88Z",
    "summary": "Aseo personal",
    "description": "\nBañarse\nPonerse desodorantes\nVestirse",
    "colorId": "11",
    "creator": "luiserickxcoy@gmail.com",
    "organizer": "luiserickxcoy@gmail.com",
    "start": "2019-02-09T14:00:00+00:00",
    "end": "2019-02-09T15:00:00+00:00",
    "recurringEventId": "4ndb18msjpcatol241klr0o2dl",
    "originalStartTime": {
      "dateTime": "2019-02-09T14:00:00+00:00",
      "timeZone": "America/Mexico_City"
    },
    "iCalUID": "4ndb18msjpcatol241klr0o2dl@google.com",
    "sequence": 1,
    "extendedProperties": {
      "private": {
        "everyoneDeclinedDismissed": "-1"
      }
    },
    "reminders": {
      "useDefault": true
    },
    "location": "",
    "attendees": "",
    "endTimeUnspecified": false
  },
  {
    "kind": "calendar#event",
    "etag": "\"3099276930168000\"",
    "id": "3rvvhnh6onm5m8798r7cm0hrnl_20190209T150000Z",
    "status": "confirmed",
    "htmlLink": "https://www.google.com/calendar/event?eid=M3J2dmhuaDZvbm01bTg3OThyN2NtMGhybmxfMjAxOTAyMDlUMTUwMDAwWiBsdWlzZXJpY2t4Y295QG0",
    "created": "2019-02-07T14:41:10Z",
    "updated": "2019-02-08T15:07:45.084Z",
    "summary": "Mantenimiento dermatológico mañana",
    "description": "Lavar la cara con el jabón especial\nPoner los 6 disparos de Capilarium\nPoner protector solar",
    "colorId": "11",
    "creator": "luiserickxcoy@gmail.com",
    "organizer": "luiserickxcoy@gmail.com",
    "start": "2019-02-09T15:00:00+00:00",
    "end": "2019-02-09T15:30:00+00:00",
    "recurringEventId": "3rvvhnh6onm5m8798r7cm0hrnl",
    "originalStartTime": {
      "dateTime": "2019-02-09T15:00:00+00:00",
      "timeZone": "America/Mexico_City"
    },
    "iCalUID": "3rvvhnh6onm5m8798r7cm0hrnl@google.com",
    "sequence": 3,
    "extendedProperties": {
      "private": {
        "everyoneDeclinedDismissed": "-1"
      }
    },
    "reminders": {
      "useDefault": true
    },
    "location": "",
    "attendees": "",
    "endTimeUnspecified": false
  }
]

As you can see, all the events are shifted by 6 hours; for example, the event named "Cita con el endocrinólogo 18:00" happened yesterday, at 18:00 in UTC-6 time, on February 8; however, the time was shifted 6 hours forward to 00:00 on February 9 and it showed as an event for today; similarly, events that happened at 18:00 today weren't listed because of the same problem, probably shifted to 00:00 on February 10.

 

I checked my Time Zone settings on Google Calendar and I made sure that it is UTC-6 in the general settings, in the particular calendar and even in each individual event. All the dates and times on Google Calendar are correct and my notifications arrive in a timely manner, so I'm pretty sure this is not the source of the problem.

 

I tried converting the time zone:

 

Convert 1.png

 

And it doesn't work. Also, I tried using some code to achieve the same result:

 

Compose 1.png

 

And it doesn't work either. I tried changing my language and region settings:

 

Settings 1.png

And making this change didn't solve the problem.

 

I think I have exhausted my resources, as well as the options that I have seen recommended in other discussions. It seems that Flow is stuck in UTC time and can't shift to other time zone no matter what I try.

 

I'm inclined to think that this is a bug that only the developers can fix; however, if there is something that I'm missing that can fix this Flow, I'd love to try it.

 

Thank you very much for reading this post. If I didn't explain my problem understandably or you need more information to find a solution, I'm more than willing to provide everything I can.

 

Have a nice day!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Possible in-built error: Recurrence Time Zone doesn't work and Convert Time Zone can't fix it

Hi @IserLuick,

 

It seems that your problem is solved in the link below:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Possible-bug-or-in-built-error-Recurrenc...

 

Please also mark this post as solved by Accept it as the solution to help the other members find it more quickly.

 

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
SCTdan
Level 8

Re: Possible in-built error: Recurrence Time Zone doesn't work and Convert Time Zone can't fix it

Can you post the response data you get from the 'List the events on a calendar'?  

 

Thanks

Highlighted
Community Support Team
Community Support Team

Re: Possible in-built error: Recurrence Time Zone doesn't work and Convert Time Zone can't fix it

Hi @IserLuick,

 

It seems that your problem is solved in the link below:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Possible-bug-or-in-built-error-Recurrenc...

 

Please also mark this post as solved by Accept it as the solution to help the other members find it more quickly.

 

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 99 members 4,227 guests
Please welcome our newest community members: