web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Connector Development / How to get an email fr...
Power Automate - Connector Development
Suggested answer

How to get an email from 90 days of expiration date.

(0) ShareShare
ReportReport
Posted on by ST-01041904-0
I want to build a Power Automate flow where i need to get an email of expiry date in 90 days of the Sharepoint list.
Categories:
Authentication
image (32).png
I have the same question (0)
  • stampcoin Profile Picture
    stampcoin 4,411 Super User 2025 Season 2 on at
    How to get an email from 90 days of expiration date.
    Did you get any challenge when you built your flow ?
    Could you please tell more detail ?
     

    Enjoy Power Platform and have a great day 🚀 |  My LinkedIn

    If the answer helps, please consider 👍, Thanks.

  • VictorIvanidze Profile Picture
    VictorIvanidze 12,711 on at
    How to get an email from 90 days of expiration date.
    And what's your question?
  • Suggested answer
    Tomac Profile Picture
    Tomac 2,595 Moderator on at
    How to get an email from 90 days of expiration date.
     
    I think I understand what you're asking.
     
    You have a SharePoint List populated with items, and each item has an expiration date. When that expiration date is 90 days away, you want to send an email reminder about that item expiring. Is that correct?
     
    If so, you'll start at your Get Items action, using an ODATA filter like this:
    YourExpirationDateFieldName eq '@{addDays(utcnow(),90,'yyyy-MM-dd')}'
    A couple of notes on this filter:
    • You'll need to change YourExpirationDateFieldName to the internal name of the Expiration Date field in your SharePoint List. The internal name may be different from the display name, so it's important to go into a completed flow run and view the outputs of your Get Items action, scroll through until you find the Expiration Date field name, and copy/paste what's in there.
    • How is the Expiration Date column formatted in SharePoint? It needs to be a Date field that doesn't include a timestamp for this simple filter to work. If your column must include a timestamp the filter can be modified, but it will be a bit more complicated.
     
    Next you'll move into your Apply To Each, and inside of that you won't need a Condition to check for the expiration Date because we already did that in the Get Items action.
     
    Hopefully this helps you solve the issue. If it does, please remember to mark this comment as the answer. If not, feel free to come back and clarify your question or ask more questions.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 714 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 519 Moderator

#3
chiaraalina Profile Picture

chiaraalina 317

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans