Sent Notification when Expiration is 90 Days away.

Like (0) Share

Report

Posted on 25 Mar 2025 18:36:43 by Trout19

369

I have a SharePoint list with a Column Name Expiration date. I would like to send an email notification if Expiration date is 90 days away. I confused on how to set the notification to notify 90 days away.

Categories:

General

All responses (1)

Answers (1)

Verified answer

DJ_Jamba 2,815 Super User 2025 Season 1 on 25 Mar 2025 at 22:23:12

Like (0)

Report
Sent Notification when Expiration is 90 Days away.

1. Schedule your flow to run every day at e.g. 8am

2. Use a compose action to create an object containing the date in 91 days and the date in 90 days

{ "Day90": @{addToTime(utcNow(),90,'Day','yyyy-MM-dd')}, "Day91": @{addToTime(utcNow(),91,'Day','yyyy-MM-dd')} }

3. Use the Get Items action with an oData query filter to find items in your list where Expiration date is 90 days from now

I'm assuming the internal column name in your list is Expiration_x0020_date so:

(Expiration_x0020_date lt '@{outputs('Days_90_and_91_from_now')?['Day91']}') and (Expiration_x0020_date ge '@{outputs('Days_90_and_91_from_now')?['Day90']}')

This means get records that have an expiration date less than midnight in 91 days time and greater than midnight in 90 days time (covering all possible timestamps in day 90).

You can copy and paste both of the code examples straight into the expression editor.

4. Test it