Filtering a table and emailing from list

Hi all,

I have an Excel table with a list that updates periodically. It has a Region field that lists State/Province. This table is generated based on a rolling relative date that is 30 days away from an event date starting (field name for this is Start Date)

I have a table in another xlsx file (both are in Sharepoint) that includes the same Region field/values, a Name and an Email Address value on the same row.

Objectives:

- check the first table for entries based on Region

- 2 weeks / 14 days from the event Start Date (a field) , email a list of all rows where the Region matches the Region field of the email address in the second table

-The email sent occurs only once (aka not every day 14 days and closer)

I’m just not sure how to express in Power Automate:

- How to automatically filter the region (eg “ON”)

- How to email the email address that is attached to the matching Region value on the second table

- How to ensure that address is only emailed once

Some guidance on how to build the steps here would be hugely appreciated - thanks! ❤️

Quick Links

Leaderboard > Power Automate