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

Send an email reminder when an item hasn't been modified in 2 weeks

I'd like to receive an email reminder if an item in a SharePoint list is open but hasn't been updated in 2 weeks so I know to go update it. 

 

Every test returns every item as failing (no condition) despite the fact that some of those items are older than 2 weeks. 

flow screenshot.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Send an email reminder when an item hasn't been modified in 2 weeks

The problem is with your use of FormatDateTime().  That will return a string containing the date taht you have calculated.  But to do the comparison you need a dateTime variable not a string.  Just remove the formatDateTime from the outside of your calculation and try again.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
Highlighted
Dual Super User
Dual Super User

Re: Send an email reminder when an item hasn't been modified in 2 weeks

The problem is with your use of FormatDateTime().  That will return a string containing the date taht you have calculated.  But to do the comparison you need a dateTime variable not a string.  Just remove the formatDateTime from the outside of your calculation and try again.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Top Solution Authors
Users online (6,703)