Unanswered

Formatting SharePoint list calculated date column in Flow-generated email

(0) Share

Report

Posted on by whitelc

I have a SharePoint list with two calculated date columns. I've written a Flow to generate an email. The email needs to contain the values of both calculated date columns in the format mm/dd/yyyy.

I can get the dates to show up in the email, but only in UTC format. I've tried every combination of "formatDateTime" that I've found from web searching. Most often, I get this error:

Unable to process template language expressions in action 'Compose_-_format_Hire_Date_+_3_Months' inputs at line '1' and column '2540': 'The template language function 'formatdatetime' expects its first parameter to be of type string. The provided value is of type 'Null'.

Can anyone point me the right direction? Thanks.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

v-bacao-msft on at

Like (0)

Report
Hi @whitelc ,

Could you share the details of Compose_-_format_Hire_Date_+_3_Months action configuration?

Could you share screenshots of the Flow configuration? We can't know which action or trigger you are getting the specified field value.

The error message indicates that the first parameter of the function is empty, and you may not use the appropriate Expression to get the specified column value.

Please make sure that the Date field you mentioned is not empty, then use the appropriate Expression to get this value.

I had a test on my side, use When an item is created as a trigger, get the specified field value, and format it using formatDateTime() function.

Expression reference:

formatDateTime(triggerBody()?['CalculateDate'],'MM-dd-yyyy')

Image reference:

Please take a try again.

Best Regards,

Was this reply helpful? Yes No
Verified answer

whitelc 36 on at

Like (0)

Report

Thanks, Barry. I got it to work by using the Expression
FormatDateTime(triggerBody()?['OData__x0033_Months'],'MM/dd/yyyy')
in the email. Did not need Compose action at all.

I still can't make it work in the PowerApp, though, so I've posted to that Forum.

Thanks.

Was this reply helpful? Yes No