Strange issue with my SharePoint "Get files (prop only)" sometimes finding the files and sometimes not.
I have a SharePoint library with files that have the date as part of the file name. Usually there will be one or 2 files with each date, sometimes none.
I am using a filter in my "get files" to return a list of files found that meet my filter (the date).
But when I run the flow with a date for a file I know is there, it sometimes finds it and sometimes doesn't.
My filter = FSObjType eq 0 and substringof('@{variables('varStartDate')}',FileLeafRef)
The value of varStartDate is a string and will be something like = '2022-03-20'
Again, sometimes it works and sometimes not. There are less than or about 100 files in these folders right now, but over time it will grow to around 500. No sub folders for now either, but when there are some in the future, I would want to exclude them from the search.
(I plan to move files over a year old into a subfolder by year. I will not be searching those.)
So I will change "include nested items" to no.
My flow cycles through about 20 folders checking each one individually, and adding a link to each located file to an array variable.
Any thoughts on why this isn't working correctly?
