Answered

Unable to process template language expressions in action 'formatDateTime'

(0) Share

Report

Posted on by maurics

Hi there!

I'm building a flow using Excel's "For a selected row" and I'm having trouble setting the formatDateTime in some cases.

I'm using the compose action to format the date using this expression formatDateTime(outputs('Obtener_formato_de_fecha_Excel'),'dd/MM/yyyy')

But i'm getting this error:

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

Here some screen shots from the flow

The flow continues and the data is stored in a SharePoint list and it should look like this

Hope the community can help me.

Mauricio.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Michael E. Gernaey 53,479 Super User 2025 Season 2 on at

Like (1)

Report
Hi,

Unfortunately if your Date is formatted like that it won't work.
You would need to reverse the dates yourself. If its only a format of mm/dd/yyyy (ignoring case on purpose) then you can do the following

In my example you can see I have a variable with the Date like yours.
I use a Compose to flip it

// Replace variables('MyDate') with your data concat( split(variables('MyDate'),'/')[1], '/', split(variables('MyDate'),'/')[0], '/', split(variables('MyDate'),'/')[2] )

Please note, I don't know if yours has hours etc, if so we will need to tweek it some and you should always verify you even have a date too.

If this meets your needs please Mark this response as Resolved.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
maurics 45 on at

Like (1)

Report

Hi @FLMike !

Thanks you very much for the suggestion! The problem was solved!

Was this reply helpful? Yes No