web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : jPHNFijUASdFdLar5ztIvi
Power Automate - Building Flows
Answered

Get Files inside a Document Set

Like (0) ShareShare
ReportReport
Posted on 24 Apr 2024 10:02:35 by 51
Hi all,
 
Is there a way to get all files inside a specified Document Set like example: /Library Name/Folder Name/Document Set Name.
Because when I'm using 'Get files (properties only)' I'm only able to limit entries up to Folder ex. /Library Name/Folder Name
BlueGosu_0-1713952912709.png


Thanks and Regards,

  • Verified answer
    BlueGosu Profile Picture
    51 on 08 May 2024 at 00:58:18
    Re: Get Files inside a Document Set

    Hello,

    I have already fixed this issue by using a "Send an HTTP request to SharePoint" and using the following uri:

    _api/web/GetFolderByServerRelativeUrl('Library Name/Folder Name/Document Set Name')/Files

    BlueGosu_0-1715129834675.png

     

  • Expiscornovus Profile Picture
    32,169 Most Valuable Professional on 27 Apr 2024 at 14:59:05
    Re: Get Files inside a Document Set

    Hi @BlueGosu,

     

    Do you have a lot of documents/document sets in your library? In that case have a look at the pagination settings of your get files (properties only) action.

     

    For a reference also look at this thread: https://powerusers.microsoft.com/t5/General-Power-Automate/SharePoint-Get-Files-Properties-Only-Exceeds-the-list-view/td-p/2240517

     

  • BlueGosu Profile Picture
    51 on 25 Apr 2024 at 00:17:41
    Re: Get Files inside a Document Set

    Hi @Expiscornovus 

    (substringof('@{variables('DocumentSetName')}',FileDirRef)) and (FSObjType eq 0)


    I tried that filter query but unfortunately it's resulting to an empty value (there should be about 9 files inside the Document Set). Output image below:

    BlueGosu_0-1714004194062.png

     

  • Expiscornovus Profile Picture
    32,169 Most Valuable Professional on 24 Apr 2024 at 10:32:15
    Re: Get Files inside a Document Set

    Hi @BlueGosu,

     

    You could try and use a Filter Query instead of the Limit Entries to Folder setting. You can use the Path (aka FileDirRef) for this. You can also include a filter on Item Type (aka FSObjType).


    Can you try the below?

    (substringof('@{variables('DocumentSetName')}',FileDirRef)) and (FSObjType eq 0)

     

    filedirref.png

     

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.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete