Skip to main content

Notifications

Community site session details

Community site session details

Session Id : dWB9txilEEEXjkXbwCOquj
Power Automate - Building Flows
Answered

Recurrence Flow for Expiration Date checking

Like (0) ShareShare
ReportReport
Posted on 28 Sep 2019 23:42:48 by

I am in the process of creating a Recurrence flow to check customers in a list. I want it to check the customers Expiration Date, and if its 2 days from expiring I want it to send me an email telling me to contact the customer.  I am actually thinking about having an email go to the customer as well letting them know they are about to expire. Need help with the Condition fields. Everything else seems to work fine, just that part.

  • Verified answer
    v-litu-msft Profile Picture
    on 30 Sep 2019 at 05:29:53
    Re: Recurrence Flow for Expiration Date checking

    Hi @Anonymous,

     

    Please refer to these steps:

    Step 1. Create a Recurrence trigger runs every day.

    Step 2. Then add Get items action to get the items, then use the addDays() function to find these items' DueDate (Expiration date) is 2 days after. If it is, send an email to the customer.

    addDays(utcNow(),2,'yyyy-MM-dd')

    Annotation 2019-09-30 132508.png

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Community Power Platform Member Profile Picture
    on 29 Sep 2019 at 17:44:16
    Re: Recurrence Flow for Expiration Date checking
    Hi

    You need to use the addDays expression with a minus value

    addDays(triggerBody()?['ExpirationDate'],-2)

    Please mark this as a solution if I have helped you.

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

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 125

#2
David_MA Profile Picture

David_MA 122 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 110 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete