Unanswered

Using Power Automate to send E.-Mail Reminders.

(1) Share

Report

Posted on by Casper_2012

I don't know if this has already been answered, so apologies, if it has been.

I have a Spreadsheet, set up, as a Table, with a List of Employees, their Contract Expiration Date, and the Date that I wanted to be reminded, of the Expiration Date.

I want a Flow to check all of the Reminder Dates, and send me an E.-Mail, for each of those Dates that match Today's Date, containing each Name, and Expiration Date. So let's I run the Flow, on Friday, and the Reminder Date Column has five Reminder Dates, that match the Date that it'll be, on Friday, I want to get five E.-Mails, with the Name, and the Contract Expiration Date, in the Body.

Right now, I run the Flow, but I'm not getting the correct number, of E.-Mails, and the contents aren't what I want. I get one, or two E.-Mails, containing the words "Name", and "Expiry".

Can anyone help me out?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Casper_2012 ,

Here's a flow that will work for you; modify as needed.

This runs daily at 5 AM.

List rows in your table, filter by Reminder eq 'expression' and set date format.

formatDateTime(utcNow(), 'yyyy-MM-dd')

Next add send email action. Add any dynamic content, such as the example below, and this action will wrap itself in an apply to each or for each loop (same thing, different names). Then for each row that equals today's date, you send an email to yourself.

In this example, I got the first 3 rows in separate emails. You could have other columns of course, this is just an example for you to make it your own.

Was this reply helpful? Yes No
Casper_2012 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you.

I'll try this, tomorrow, and see if it works.

Was this reply helpful? Yes No
Casper_2012 10 on at

Like (0)

Report
Copy link

Link copied!
Ok, I've set it all up, and Power Automate is telling me that it all succeeded, but the E.-Mailing isn't happening.

In the Filter Query, I'm using

formatDateTime(convertFromUTC(utcNow(), 'GMT Standard Time'), 'dd-MM-yyyy')

as the Dates are set up. on the Spreadsheet, as "DD/MM/YYYY", i.e.: 27/05/2024, with the Locale being "Ireland"

and at least, "as a Test", I've set it up to send the E.-Mails, to the same Address that they'll be getting sent from, but when I change it, to sent them to another Address, the E.-Mails still aren't sending.

Was this reply helpful? Yes No
Casper_2012 10 on at

Like (0)

Report
Copy link

Link copied!

I decided that I wanted to be sent ONE E.-MAIL, containing all of the Names, and Dates.

The other day, I got it doing that, but sending the same number of E.-Mails, and today, it's sending one E.-Mail, with no details.

How I want the information:

Was this reply helpful? Yes No
Casper_2012 10 on at

Like (0)

Report
Copy link

Link copied!

Getting rid, of the Filter Array seemed to solve the problem. Will try, with a few other Names, tomorrow, to confirm.

Was this reply helpful? Yes No