Using Power Automate to send E.-Mail Reminders.

[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?

[trice602]

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.

[Casper_2012]

Thank you.

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

[Casper_2012]

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.

[Casper_2012]

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:

[Casper_2012]

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