cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vaibhav_k
Resolver II
Resolver II

Help Send reminder notification with flow

Dear community experts,

I am building a flow that has to send reminders for expired contracts. The due dates are from multiple region lists. The configuration list contains data mapping of region with the task list along with the frequency of reminders before and after expiry. Now the flow should send reminders before and after the expiry date. How to plan the scheduled flow. 

 

List structure-

1) config 

Region task list inactive beforeexpiry afterexpiry

 

2) tasks list different  for each region

Assigned to and due date 

 

Mission-

 

SEND REMINDERS for each contract library in the region list till months specified in before and after expiry.

1 ACCEPTED SOLUTION

Accepted Solutions
Vaibhav_k
Resolver II
Resolver II

Resolved using multiple formula.

View solution in original post

2 REPLIES 2
Vaibhav_k
Resolver II
Resolver II

Dear community,

 

I have refined requirement as- 

 

The configuration list has some reminders in months e.g. 6 reminders should be sent before due date in each of  tasks list. If the data has passed then after expiry 1 email should trigger each month after the expiry.

 

Vaibhav_k_0-1654699279185.png

 

 

Vaibhav_k_1-1654699288043.png

 

I have created a flow as under. But how to check for the months condition and send email after get items action. Can someone please guide?

 

Vaibhav_k_2-1654699295584.png

 

Vaibhav_k
Resolver II
Resolver II

Resolved using multiple formula.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,167)