'The template language function 'formatDateTime' expects its first parameter to be of type string.

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I am trying - formatDateTime(item()?['ConclusionDate'],'mm/dd/yyyy')

But getting error -

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

where am I going wrong?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wonka1234 ,
Because there is a null value in your 'ConclusionDate' column, flow will report an error.
Please try this expression:

if(empty(item()?['ConclusionDate']),null,formatDateTime(item()?['ConclusionDate'],'mm/dd/yyyy'))

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-yetonggu-msft . No error now, but now the body of the email is showing blank lol.
But I see in update item :

But no value is showing with your expression in the email body.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wonka1234 ，
Please show a complete screenshot of your flow.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yetonggu-msft Not sure if this helps..

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wonka1234 ,
It’s useless. What are the steps before your flow?

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yetonggu-msft nothign much related to ConclusionDate happens.

Date is related to the other date field in the email.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wonka1234 ,
This information is enough, please try this expression:

formatDateTime(body('Update_item')?['ConclusionDate'],'MM/dd/yyyy')

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Ry009_ 109 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

I tried a modifed version of your suggestion, but it's returning nulls, not sure what I'm doing wrong?

if(empty(item()?['_Table[Datefield]']),null,formatDateTime(item()?['_Table[Datefield]'],'dd/MM/yyyy'))

This is my flow with the expression in the compose step;

Not sure what I'm doing wrong?

Was this reply helpful? Yes No