Renewal Reminder

(0) Share

Report

Posted on by TheSlawekG

119

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

dbro 194 on at

Like (0)

Report

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

Was this reply helpful? Yes No
TheSlawekG 119 on at

Like (0)

Report

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

Was this reply helpful? Yes No
TheSlawekG 119 on at

Like (0)

Report

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

I solved this that way:

Thank you.

Was this reply helpful? Yes No
ruckers 7 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
TheSlawekG 119 on at

Like (1)

Report

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.

Was this reply helpful? Yes No