Unanswered

Format Date string to DateTime format

(0) Share

Report

Posted on by NicolleAbraham

Hi everyone,

I am getting dates from an Excel sheet, the ISO 8601 format seems to break if the format in the Excel sheet breaks. This often happens (the format in the excel sheet breaking) due to the number of people copying and pasteing into the sheet. I have therefore decided to import the dates as strings they are of the format '13.11.24'. I get the error: The template language function 'parseDateTime' was unable to find the locale associated with 'dd.MM.yy'. The provided locale name is either invalid or does not have a locale associated with it.

Here is the code;

formatDateTime(parseDateTime(items('For_each_1')?['Start Date'],'dd.MM.yy'),'yyyy-MM-dd')
 
Any help would be appreciated.
TIA

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Expiscornovus 33,181 Most Valuable Professional on at

Like (2)

Report
Format Date string to DateTime format

The parsedatetime function has two parameters, the first one is the locale, the second one is the format.

https://aka.ms/logicexpressions#parsedatetime

'dd.MM.yy' is not a locale, that's why it is confused.

parseDateTime('<timestamp>', '<locale>'?, '<format>'?)

Try the below instead:

formatDateTime(parseDateTime(items('For_each_1')?['Start Date'], 'en-us', 'dd.MM.yy'),'yyyy-MM-dd')

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Verified answer

NicolleAbraham 93 on at

Like (0)

Report

Format Date string to DateTime format

Thanks Expiscornovus that helped with the error!

I then got another error realting to some dates changing to numbers. I had to go into excel and create a calculated table where all the data I would be pulling would be 100% clean in order to avoid any further Power Automate failures.

Was this reply helpful? Yes No