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
Solved! Go to Solution.
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.
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.
{
"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
@dbro thanks for the hint with Get past time, didn't know about its existence.
I solved this that way:
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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
28 | |
27 | |
27 |