Get Files inside a Document Set

Like (0) Share

Report

Posted on 24 Apr 2024 10:02:35 by BlueGosu

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

Thanks and Regards,

All responses (4)

Answers (1)

Verified answer

BlueGosu 51 on 08 May 2024 at 00:58:18

Like (0)

Report
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
Expiscornovus 32,169 Most Valuable Professional on 27 Apr 2024 at 14:59:05

Like (0)

Report

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 51 on 25 Apr 2024 at 00:17:41

Like (0)

Report
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:
Expiscornovus 32,169 Most Valuable Professional on 24 Apr 2024 at 10:32:15

Like (0)

Report
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)