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:

All responses (12)

Answers (0)

Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

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

Good to know that it worked !

Have a nice day !
Joellelechat 49 on at

Like (1)

Report

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

hi @Nived_Nambiar , thanks so much for all your help. After more tests and troubleshooting, the answer to my solution is: formatDateTime(parseDateTime(items('Apply_to_each')?['Day']), 'dd/MM/yyyy', 'en-GB'). Also, the emails were not been sent out because in the advanced options I tried to send the email from another mailbox which I don't have access to. After I removed the "sending from" and updated the expressions it worked. Thanks again for your time.
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

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

@Joellelechat

Any updates 🙂 ?
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

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

Hi @Joellelechat

I think day value is empty as seen from error,

Could you check that ?
Joellelechat 49 on at

Like (0)

Report

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

hi @Nived_Nambiar ,
thank you so much for trying to help.
I tried replacing with the codes and got the following errors:
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

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

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 🙂
Joellelechat 49 on at

Like (0)

Report

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

hi @Nived_Nambiar , you mean these?
Thanks for helping ~
Joelle
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

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

Hi @Joellelechat

Please show the value of date appearing in power automate flow ?
Joellelechat 49 on at

Like (0)

Report

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

hi @Nived_Nambiar , no, it is still failing:
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

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

Hi @Joellelechat

Did it worked for you ?