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!
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.
Let's assume you have a requirement where you need a notification for payment dues before 2 days.
- Create a schedule workflow(Scheduled—from blank)
- Get SharePoint items
- For each loop(Apply to each)
- 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