What could be causing my format date and time to fail?

(1) Share

Report

Posted on by rmartori

So in the excel file itself the end date is formatted as dd/mm/yyyy and does have something in the cell 26/07/2024

In list rows present in table I have the date time format set to ISO 8601

and in the email I am sending I am using the following expression

formatDateTime(triggerOutputs()?['body/{Worker End Date}'], 'MM-dd-yyyy')

When I run the bot however on the send email v2 step I get the following error:

InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_(V2)_2' 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.'.

If I don't use an expression the result in the email I get is 2024-07-26T00:00:00.000Z

What can I do to fix this?

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report
Re: What could be causing my format date and time to fail?

Hi @rmartori

It looks like the property 'Worker end date' does not exist in output body of trigger.

Please select dynamic date value from dynamic content window & pass it in the below expression:

formatDateTime(<select date value from dynamic content window>, 'MM-dd-yyyy')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.