Automatically email reminders from Excel with Power Automate

(0) Share

Report

Posted on by Aiwekhoe

Hi everyone @Chriddle ,

I have been struggling with this flow for the past few weeks now.

I am trying to email reminders to a particular email address automatically, the reminder dates are in an excel online document.

After building the flow, I discovered that the flow runs successfully but the email address doesn't get the reminder. It seems the condition that I added isn't satisfied.

I have tried formatting and parsing the datetime, but nothing has worked.

Please assist with this.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Chriddle 8,697 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Set DateTime Format to ISO 8601 in List rows action!
If your Excel values are proper formated dates (without time), they are formated like this: 2022-05-04T00:00:00.000Z
To check for equality with this, use following function to retieve today:
convertFromUtc(utcNow(), 'W. Central Africa Standard Time', 'yyyy-MM-ddT00:00:00.000Z')

Was this reply helpful? Yes No
Aiwekhoe 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Chriddle
Your solution worked perfectly

Was this reply helpful? Yes No
ncotela23 101 on at

Like (0)

Report
Copy link

Link copied!

Would you please post your flow here?

Was this reply helpful? Yes No