cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Flow to send email when item hasn't been modified within the last 365 days

I'm having difficulties with a flow to notify users when their  documents hasn't been updated in the last year.

 

I set the recurrence to once per day

getitems sharepoint library

The expression on the get items query 

Modifieddate le '

formatDateTime(addDays(utcNow(),-365),'yyyy-MM-dd')'

 

It seems that I can't upload a pic.
Thank you for your help

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @omelo :

The key is that Modifieddate is not the correct field name.It's correct name is ‘Modified’

Please try this flow:

2.JPG

 

formatDateTime(addDays(utcNow(),-365),'yyyy-MM-dd')

 

 Best Regards,

Bof

View solution in original post

2 REPLIES 2
Community Support
Community Support

Hi @omelo :

The key is that Modifieddate is not the correct field name.It's correct name is ‘Modified’

Please try this flow:

2.JPG

 

formatDateTime(addDays(utcNow(),-365),'yyyy-MM-dd')

 

 Best Regards,

Bof

View solution in original post

Thank you for your prompt response!

I should have mentioned that  modifieddate is a custom date column. (Our admins are modifying those documents and they need a custom column to trigger the notification) The name is correct!

After comparing and reviewing with no success in making it work. I decided to delete it and creating a new flow and it worked!!!

I'm marking this as  solution as the expression is the most relevant part to my question. Also making sure the column name is correct is supper important!

Thank you for your help!

Have a great day

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (76,770)