"The datetime string must match ISO 8601 format"

(0) Share

Report

Posted on by oaghaei

173

I would like to reformat the date to a friendly format.

I am getting the error "the value provided for date time string 'Deadline' was not valid. The datetime string must match ISO 8601 format.'." I have a date and time field that shows the deadline in this format "2022-01-14T04:59:00Z". I tried converting timezone, and also using the following format date time:

formatDateTime('Deadline','yyyy-MM-dd')

I understand that an ISO 8601 format is always formatted as yyyy-MM-dd. However, I can't figure out how to fix the reformatting formula. Or maybe it's another issue?

Here is my flow:

Here is the error:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Priyae on at

Like (0)

Report

Hey @oaghaei ,

Check the solution here for your need :

Solved: Error- The datetime string must match ISO 8601 for... - Power Platform Community (microsoft.com)

Thanks

Was this reply helpful? Yes No
oaghaei 173 on at

Like (0)

Report

Hello @pre - thank you for your response. I tried to formatdate because I thought maybe its a simpler solution:
formatDateTime('Deadline','MM/dd/yyyy')

However, when I pipe that into the html table, it gives me the following error. Do you think the solution you are proposing with splitting the date would solve this?
InvalidTemplate. The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "Opportunity Title": "@item()?['Title']", "Deadline": "@formatDateTime('Deadline','yyyy-MM-dd')", "Agency": "@item()?['Agency_x0020__x0028_full_x0020_n/Value']", "Category ": "@item()?['Category/Value']", "Amount": "@item()?['Award']", "Homepage": "@item()?['Homepage_x0020_link']" }' failed: 'In function 'formatDateTime', the value provided for date time string 'Deadline' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

The expression is trying to format the text 'Deadline' as MM/dd/yyyy.
The expression needs to refer to the SharePoint field Deadline using item()?['Deadline'] in the expression:
(I'm guessing that the SharePoint field is called Deadline.)

Ellis

____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
oaghaei 173 on at

Like (0)

Report

@ekarim2020 Elis, thank you so much! I didn't realize the "item" addition was required. This did it!!! So happy.

Was this reply helpful? Yes No