Sending Notification by End Date - Get Items

[H_Insights]

Hi all,

I am trying to create an email notification that gets triggered when an item on the SharePoint list is due in 7 days. Here are the criteria:

• End Date > Today (i.e. 01/05/2022) 'dd-MM-yyyy'
• End Date = 7 days from today (i.e. 08/05/2022) 'dd-MM-yyyy'.

So when an item is only 7 days away from today, an email will be triggered. 

Here is what I tried so far with no success :

Any idea please?

Thanks

[abm · Accepted solution]

Hi @H_Insights 

 You already working out the 7th day and format as yyy-MM-dd. That is good enough to get the records. You don't need the utcNow() expression here. Also remember utcNow() expression returns the Date and Time. Remove the first condition utcNow() and it should work as expected.

Thanks 

[H_Insights]

Thanks @abm . That was nice and easy! Cheers