is it possible to trigger an email using microsoft flow when a date in a field of a sharepoint list item is nearby,

Question

I want to build a flow to trigger an email when a date in one of the fields is nearing. I have a field named Payment due date. is it possible to trigger an email 2 days prior to the Payment due date. So that I don't miss the payment due date and payment is not delayed. Any kind of assistance is appreciated. Thank you very much in advance!

Answer 1

Try using a schedule workflow. Which will run,

• every hour
• every day
• every month

Then apply a condition where you can mention if payment due date is today, tomorrow or day after tomorrow.

When condition match you can send a notification or an email to your self.

Brief Description

Let's assume you have a requirement where you need a notification for payment dues before 2 days.

1. Create a schedule workflow(Scheduled—from blank)
2. Get SharePoint items
3. For each loop(Apply to each)
4. apply condition(if else),

 formatDateTime(item()['PaymentDueDate'],'yyyy-MM-dd')

 is equal to

 addDays(utcNow(),2,'yyyy-MM-dd')

For more information, reminder before the due date