"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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,985 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@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