@Shubhabrata The Get files (properties only) action will return all files and folders from the selected document library. You are already filtering out files only by using the FSObjType eq 0 query.
However, you want to filter out files that are in specific folders and you'll need to use a Filter Array action to do that. Please note: I'm using the Classic Designer as the new designer is still buggy.
Return File Count
Whenever I use a Filter Query in a Get files (properties only) action, I always like to return the count of files returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.
Insert a Compose action. Add an Expression. Use the length() function.
Select the Dynamic content tab and insert the value dynamic content from the Get files (properties only) action into the length() function.
Run a test. Review the outputs. Confirm the file count is what you are expecting. Remember this is the total file count based on your Filter Query.
Filter Array
Add a Filter Array action to your flow. Insert the value dynamic content from the Get files (properties only) action into the From field. In the first value field, insert the Folder path dynamic content form the Get files (properties only) action. Change the operator to does not contain. In the second value field, enter the folder name. You'll need to enter it exactly how it appears in your doc library (it's case sensitive).
Insert one of the folder names first (for testing).
Again, I would recommend adding a Compose action to store a count of the filtered files.
In the length() function insert the body dynamic content from the Filter Array action.
Run a test. Review the output of the Compose actions storing the file counts and compare.
Although it may look like the Filter Array action can only take a single condition—it can take multiple conditions when using the Advanced Editing Mode. Refer to this section of my YT Tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?
I'll cover how to use multiple conditions in a Filter Array action. I'll also cover the following:
✅ 3 Ways to Use the Filter Array Action
✅ How to use the Scope Action to Group Actions
✅ How to Check the Number of Items returned from a Filter Array Action
✅ How to Cross-Reference Data in Excel with a SharePoint List
✅ How the Filter Array Action Works
✅ How to Access the Dynamic Content from a Filter Array Action
✅ How to Filter Items by a Key
✅ How to Filter Items by Matching a Substring
✅ How to Use Multiple Conditions in a Filter Array Action
Hope this helps!
If I helped you solve your problem—please mark my post as a solution
✅.
Consider giving me a
👍 if you liked my response!
👉 Level up your Power Automate skills by checking out my tutorials on
YouTube👉 Tips and Tricks on
TikTok and
Instagram
