The datetime string must match ISO 8601

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi,

I am reading a CSV file with one row of data and add this to a Dataverse table.

The CSV has this format:

Accion,IDEmpleado,Nombre,Primer apellido,Segundo apellido,Fecha,Departamento,IDManager,Duracion prueba,Fecha nacimiento,CodBaja
Alta,003968,PETER,SOUMXX,CARNXXX,17/10/23,TRANSF_EXCUR_ALC,001071,6,12/05/93,

And I need to take the two dates:

17/10/23

12/05/93

But when I open the CSV file in Excel, I get the year in format yyyy.

So, I have a flow that get the CSV, Parse JSON the content and get these data:

And when I want to add a row to a Dataverse table, I get this error:

Unable to process template language expressions in action 'Add_a_new_row' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '17/10/23' was not valid. The datetime string must match ISO 8601 format.'.

In the Add New Row action, I have this formula in the dates fields:

formatDateTime(item()['Nacimiento'], 'MM-dd-yyyy')

It has been working for a while, but I do not know why is not working now.

Thanks for any help!

Categories:

Building flows

I have the same question (2)

All responses (4)

Answers (1)

lbendlin 8,649 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

ISO-8601 is YYYY-MM-DDTHH:NN:SS.FFFF (plus time zone)

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report
Copy link

Link copied!

Hi, is there any way to apply this format to a value, like this?

formatDateTime(item()['Fecha'], 'MM-dd-yyyy')

Was this reply helpful? Yes No
Verified answer

Chriddle 8,672 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
The function formatDateTime() can only handle values that are recorgnized as date string by PA.

This can be ISO-8601 or some American localisations.

Here you need the function parseDateTime() to convert your value to ISO-8601.

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#parseDateTime

parseDateTime('17/10/23', 'es-es')

This returns the value '2023-10-17T00:00:00.0000000' that can be formatted with function formatDateTime(), if needed.

1 people found this reply helpful.

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report
Copy link

Link copied!

It works in this way:

parseDateTime(item()['Nacimiento'], 'es-es')

Thank you!

1 people found this reply helpful.

Was this reply helpful? Yes No