web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a Flow for Em...
Power Automate
Answered

Creating a Flow for Email Reminder for Due Date

(0) ShareShare
ReportReport
Posted on by 4

Hello, 

 

I am very new to Power Automate, but I am trying to set up a flow to send out email reminders 30 days prior to the due date. I actually have the flow set up and running but I have a couple of questions/issues. 

First, I am not sure if I set up the recurrence correctly. Right now I have it set to every day, but I'd like to have it run just once a week. My question is if I do weekly, will it pick up all the dates within that week or just the date that the flow is running? For example, if I have the dates listed as 2/19 and 2/21 and I run the flow on 2/20, will it send it to both or neither ?

 

I also have a couple of vendors that have the same due date so it is sending out multiple emails to the same person even though they have different contact information. The flow will send 4 emails out, 2 are correct, 2 are incorrect with mismatched information of the other provider.

For example:

Provider A, reminder date: 09/10/2023, 

Provider B, reminder date: 09/10/2023,

on the reminder date:

Provider A receives two emails one with correct information, one with information of Provider B

 

I hope this all makes sense. Thanks in advance! 🙂 

Categories:
I have the same question (0)
  • Verified answer
    v-chengfen-msft Profile Picture
    on at

    Hi @GabrielaT

    I made a template for your reference

    Here is sharepoint list

    vchengfenmsft_6-1677042855739.png

    Here is flow

     

    vchengfenmsft_1-1677037729616.png

    Use the filter query to filter out the records of the next month

    reminderdate gt '@{addToTime(utcNow('yyyy-MM-dd'),1,'Month')}' and reminderdate lt '@{addToTime(addDays(utcNow('yyyy-MM-dd'),7),1,'Month')}'

    vchengfenmsft_2-1677037793787.png

    Because a Provider may have multiple pieces of information, the Provider and the corresponding Email [Select] will be displayed.

    vchengfenmsft_3-1677037889063.png

    Remove duplicate Providers through the union() formula

    Filter the records through the filter array

    vchengfenmsft_4-1677037955965.pngvchengfenmsft_5-1677037985786.png

    Here is result:

    vchengfenmsft_7-1677043241742.png

    vchengfenmsft_8-1677043254331.png

     

    Best Regards

    Cheng Feng

     

  • Danyia_Zia Profile Picture
    4 on at

    Hi @v-chengfen-msft 

     

    I was wondering if you might be able to help me with the same issue. When I try to format the expression for mine it says invalid expression. I want to send an email 4 weeks before the edited text due date to a specific user. 

     

    Screen Shot 2023-06-12 at 2.32.00 PM.pngScreen Shot 2023-06-12 at 2.31.27 PM.png

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard