cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omelo
Helper I
Helper I

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
v-bofeng-msft
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
v-bofeng-msft
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

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
Power Automate News & Announcements

Power Automate News & Announcements

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

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,579)