cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TheSlawekG Helper I
Helper I

Renewal Reminder

Hi,

 

I have a SP list:

reminder02.png

I'd like a reminder to be sent to a person once Renewal date will be less than 31 days. So far I achieved sending reminders to both persons although only Slawek should receive one. Both persons receive an email with the same content that Slawek's renewal is close.

reminder01.png

reminder03.png

 

And my result:

reminder04.png

reminder05.png

My second condition is false and that's correct. However, in condition 1 which is True, the Flow sends 2 emails, to both Persons from the SP list, if I add there more, all will receive an email about Slawek's renewal date.

 

How I can send an email only to the Person that Renewal date is less than 31 days?

 

Thank you.

 

Slawek

 

1 ACCEPTED SOLUTION

Accepted Solutions
dbro Kudo Kingpin
Kudo Kingpin

Re: Renewal Reminder

@TheSlawekG,

 

Is you trigger a daily trigger? 

 

If so your get items action should have a filter query like:

Following should work:

1.) insert "Get past time" action

2.) set value to 31 Days

3.) Insert get items action

4.) Insert filter query so that = Renewal Date (MAKE SURE YOU"RE USING SP FIELD INTERNAL NAME) le '[Value of Past Time]'

5.) apply to each - send email!  

 

If this helps you achieve your result, please mark it as answered.

View solution in original post

5 REPLIES 5
dbro Kudo Kingpin
Kudo Kingpin

Re: Renewal Reminder

@TheSlawekG,

 

Is you trigger a daily trigger? 

 

If so your get items action should have a filter query like:

Following should work:

1.) insert "Get past time" action

2.) set value to 31 Days

3.) Insert get items action

4.) Insert filter query so that = Renewal Date (MAKE SURE YOU"RE USING SP FIELD INTERNAL NAME) le '[Value of Past Time]'

5.) apply to each - send email!  

 

If this helps you achieve your result, please mark it as answered.

View solution in original post

TheSlawekG Helper I
Helper I

Re: Renewal Reminder

{
"status": 400,
"message": "String was not recognized as a valid DateTime. Creating query failed.\r\nclientRequestId: c2f799e1-2597-460b-91ef-9cc472c1cfdf\r\nserviceRequestId: c2f799e1-2597-460b-91ef-9cc472c1cfdf"
}

 

reminder06.PNG

 Any idea?

 

Thank you.

 

Slawek

TheSlawekG Helper I
Helper I

Re: Renewal Reminder

@dbro thanks for the hint with Get past time, didn't know about its existence.

 

I solved this that way:

reminder07.PNG

 

Thank you.

ruckers
Frequent Visitor

Re: Renewal Reminder

Did you put any logic in to make sure multiple emails aren't sent to the same person?  I'm not sure that Flows/Power Automate is smart enough to know that it already sent one.  I plan on setting mine up weekly, so should avoid that.

TheSlawekG Helper I
Helper I

Re: Renewal Reminder

No, I did not. In my case, this is a driving license renewal process and employees will receive an everyday notification as long as they renew it.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,593)