cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheSlawekG
Level: Powered On

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
Level 8

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
Level 8

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
Level: Powered On

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

Highlighted
TheSlawekG
Level: Powered On

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
Level: Powered On

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
Level: Powered On

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 & 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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,297)