Power Platform Community Forum Thread Details

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?

Categories:

Building flows