Announcements
Hi,
I can't seem to understand where I'm going wrong, using this post as a reference: https://powerusers.microsoft.com/t5/General-Power-Automate/ODATA-filter-for-checked-out-files-in-SharePoint/m-p/1389639#M82887
The search filter for finding ou checked out files doesn't seem to be working, if I check what files are checked out via the library settings the filter doesn't seem to be picking it up.
This is the filter query I was using: CheckoutUser ne null
The oData filter you are using looks correct.
So, what I suggest you do is investigate the output of the Get files action and verify if the CheckoutUser field is populated in your JSON output.
Just checked, definitely in the JSON Output.
Not the input, I mean the output of the Get files.
Sorry, I'm not sure where to check that? Or how to.
Sorry for the delay, here's what the output is from that tab.
The result indicates that there are no results from your "Get files" operation. Have you applied a Filter?
So that filter is the checkedoutuser filter, if I take it out it does seem to work but looks like it's capped to 100 files.
You can update the threshold to 1000.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 231 Super User 2026 Season 2
David_MA 217 Super User 2026 Season 2
Mohsin Ali 170
