cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Kudo Kingpin
Kudo Kingpin

@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
Kudo Kingpin
Kudo Kingpin

@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

{
"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

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

 

I solved this that way:

reminder07.PNG

 

Thank you.

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.

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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!

Top Solution Authors
Users online (3,539)