Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Get Files inside a Document Set

(0) ShareShare
ReportReport
Posted on 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 at
    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
    31,844 Most Valuable Professional on at
    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 at
    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
    31,844 Most Valuable Professional on at
    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492