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.

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.

View solution in original post

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 User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (20,080)