cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Send Email 3 days before due date

This is my first time building a workflow with Power Automate since my company has switched to SharePoint Online, so I am starting from scratch and need serious help! I am trying to build a workflow from a SharePoint list that will send out an email reminding the project leader that the product is due within 7 days (based off of the date in "Due Date" column). Can someone please guide me in the best way to do this? I can't seem to find anything simple and what I specifically need anywhere online.

 

 

This is the workflow I created and use in SharePoint Designer for another list, so I am basically trying to copy this into Power Automate onto a new list, but can't figure it out.

jessier21_0-1610032638531.png

 

3 REPLIES 3
Super User
Super User

@jessier21  how was your SharePoint designer workflow trigger, on item created or updated?

 

For Power Automate flow, you can create a flow with recurrence trigger, to trigger once daily. Then you can use Get Items actions to fetch items from SharePoint list with following filter query to fetch those items where product is due within 7 days. Thgen you can loop through those items and send email for each item.

 

DueDate eq '@{formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')}'
Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

It was triggered when an item is created. I've added the flow as you suggested, and so far the test email has worked. Will it matter if it starts when an item is created or changed?

@jessier21  it flow starts when an item is created or changed, email will only be triggered when item is changed or created, when you have flow trigger as recurrence, the email will be sent accurately when product is due within 7 days.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (12,282)