Sending an Email Reminder for a Due Date Using Power Automate

Hello,

I have created a "tracker" spreadsheet for a task process. I am using 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

I have followed this video to set up a Flow for the Reminder Letter due date (I was assuming I could 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 (apologies for no screenshot, it doesn't let me upload it):

Step - Apply to Each

ActionFailed. An Action failed. No dependent actions succeeded

Create HTML Table

InvalidTemplate. Unable to process template language expressions in action 'Create_HTML_table' inputs at line '0' and column '0': 'The template language expression 'outputs('Filter_array')['body/value']' cannot be evaluated because property 'body/value' doesn't exist, available properties are 'body'. Please see https://aka.ms/logicexpressions for usage details.'.

Any assistance would be most appreciated.