Notifications
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 ,
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.
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.
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.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
