Unanswered

String date not recognised in flow

(0) Share

Report

Posted on by HEW

Hello,

I have a flow that pulls dates from a table in excel and some dates are pulled into the sharepoint list and others give the below error and I am not sure why as they are no differently setup than the other dates in the table and I am using the ISO advanced option when getting the items from the table.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The date you are inputting isn't in ISO 8601 format. I would make sure you use a FormatDateTime around that dynamic content to make sure its in the right format. According to the error its coming in as 31/03/2025 and should be 2025-03-31.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
HEW 8 on at

Like (0)

Report
Copy link

Link copied!

Hello Pstork1

Thanks, but all the dates are the same format in the excel table, and the other dates are exactly the same I have 62 entries in the table, there are 10 odd dates that seem to come up with this error and the rest seem to have no problem updating the sharepoint list?

I am still not sure what to do? Thanks for the help

Was this reply helpful? Yes No
lbendlin 8,701 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

As @Pstork1 was saying - ALWAYS, always use ISO8601 format. ALWAYS.

Was this reply helpful? Yes No