web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate ERROR The datetime str...

Power Automate

Answered

ERROR The datetime string must match ISO 8601 format.'.

(0) Share

Report

Report

Posted on by Serena_Noce

7

Hello,

I have a big problem with this type of error:

My flow cloud is with two conditions:

The error is the 2° condition. The syntax is this:

formatDateTime(item()?['Data'], 'dd/MM/yyyy') is equal

formatDateTime(utcnow(), 'dd/MM/yyyy')

The file is this:

The format date is correct in Excel. So, what is the problem? Thanks

Serena

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Pstork1 69,456 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Check the Excel format for the Data column. I suspect its set for one of the custom date formats rather than one of the builtin date formats. So FormatDateTime on that column is trying to format a string, not a date value

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Serena_Noce,

This is an issue related to ISO format.

Modify your formula as below:

formatDateTime(addDays('01-01-1900', add(int(items('Apply_to_each')?['Oggi']),-2)), 'MM/dd/yyyy')
formatDateTime(utcnow(), 'MM/dd/yyyy')

Was this reply helpful? Yes No
Verified answer

Serena_Noce 7 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the support!
I solved the problem with this setting:
I had not set the ISO8601 value.
Serena

Was this reply helpful? Yes No

Join the conversation