Power Platform
Power Platform
Organizer:
- Organized by
-
-
Power Automate – Sending email 3 days before a due date
-
Power Automate – Sending email 3 days before a due date
Hello, I have a list with a Due Date in it and I want to send an email when the due date is within 3 days of todays date. Every item in the list has a person assigned to it. An email should go out to each individual with a list of items that are due within 3 days of today that are assigned to that person. I am having an issue with getting all items that are due within 3 days of today.
Has any one else tried this with success that can lend some ideas?
Kind regards,
John -
5 Replies
-
Pablo’s idea wont work as a calculated column only calculates when an item is created/modified.
I would recommend creating a scheduled workflow that runs daily. Add a step to Get Items from your SharePoint list with a filter query of DueDate eq addToTime(utcNow(),+3,’Day’,’yyyy-MM-dd’). This will give you only items where the DueDate is exactly 3 days from today. Then within an Apply to Each loop, send the email to each item’s person assigned
-
I don’t have time to share a screen shot of working code, but this sounds like a great place to use an Odata filter on a SharePoint Get Items action. You would want to test your Due Date against utcNow() + 3 days and only select that record if the Due Date is less than that. That means you are only processing those records you need to touch and also that every record that makes it through the filter needs to be touched.
Good luck!
-
+1 for Landon’s suggestion. I have several Power Automate flows running daily that do just that. If your due date is a manually selected date it’s pretty straight forward with the ODATA filter on the Get Items query. It can be tricky if your due date is a calculated column, but it’s still possible.
-
Thank you @landonjochim for your contribution
The discussion ‘Power Automate – Sending email 3 days before a due date’ is closed to new replies.
