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

[Jon5]

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.

[alrez]

Hi,

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')

Regards,

Alex

-------

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.