Hi everyone
I want to have a flow run at set times that checks if files have been moved between folders in a library. To do this I have created a custom column in the library called OriginalPath and this is populated with the file path when a new document is created. My scheduled flow then checks for all documents in the library where the path and original path don't match.
At the moment I can only do this by using Get Files (Properties Only) and then filtering this output by documents where the original and current paths don't match and where IsFolder is false ( I only want to check documents not folders):
This works fine but the issue I have is that eventually this library will grow and the number of documents will be over 5,000. As I understand it, the maximum number of files that can be brought back by Get Files is 5,000 so if there are more than that they won't all be queried and my filter may not show all the documents it should?
To get around this potential issue I wanted to use the OData filter query in Get Files. However, I can't seem to reference IsFolder or Path as it says these columns cannot be found. Is there any way of referencing these files in OData or will I just have to find a way of limiting the library to under 5,000 for this to work?
Any advice would be gratefully received.
Thanks.
