How to set a powershell variable to a specific sharepoint page

Question

I have a SharePoint 2010 documents library that contains about 50 .aspx pages. I want to break inheritance on about 6 pages and set them to specific permissions.

I am able to get a page by numerical index but not by indexing with the page name. I know I can iterate through all the pages and look for a matching name/title field, but I was wondering if I was missing a way to use the known page name directly as an indexer.

For example:

$site = Get-SPSite http://website
$web  = $site.RootWeb
$library = $web.Lists["MyPages"]

$page1 = $library.items[0]
$page2 = $library.items[12]
$page3 = $library.items[15]
etc.

If page1 is MyPage1.aspx I was looking for a way to get it like this:

$page1 = $library.items["MyPage1.aspx"] 
(or something similar).

I did try that, and it didn't work, but now that I look at it closer, all the Titles are empty/null. I tried to set the title to the value in the DisplayName field (which is MyPage1 for the file MyPage1.aspx) but it says Title is a read-only field. — lwbecker2
– lwbecker2, Commented Dec 16, 2013 at 23:14

Naim Murati · Accepted Answer · 2013-12-17 00:16:10Z

1

If you want to get only one item using the file name without looping all the items you can use CAML.

Here is the script for your case:

$query = New-Object Microsoft.SharePoint.SPQuery
$caml ='<Where><Eq><FieldRef Name="FileLeafRef"/><Value Type="File">MyPage1.aspx</Value></Eq></Where>'
$query.Query = $caml
$query.RowLimit = 1
$items = $list.GetItems($query)
$item = $items[0]

edited Dec 17, 2013 at 0:16

answered Dec 17, 2013 at 0:03

Naim Murati

3,5432 gold badges15 silver badges17 bronze badges

Add a comment |

lwbecker2 · Accepted Answer · 2013-12-17 19:19:03Z

0

The CAML option above works, but I ended up using the Where-Object Operator. I pipe the collection of all pages and pick out the one that matches.

$site = Get-SPSite http://website
$web  = $site.RootWeb
$library = $web.Lists["MyPages"]
$pages = $library.items

$page1 = $pages | where { $_.Name -match "MyPage1.aspx"}
$page4 = $pages | where { $_.Name -match "MyPage4.aspx"}

$page1.BreakRoleInheritance($true)
$page4.BreakRoleInheritance($true)

etc.
etc.

edited Dec 17, 2013 at 19:19

answered Dec 17, 2013 at 14:33

lwbecker2

1,4941 gold badge9 silver badges23 bronze badges

2

Very expensive compared to the CAML, but a bit easier markup :)

Robert Lindgren
– Robert Lindgren

2013-12-17 14:34:59 +00:00
Commented Dec 17, 2013 at 14:34
I figured it was probably expensive. The other option I considered for longer term use, was to wrap that CAML into a function in order to improve the mark up.

lwbecker2
– lwbecker2

2013-12-17 15:59:16 +00:00
Commented Dec 17, 2013 at 15:59

Add a comment |

Stack Exchange Network

How to set a powershell variable to a specific sharepoint page

2 Answers 2

Your Answer

Hot Network Questions

How to set a powershell variable to a specific sharepoint page

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions