Error in Synch-Template Google / Outlook Message 400 String was not recognized as a valid DateTime

[RainerWinter]

I found a Template called "Wenn ein Termin in einem Kalender aktualisiert wird -> Termin aktua…"

This one should synch Google calendar with Outlook calendar in both ways.

Once entering the right calendar an testing the following message Comes up:

{

"status": 400,

  "message": "String was not recognized as a valid DateTime.\r\nclientRequestId: e23c2d70-3af8-4c8e-a87f-b6565c0b4c81",

  "source": "office365-ne.azconn-ne-01.p.azurewebsites.net"

}

This is the configuration:

and this is the error message

Any ideas to solve that Problem?

Thanks Rainer

[yashag2255]

Hey @RainerWinter 

I have just made a test on my side and am unable to reproduce the error. 

Can you confirm that you are providing the right values from the dynamic selector for the Event start and Event end timings?

You should use these attributes: 

1. Event List Event Start Date-Time (Ereignisliste Ereignis Startdatum-Uhrzeit)

2. Event List Event End Date-Time (Ereignisliste Ereignis Enddatum-Uhrzeit)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[v-alzhan-msft]

Hi @RainerWinter ,

Have your problem been solved?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,

Alice

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.

[manuelstgomes · Accepted solution]

Hi @RainerWinter 

The issue is that the value is a string ("String was not recognized") and not a date. Try the following:

formatDateTime(<your variable>, 'yyyy-MM-dd')

This is if your input format is, for example, 2019-12-26. By adjusting the string value into a valid date type then your "Termin aktua..." step will run correctly.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel