FLOW TO SEND EMAIL WHEN DATE APPROACHES

[Yattering82]

Hi there

This is the first time posting in the forum but a long time user of the forum. What I am trying to do, is to get a flow to trigger an sending an email when the date of a required audit approaches. The audit due dates are listed in a SharePoint list and you would think that this would be a simple thing to do. However, no matter how much I tinker and how much I see what others have done, I cannot get this to work.

This is what I have done:

@equals(item()?['Nextauditdue'], adddays(utcnow(),'mm-dd-yyyy')+14)

So basically I want this to send me an email when it is 14 days to the audit due date. 

If anyone can shed light on this, I would be most grateful.

[Lemony]

ok, I will try that solution. thank you

[SmokeEater1996]

I can not see the formula used in the Apply to each step

[kristof805]

@SmokeEater1996 , the apply to each step has been modernized since this thread was created. 

What are you trying to accomplish? Which part are you stuck at? 

To replicate something similar to the original post, I have in my apply to each step the following:

formatDateTime(item()?['Due_x0020_Next'], 'MM/dd/yyyy')

is equal to

formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy')

The above is checking my "Due Next" column, which is filled with dates, are 30 days away from today's date.

[SmokeEater1996]

I'm trying to do something very similar to what you have here, I will try that formula thanks.

[SmokeEater1996]

This is what I have and it does not work. @kristof805 

[kristof805]

@SmokeEater1996 I think you got several things happening here that I can already see:

• You are using the formula under the Filter Query section of Get Items instead of Apply to each step. This may change things.
• Your formula is missing the number of days, which can be put as 0 if you want to check for the same today's date. Check the exact formula code on my previous codes. You cannot omit parts, as far as I know.
• Your column name is most likely wrong. Please look at your output under Get Items step after your flow ran. It'll show you the correct formatting of the column name. For example, I have a column called "Due Next" but I have to type it in as "Due_x0020_Next" when using it in different Flows.
• You'll also need quotes around your formateDateTime formula in your Filter Query.

What errors are you getting, if any?

[Jacobpetley57]

So I'm not to sure this will help out or not,I have 0 experience with microsoft or coding/programming...

I've managed to upgrade my Android platform from 9 to 12+without documentation work adding microsoft. Downloaded flow today and learning about flow and buttons/push notifications and decided to share it with Edge and it said solved in green highlight to your link. So there you have it. Maybe you could return the favor...