Renewal Reminder

[TheSlawekG]

Hi,

I have a SP list:

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.

And my result:

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

[dbro · Accepted solution]

@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.

[TheSlawekG]

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

 Any idea?

Thank you.

Slawek

[TheSlawekG]

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

I solved this that way:

Thank you.

[ruckers]

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]

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.