How to use Filter query expression to fetch documents created more than a year ago

[hiprateek007]

Hi,

I am new to power automate and I am trying to build a simple reminder flow which will trigger an email to document owner if the document on a Sharepoint site was created more than a year ago. 

I am using Get Item action and I suppose using Filter query is the best way to fetch relevant items. I need some help how can I form the expressing using the Created column in Sharepoint. 

Essentially I am after following condition to be satisfied: (CreationDate+365<= TodaysDate). If this can be achieved I can then send an email for each item. 

If this cannot be done using filter query let me know in case of any alternatives.

Thanks

Prateek M

[v-bacao-msft · Accepted solution]

Hi @hiprateek007 ,

Please try to use Get files action and paste the following expression in Filter Query:

Created le '@{addDays(utcNow(),-365,'yyyy-MM-ddTHH:mm:ssZ')}'

Best Regards,