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.
Announcements
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.
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.
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.
Please guide me to clear the expression error.
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.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1