Hi @Brian Curtis ,
1. To use a flow to handle conditions like Expiration Date = today to send out alerts, you can create a Scheduled cloud flow and set it to repeate every day.
Then, you can configure a flow like below.
The Condition set in my flow.
ExpirationDate is a Date and time column in my SharePoint list.
formatDateTime(item()?['ExpirationDate'], 'MM/dd/yyyy') is equal to
2. To set up a flow to send 'expiration date is approaching' notification, please take a reference to the following posts.
FLOW TO SEND EMAIL WHEN DATE APPROACHES
Send an Email Reminder Notification Based on an Expiration Date using Power Automate
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.