Trying to pull select files from a document library to make a flow efficient enough to run (thousands of files, only need ~100 pulled for comparison purposes)
Using Get Files Properties Only and have tried both Filter Queries and Folder limit without success.
With Filter Queries I can't seem to filter using the path - the document library has a folder for each year going back to 2017, but only need to compare two most recent years (2024 & 2025). It seems that substringof() is the recommended method, but FileDirRef is just giving the filename, not the path/folders. I can see the outputs have a {Path} and a {Link} field that both contain what I need and would work, but those column names don't appear to be valid.
There's also the limit by Folder option, but the folders don't seem to populate from this document library in the pulldown, and manually entering either 2025 or a dozen variations I can think of gives a Bad Request error.
Any ideas/suggestions? The ultimate goal is to get a list of files from a source directory, compare to these files in the Document Library, and if they already exist in the document library, delete from the source directory. I've got the rest of it all laid out and it appears to be working, just can't get the list of files from Document Library to compare the source list to.
