Latest Posts

Set View Query in SharePoint using PowerShell

The example in this topic show how to use PowerShell to Set View Query in SharePoint
  • Using PnP (Pattern and Practice) PowerShell commands, you can access and manipulate SharePoint objects easily.
  • Prerequisite: You have to install cmdlets to work in PnP PowerShell.

How to run PnP PowerShell command in SharePoint?

  • First, open powershell ise.
  • powershell ise
  • Make sure you run it in Administrator Mode.
  • Now, copy and paste the code mentioned below and click on Run Script as shown in the screenshot.
  • powershell ise run command

  • # Provide credentials over here
  • $creds = (New-Object System.Management.Automation.PSCredential "<<UserName>>",(ConvertTo-SecureString "<<Password>>" -AsPlainText -Force))
  •  
  • # Provide URL of the Site over here
  • # If you do not wish to pass credentials hard coded then you can use: -Credentials (Get-Credential). This will prompt to enter credentials
  • Connect-PnPOnline -Url http://MyServer/sites/MySiteCollection -Credentials $creds
  •  
  • # Get Context
  • $clientContext = Get-PnPContext
  •  
  • # -List: The list object or name of the list
  • # -Identity: The View Name
  • $targetView = Get-PnPView -Identity "View Name" -List "New list"
  •  
  • # Set the view Query
  • $targetView.ViewQuery = "<Where><Eq><FieldRef Name = 'Title' /><Value Type = 'Text'>India</Value></Eq></Where>"
  •  
  • $targetView.Update()
  •  
  • $clientContext.ExecuteQuery()
  •  
  • Disconnect-PnPOnline

Thank you for reading this article. This code was tested in SharePoint 2013


We value your Feedback:

Page URL:

Name:

 

Email:

 
 

Suggestion:

 

© 2024 Code SharePoint