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

[omelo]

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

[v-bofeng-msft · Accepted solution]

Hi @omelo :

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

Please try this flow:

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

 Best Regards,

Bof

[omelo]

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