Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Flow with email notification based on date inputted on Microsoft Form - but one day before inputted date!

I have a flow set up to send a notification with key details when a Microsoft Form is completed. This is a sickness reporting report when someone can't come into work.

One of the questions asked is an estimated return date for the person.


I would like to set up an email notification based on this estimated return date which will notify the line managers one day before the estimated return date.


I seem to send a notification on the date listed, but can't seem to work out how to do it for the day before? Clearly this date will change each submission.

Community Support
Community Support



You just need to get date-1 from the entered date. Something like below should get you close to what you want.


DateField eq formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-dd')








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

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,598)