Get items in specific folder in Sharepoint online document library with Powershell PNP

Question

How to get the column values of the items in a Sharepoint online document library using Powershell PNP? If all the document would have been in the root folder in the library, this works great.

Connect-PnPOnline –Url https://<company>.sharepoint.com/sites/<Site> –Credentials (Get-Credential)
$Item = Get-PnPListItem -List "SampleList" -Fields "Id","TestColumn"
$Item.FieldValues.TestColumn

However, I need to query the items in a subfolder that exists in "SampleList". And that seems to be harder.

Accodring to the documentation I can use -FolderServerRelativeUrl,

Get-PnPListItem -FolderServerRelativeUrl "/sites/<Site>/Lists/SampleList/Folder1"

But it cannot find the parameter -FolderServerRelativeUrl....

Get-PnPFolderItem : A parameter cannot be found that matches parameter name 'FolderServerRelativeUrl'

Any ideas of other cmdlets I can use?

Andreas · Accepted Answer · 2020-08-05 12:55:30Z

2

I soon realized that Get-PnPListItem returns all items, including folders and subfolders :) So I ended up using a Where-Object to filter the items instead.

$Item = Get-PnPListItem -List "SampleList" -Fields "Id","TestColumn" | Where-Object {$_.FieldValues.FileRef -like "*Folder1*"}

edited Aug 5, 2020 at 12:55

answered Aug 5, 2020 at 8:32

Andreas

8653 gold badges13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Baker_Kong · Accepted Answer · 2020-08-06 06:41:02Z

0

I am able to call the mentioned cmdlet:

Get-PnPListItem -List Samples -FolderServerRelativeUrl "/sites/contosomarketing/Lists/Samples/Demo"

I tested it on my SP online environment:

My site url: https://abc.sharepoint.com/sites/sbdev
The library is the default library (Shared Documents)
Subfolder name:

Test:

So I suggest you have a check the value of 'FolderServerRelativeUrl' then have a try again.

BR

answered Aug 6, 2020 at 6:41

Baker_Kong

1,8991 gold badge8 silver badges10 bronze badges

Collectives™ on Stack Overflow

Get items in specific folder in Sharepoint online document library with Powershell PNP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related