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,474 Super User 2025 Season 2 on at

Like (2)

Report

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

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,436 Super User 2025 Season 2 on at

Like (2)

Report
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

It works in this way:

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

Thank you!

1 people found this reply helpful.

Was this reply helpful? Yes No