Connecting Outlook Calendar to Google Calendar - Errors

(0) Share

Report

Posted on by LF-06071531-0

Hi,

I'm running in circles to synchronize the Outlook Calendar with Google Calendar.

The Flow has been created with V3 event, My outlook calendar is cjosen and ok. Then I've to create the Google calendar event and I'm getting crazy on how to fix either setup the start time / end time with fx Triggers , then complains about formats and the latest error is :

"InvalidTemplate. Unable to process template language expressions in action 'Criar_um_evento' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'."

This was supposed to be a very simple automation though I'm getting made to fix and all the co-pilot hints are not fixing.

Who did already this synchro and can give me a hand ?

Many thanks

Luis F

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,136 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The current problem is that whatever dynamic content value you are using inside the FormatDateTime() function is null. Check the value of the field you are using. Its evidently blank or not a datetime value at all.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,048 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Step 1: Use correct dynamic fields

When you pick Outlook event trigger fields, you should see:

Start time → Start → usually an object with a dateTime property

End time → End → same

Do not use the raw Start if it’s an object.

Step 2: Safely extract and format the datetime

Instead of:

formatDateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddTHH:mm:ss')

Use:

formatDateTime(triggerOutputs()?['body/start']?['dateTime'], 'yyyy-MM-ddTHH:mm:ss')

formatDateTime(triggerOutputs()?['body/end']?['dateTime'], 'yyyy-MM-ddTHH:mm:ss')

This accesses the dateTime field inside the object.

Step 3: Handle possible nulls

To be safe (in case of null), you can wrap with a coalesce:

formatDateTime(coalesce(triggerOutputs()?['body/start']?['dateTime'], utcNow()), 'yyyy-MM-ddTHH:mm:ss')

This means:

If start.dateTime is null, use utcNow().

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No
LF-06071531-0 2 on at

Like (0)

Report
Copy link

Link copied!

I used Riyaz_riz11 hint but

"Unable to process template language expressions in action 'Criar_um_evento' inputs at line '0' and column '0': 'The template language expression 'formatDateTime(coalesce(triggerOutputs()?['body/start']?['dateTime'], utcNow()), 'yyyy-MM-ddTHH:mm:ss')' cannot be evaluated because property 'dateTime' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'."

Still running in circles !!

Was this reply helpful? Yes No