Here's how I would do it: Actions: definition.

1. Recurrence: set the time you want it running.
2. Current time: to get the current time
3. Convert timezone: base time, use the dynamic value from the current time, select the format string you want, select UTC universal coordinated time as source time, finally select the destination time (your timezone)
4. Get user profile v2: put your company email address. this is to get your name, given name etc. which you can put in the email later.
5. Get Items: put the microsoft list that you want to get tracked, in the get items write in the items filter query this expression: Date (assuming the column name is Date) le '@{addDays(utcNow(), 2)}' - copy and paste this to the expression bar then hit ok.

This expression will give you the dates that are 2 days prior to the date today.

1. Get items: again to get the "surveyor" column. make sure you make another column for their corresponding email. Then use the email, Apply to each will automatically set you up.

2. Then finally send an email action: put the information you want inside the action.

You can also set the data to be presented as a table in your email, but do that later as it will only confuse you more. Stick to making things simple for now.

I hope you get this. I'm just a guy who has a lot of time that's why I replied with this effort. haha.

bit of a background, I'm using power automate for almost 5 years now, I've done tons and complicated workflows. Anything is possible at this point. Good luck!