2 New filter options in Get Files action in SharePoint connector

Get files filter options

2 New filter options in Get Files action in SharePoint connector

By:

Date:

Remember last week’s posts about getting all files in a folder in SharePoint? I used the Send an http request to SharePoint action avoiding the odata filter options in the get files action.

I mentioned the Get files (properties only) action as shown below.

Get all files using get files action

Get files

Well today the Get files (properties only) action has some new options available.

Get files filter options

Folder Filter options

The options now available are Limit Entries to Folder and  Include Nested Items.

Include Nested Items

In the Limit Entries to folder option you can supply the folder location. In the Include Nested Items you can say yes or no to include sub folders or not.

Get Items Action

Even though in lists it is less common to include folders. It is not impossible to have folders, hence the options mentioned above have been included in the get items action as well.

2 New filter options in Get Files action in SharePoint connector

Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There’s a better way — and I can show you exactly what it looks like. I’m the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I’ve been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://staging.sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://staging.sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@staging.sharepains.com

3 responses to “2 New filter options in Get Files action in SharePoint connector”

  1. Rogier Avatar
    Rogier

    When I choose “Include Nested Items” I get no results (only {
    “@odata.nextLink”: “https://flow-apim-europe-001-francecentral-01.azure-…..”,
    “value”: []
    }

    Set on No, I get only the items in the folder (like expected)
    Tested in multiple tentants.

    Is this familiar ?

    1. derondisme Avatar

      It seems this occurs when the document library contains thousands of documents. According to this forum post, the zero-results bug occurs when the Include Nested Items is set to Yes and the library contains more than 5000 files, regardless if you are targeting a sub-folder with only a few of those files in it. https://powerusers.microsoft.com/t5/I-Found-A-Bug/Power-Automate-Sharepoint-Get-Files-Properties-Only-Include/m-p/786578#M8567

  2. zylantha Avatar
    zylantha

    I have the same issue! This was driving me nuts. This new option is clearly broken.

    What is interesting is that “Include Nested Items” works on the first 15 or so folders in the library, but as soon as I “Limit Entries to Folder” and specify the 16th or later folder, then the result is empty – but if I turn off “Include Nested Items” then it works.

    I can only conclude that “Include Nested Items” is mostly incompatible with “Limit Entries to Folder”, and this is a BUG.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.