
Hi,
So I currently have a flow that gets files in a SharePoint library with a date that is greater than today and deletes them. I know that the get file properties action has a limit of 5000 files, but I was wondering if this takes into account the optional filter query. For example, without a filter query the action retrieves up to 5000 files in the library, but I am wondering if using the filter query option means the action takes up to 5000 files that satisfy that filter criteria?
Hey @Anonymous - If the Top Count property is left blank, the Get files property returns just 100 entries. Because the threshold limit is 5000, you can use '4999' as the top count limit. You can utilise the Pagination concept in the GetFiles action to loop through and take action if the library has more than 5000 files.