cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmurray
Advocate I
Advocate I

Send email on specific, manually-inputted date

Hi all,

 

Might someone please know how to schedule a flow to send an email on a specific date I manually-input into a flow?

 

I need to send a quarterly process reminder email to a list of people in a SharePoint list, but the quarterly date isn't exactly the same day every 3 months for the recurrence action, so I want to manually input the dates for the next couple of years into the flow.

 

Any idea how to simply achieve this?

 

Thanks in advance,

Carla

1 REPLY 1
Diksha
Resolver IV
Resolver IV

Hi @cmurray,

You can achieve this easily by doing below steps -
1. Create one configuration list which will hold a date values on which you want to send an email and one flag which will set

    to Yes once you send an email on that particular date.

    For ex- List name EmailDateConfig with a column EmailDates and isEmailSent column of type Yes/No ( Set default to No ).
     Capture1.PNG
2. Use a Recurrence trigger in a flow and get item from EmailDateConfig list with filter isEmailSent = No and

    EmailDates =Todays date.
    Capture2.PNG


3. If Get Items output is not blank , then send an Email and then Update an item and set isEmailSent to Yes  else no action

    is required.
    Condition -

    

length(outputs('Get_items')?['body']?['value'])

Capture.PNG

    

You can anytime change or add new date values into the list and you don't have to go into the flow to change the dates .

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
Thank You !!!

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,217)