cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thodge
New Member

Send a weekly email if after a calculated due date

I am trying to build a flow that will send an email to people if they are within 30 days of a training expiring and continue to send an email weekly until the date taken is updated.  I have a SharePoint list with date training was taken and a calculated column that is 11 months after that date.  I can t seem to get the emails to work.  if I use "greater than or equal to" TODAY, I will get a email of every entry.  I have tried several different ways to enter the conditions and either get all results or none.  I cant seem to only get the email for entries that are after the due date.  I ended up using another calculated field to get the number of days between today and the calculated date and only return positive numbers.  Then I can get only the people needing to take the training, but that field only updates if the line is edited and saved. In my head this flow or one very similar should work.  FYI I send the email to myself and the person needing the training. 

Screenshot (18).png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@Thodge 

Please look below:

 

Mira_Ghaly_1-1614650951388.png

 

Adding Through Expression:

Mira_Ghaly_0-1614650893653.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

2 REPLIES 2
Mira_Ghaly
Dual Super User
Dual Super User

@Thodge 

Please look below:

 

Mira_Ghaly_1-1614650951388.png

 

Adding Through Expression:

Mira_Ghaly_0-1614650893653.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

I ended up removing all the format language and went back to a simple condition.  Using the expression pane did the trick my flow now looks like this. Only using the utcNow() formula. 

Screenshot (20).png

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,939)