About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Setting Google Calendar event with Microsoft To Do Due Date

  • 26 January 2022
  • 6 replies
  • 433 views
A

Hello people, 

I am trying to create a zap which converts a ToDo Task to a Google Calendar Event with the Task’s Due Date (not the date of the task’s creation which is the case in the zap on the zapier website, here - the one called ‘our most popular zap’). 

The trigger is clear: new ToDo task

The action is causing errors: create a Google Calendar Detailed Event with:

        Start Date &Time: Due Date Time Date Time

        End Date & Time: Due Date Time Date Time (ideally I’d want this to be an hour later, but I’m not sure this is an option - is this what’s causing the problem?)

When I do the test, the error message is: “Required field "Start Date & Time" (start__dateTime) is missing”. When I test it myself with a task which has a due date, nothing happens. 

Is anybody able to help with this?

Many thanks,

(P.S. there was a related question about this but it didn’t seem to be answered in a way that was helpful for this and had been achieved)

icon

Best answer by Aremde 26 January 2022, 12:41

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

SamB
Rank
Userlevel 7
Badge +11

Ah yes, you’d need to click on either the “Retest & Review” or “Retest & Continue” button in order to submit a new test.

I’m so glad you were able to get this sorted, @Aremde! And thanks so much for sharing your solution here! :)

Troy Tessalone
Userlevel 7
Badge +14

Hi @Aremde 

Please post screenshots with how your Zap steps are configured.

 

Check out this help article:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A

Thanks Troy, 

I’ve attached a pdf file to this post with all the screenshots of the setup.

(And thanks, that article on modifiers is helpful - I added “+1h” to the end date & time, but the same error continues)
 

This post has been edited by a moderator to remove sensitive information. Please remember to obfuscate any personally identifiable information prior to posting as this is a public forum. 

1 Attachment
SamB
Rank
Userlevel 7
Badge +11

Hey @Aremde!

It looks as though the sample you’ve pulled in from Microsoft To Do doesn’t have any value in the Due Date Time Date Time field as we’re seeing “No data” instead of an actual date and time value:
e1fd7eb71dfa09f46f1c061756da3ceb.png

I’d recommend pulling in another testing sample from Microsoft To Do (Change the test data in your Zap trigger) so that you’re getting an actual date and time value come through in that field. Then you can add that +1h modifier to the field (make sure to leave a space between the date and the modifier or it won’t work). 

Hopefully that’ll help sort it. Please do let us know how you get on with this! :)

A

Many thanks for that @SamB, 

I’ve now been able to set up the event almost the way it should be but seem to have a timezone issue - The event is created at 1pm the previous day in my calendar. I tried to fix this with the modifiers (using “ +19h”  with space before modifier), but when I do that, the event doesn’t appear in my calendar (and doesn’t come up in a search), although the test claims that the event was successful. 

Below is the screen shot of my time entries (the only thing I changed). 

Are you able to help with this?

A

It finally worked. I think the issue was me not clicking on re-test (I assumed the test was restarted each time I opened the “test action” tab).

Terms & Conditions