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 II
Dual Super User II

@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 II
Dual Super User II

@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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,512)