Flow is creating multiple copies of one google calendar event in asana and on the wrong date

[nikkiyoung323]

I have a flow that creates an Asana task for events in my Google calendar, but it doesn’t always put them on the right date, and it creates multile copies of the same event.

A friend who has the exact same setup also has the same problem so we tested. Initially it created one copy of the test event, but on the wrong day (she is two hours ahead of me, but the event she set up aws this evening - it shows on the correct date in her Asana, but in mine it shows tomorrow.)

Then when I asked her to modify the event it created three new copies of the same event, also all on tomorrow’s date.

My flow is super simple, and when I test it only one copy of the event I use to test gets created, but in real life use, it doesn’t seem to work correctly.
Does anyone have any suggestions?

[abuaboud]

Hi @nikkiyoung323,

It seems like a timezone conversion issue. To confirm, could you please go to the “Runs” section and open one of the runs?

Click on the Asana step. You should find the due_on field in the input on the left side. This field usually contains a date and time, formatted like this: 2024-12-12T12:30:00-04:00.

This means that, in UTC timezone, it would be 16:30.

Could you please let us know what value is in the due_on field and the time you see on Asana?

[nikkiyoung323]

The test event we used is in my google calendar at 5:30-6:30 MST on Dec 12, 2024.

In the run information of the Asana step, is just shows “2024-12-13” - the wrong date with no time.

[abuaboud]

Can you try using the “Ask AI” feature in the Piece Selector and ask the AI the following:
“Convert 2024-12-12T12:30:00-04:00 to UTC format.”

Click on “Use the code,” then:

1. Change this to Google Calendar:
   
2. Use the output of the code in your Asana step:
   

Let me know if that works.

[nikkiyoung323]

Thanks for this.

I’m not sure what you mean in step 1 after clicking on use code though.

You say change this to Google Calendar, but I’m not sure what I’m supposed to change to that?

I tried changing the first row in the code to Google Calendar, as it looks like that might be highlighted in your screenshot, then I hit the test button, but it threw an error.

I think I must be missing something.

Thanks

Nikki

[nikkiyoung323]

Hi, I just wanted to check in as I didn’t receive an answer to my last post. I’m hoping you can clarify what I’m supposed to be changing…

Thanks so much!
Nikki

[Abdul]

Hi there @nikkiyoung323.

Could you check this flow template and tell us if it works ?

https://cloud.activepieces.com/templates/fA2SB6s9B0uu7aZWfQBjV

It should work fine, regardless of timezones, since the date Google Calendar gives is in UTC.

Let us know if you have any further questions.

[nikkiyoung323]

Hi,

I used the template you provided (thank you!) and I thought it was working ok for a couple of days. My events are appearing on the correct date now, but recently it has added duplicates of a lot of old calendar items (which I understand may just be because they were new items that had never been added to Asana, even though they were past occurrences), and also multiple duplicates of upcoming events.

Some of the upcoming events were in my calendar before I added the flow from this template, others are new calendar items since adding this flow.

I also shared this flow template with my colleague, who was having the same problem, and the same thing has happened to her, although all of the items that have been added to her calendar are showing a date of Dec 31, 1999.

Can you help me to figure out why it is still duplicating events?
Thanks!

[Abdul]

Will take a look at it and get back to you, apologies for the inconvenience

[Abdul]

Sorry there was a mistake in my template, I fixed it and now your flow should be working just fine.