Using a Flow to Send an Email on a Due Date

[Sarah24601]

Hello,

I have created a "tracker" spreadsheet for a task process. I am using Excel in Office 365 and the document is saved in my OneDrive for Business.

I am looking to set up an automated reminder email to be sent when a date is a certain column is reached. I am attempting to use Power Automate to achieve this.

My table has a lot of columns as it covers a full process, however I have listed the columns relevant to this query below:

TeamMember - Contains the email address of the person allocated the task

Address - The subject of the task

EndDate - This is the deadline date for the task

ReminderLettersDue - This is a date 7 days before the End Date

My aim is to get an automatic email sent to the email address in the TeamMember column with a list/table of the Address details on the date that reminder letter are due, and set up an additional Flow to do the same thing for the End Date.

I have followed this video to set up a Flow for the Reminder Letter due date (I was assuming I could create a copy the completed Flow for Reminder Letters and edit it for the End Date). https://www.youtube.com/watch?v=1g7NA5hYYSo

The only difference between this video and my Flow is that they have used Value in Filter Array and Create HTML Table, whereas I have used Body/Value, as the option for Value doesn't appear for me. I'm not sure if this is just due to my version of Power Automate being more updated that the version they used (the video is from 2022), or if there's something I'm doing wrong which makes it not appear.

I have tried to test my Flow, but I have the below error messages (screenshot below).

Any assistance would be most appreciated.

[janessanelson]

I am not sure what is in your filter array category. I would personally use a string variable instead of an HTML table. You can add in various html coding into a variable and it will translate into the email. 

You will need to initialize the variable at the beginning of the workflow. 

I would also recommend using a condition function within your Apply To Each loop. Within the condition, you can write an expression that essentially says "if empty(filter array) is false" then do this action. You would want to use the "append to string variable" action so that it can potentially write a number of different rows to send in 1 email. 

Hopefully this works and helps!