Trouble with FormatDateTime

(0) Share

Report

Posted on by astrontelstar

287

I have a flow posted here where I am pulling a record from the Microsoft Dataverse (cr014_neededinhands).

The field is a date/time field and I believe stores the date in ISO 8601 format.

I simply want to convert the date in my HTML table to a more readable format by the end user but am getting this error message.

The execution of template action 'CheckShipDatesHTMLTable' failed. The column values could not be evaluated: 'In function 'formatDateTime', the value provided for date time string 'cr014_neededinhands' was not valid. The datetime string must match ISO 8601 format.'

The only thing I can think is maybe the value is null in some of the fields? If so, how could I write the expression to consider this?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @astrontelstar,

Can you try this expression instead?

formatDateTime(item()?['cr014_neededinhands'], 'g')

Was this reply helpful? Yes No
astrontelstar 287 on at

Like (0)

Report
Copy link

Link copied!

It worked! Thank you. Can you explain why it worked? I'd like to understand the add of item()?

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @astrontelstar,

That is a way to refer to a property of an item in a select mapping.

All of your fields in that select action are using that same item()?['fieldname'] syntax. Just hover over one of the other ones and you will see it in the tooltip 😉

Or use the peek code in the settings of the select action. Over there you can also see that the other key value mappings use the same kind of expressions.

Was this reply helpful? Yes No
astrontelstar 287 on at

Like (0)

Report
Copy link

Link copied!

What if the value is null? Flow dies if the value is null using this expression.

Was this reply helpful? Yes No