Google Agenda to Outlook sync error : "The string was not recognized as a valid DateTime"

Like (0) Share

Report

Posted on 23 Aug 2021 10:47:27 by hbirdlabs

Hello !

I'm trying to sync new event on a Google Calendar to an Outlook calendar, but when I run a test it failed with this error details :
"The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.
clientRequestId: fe0c7056-ae08-47aa-911b-f13a45d0205f"

In StartTime field I have this : "convertToUtc(triggerOutputs()?['body/start'], 'GMT Standard Time')"
And in EndTime field I have this : "convertToUtc(triggerOutputs()?['body/start'], 'GMT Standard Time')"
According to this post, because I had an error "OpenApiOperationParameterValidationFailed" with "triggerOutputs()?['body/start']" : https://powerusers.microsoft.com/t5/Building-Flows/Template-by-Microsoft-Flow-Community-does-not-save/m-p/483192#M59201

Any ideas to fix this ?

Capture d’écran 2021-08-23 à 12.24.53.png

All responses (3)

Answers (1)

Verified answer

eric-cheng 5,171 on 23 Aug 2021 at 10:54:02

Like (1)

Report

Re: Google Agenda to Outlook sync error : "The string was not recognized as a valid DateTime"

Hi @hbirdlabs ,

You need to add the formula as an expression.

Add a @ and copy and paste into the field again.

E.g.

@convertToUtc(triggerOutputs()?['body/start'], 'GMT Standard Time')

Do the same for end time
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn