Share
Report
119Hi all, I am baffled. I have used ODATA queries 100s of times, but a very simple query is exhibiting very strange behavior and I can't figure it out.
The Flow: I am using a Get Files (Properties Only) (SharePoint connector) to retrieve a set of files from a SharePoint Library. I only want to retrieve files in which 'Active' is marked true. Active is a yes/no column type. The SharePoint library has 203 total documents, and 119 of them show Active=true.
Below is my filter query. My top count far exceeds the number of files in the library. The Compose action uses the length function to count the number of files returned.
Get files
You can see that the internal field name for the Active column is 'Active'
Internal field name
The Length function shows that only 68 files were retrieved by the query. It should have retrieved 119.
Test results
When I examine the raw outputs of the Get Files, it shows that all 68 items retrieved have Active = false. Literally the opposite of what the query should be pulling.
json payload
I have tried all sorts of queries, such as Active ne false, Active eq 'true', Active eq 'false', and none of the queries retrieve the full set of files that it should. In fact, changing the query from Active eq true to Active eq false did not change the items retrieved at all. Odder still, using Active eq 'true' returned 22 items, even though the column never contains strings.
Has anyone ever encountered anything like this? Am I overlooking something? I feel like I'm going crazy - I have literally done 100s of these and I have hit a wall in troubleshooting this one.
Thanks in advance.
All responses (
Answers (
