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

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,127)