
Announcements
Hi,
I am trying to create a flow to check Last Modified Date on all files within a folder (with subfolders).
If the Last Modified date is > 1 year from current date, then to create a planner task to update the file.
I have tried using get metadata and When item was last modified but have not been successful.
Use the Get files (properties only) action and configure it as shown below:
The expression used in the filter query is:
formatDateTime(addDays(utcNow(),-365),'yyyy-MM-dd')
Note, by default this will only return 100 items. If the folder and subfolders contain more than 100 files that are more than a year old, you will need to enable pagination on this action so it can return more items. This is a good article on pagination: Understanding Pagination in Power Automate - DEV Community