Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Send Email before 90 days from due date based on calculated column value

(0) ShareShare
ReportReport
Posted on by 2

Hi 

I want to send reminder email before 90 days from due date.

Since its calculated column unable to set reminder based on due date.

 

I'm new MS flow please could you advise the expression to make it done. 

 

udhayamoorthyb_0-1640828463243.png

 

 

  • tom_riha Profile Picture
    10,127 Most Valuable Professional on at
    Re: Send Email before 90 days from due date based on calculated column value

    Hello @udhayamoorthyb ,

    using 'Filter array' would unnecessarily complicate your flow, it's much easier to filter the items directly in the 'Get items' action using Filter Query as described in the blog post.

  • udhayamoorthyb Profile Picture
    2 on at
    Re: Send Email before 90 days from due date based on calculated column value

    Hello @tom_riha 

     

    Thanks for your response. However, i cant fix the error in using filter array.

     

    Calculated column X + 180 days. Send reminder before 30 days from calculated column value

    Example : 29 Jan 22 (30 days). Today + 30 days. 

     

    udhayamoorthyb_0-1640863770809.png

     

    udhayamoorthyb_1-1640864077137.png

    Please guide me to clear the expression error.

  • tom_riha Profile Picture
    10,127 Most Valuable Professional on at
    Re: Send Email before 90 days from due date based on calculated column value

    Hello @udhayamoorthyb ,

    you must replicate the calculation from the calculated column in the flow - if it's some date+90 days then you should use the same calculation also in the Filter Query, I wrote about it in a blog post.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1