You’re offline. This is a read only version of the page.
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 ?
Hi @hbirdlabs ,
You can also give the below connector a go. Saves mucking around with expressions.
--------------------------------------------------------------------------
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
@eric-cheng Thanks for your help, it works... But now there's another problem 😅
The error message is : "Unable to process template language expressions in action 'Create_event_(V4)' inputs at line '1' and column '25738': 'The template language function 'convertToUtc' expects its second parameter to be a time zone matching the time zone indicated by the timestamp. The provided value '(UTC+00:00) Dublin, Edinburgh, Lisbon, London' is not valid or does not match the timestamp '2021-08-28T01:00:00.0000000+00:00'. Please see https://aka.ms/logicexpressions#ConvertToUtc for usage details.'."
Maybe you can help me to handle this one too ?
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
