Flow failing excel onedrive send emails reminders - The datetime string must match ISO 8601 format

(0) Share

Report

Posted on by Joellelechat

Hello MS Power Community ~

Help please,

I am getting the following:

"Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'In function 'parseDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'"

Some context: I have an excel table on OneDrive for Business. header column 'Day' contains date format 31/03/2023 (date at which the event is hosted) and I am trying to make a flow that sends an email reminder to hosts 2 weeks before an event and then another reminder 1 week before the event.

I have 2 variables:

formatDateTime(convertFromUtc(addDays(utcNow(),14),'AUS Eastern Standard Time'),'dd/MM/yyyy')

formatDateTime(convertFromUtc(addDays(utcNow(), 7), 'AUS Eastern Standard Time'), 'dd/MM/yyyy')

I also got the following:

Categories:

Using flows

I have the same question (0)

All responses (12)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Joellelechat

I think date in excel may be appearning in numerical format when running flow in power automate
could you select this highlighted option and run the flow again ?

Was this reply helpful? Yes No
Joellelechat 49 on at

Like (0)

Report

Hi @Nived_Nambiar ,
thanks so much for helping.
Yep, I got that date time format set.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Joellelechat

Did it worked for you ?

Was this reply helpful? Yes No
Joellelechat 49 on at

Like (0)

Report

hi @Nived_Nambiar , no, it is still failing:

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Joellelechat

Please show the value of date appearing in power automate flow ?

Was this reply helpful? Yes No
Joellelechat 49 on at

Like (0)

Report

hi @Nived_Nambiar , you mean these?
Thanks for helping ~
Joelle

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Joellelechat

Sorry for late response, Day format is correct, could you try this condition instead of highlighted one below

formatDateTime(items('Apply_to_each')?['Day'],'dd/MM/yyyy','en-GB')

Try this and let me know if it worked 🙂

Was this reply helpful? Yes No
Joellelechat 49 on at

Like (0)

Report

hi @Nived_Nambiar ,
thank you so much for trying to help.
I tried replacing with the codes and got the following errors:

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Joellelechat

I think day value is empty as seen from error,

Could you check that ?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

@Joellelechat

Any updates 🙂 ?

Was this reply helpful? Yes No