SharePoint Online: CAML Query with IsNull and IsNotNull Examples in PowerShell

Requirement: Get all items from a list where a particular filed value is Null. SharePoint Online: CAML Query IsNull Example Here is the example of how the IsNull operator can be used in CAML: SharePoint Online: CAML query with IsNotNull Operator in PowerShell Similarly, You can use “<IsNotNull>” Operator to get list…

Read more

SharePoint Online: Filter List Items based on Created or Modified Date using PowerShell

Requirement: Filter and Get List Items based on its created or modified date values in SharePoint Online using PowerShell. How to Filter and Get List Items Created in the Past 30 Days using PowerShell? Here is the PowerShell example to get list items created in the past 30 days in SharePoint Online…

Read more

SharePoint Online: Get All Items from a List View using PowerShell

Requirement: Get All Items from a SharePoint Online List View in PowerShell. PowerShell to Get List Items from a View in SharePoint Online:  In SharePoint Online, you can use PowerShell to get a list of items from a view. This can be useful if you want to automate tasks that are based…

Read more

SharePoint Online: How to Use CAML Query in PowerShell?

Requirement: Use CAML Query with PowerShell in SharePoint Online. CAML is an XML-based query language, and it stands for Collaborative Application Markup Language and is used to query against items from SharePoint lists and libraries. This post will walk you through the basics of using the CAML query in PowerShell. We’ll show…

Read more

PowerShell: Batch Process Large Lists to Fix “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.” Error in SharePoint

Problem: When working with large lists > 5000 list items, any operation such as Read/update/delete is controlled by the list view threshold. You get an error message when you try to handle large list items: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Solution:…

Read more

SharePoint Online: CAML Query for Date Time Fields in PowerShell

Requirement: SharePoint Online CAML Query to Filter by Date Time Field Values SharePoint CAML: Order By Created Date Here is the SharePoint Online CAML Query to order by using the “created date” field. CAML Query to Filter by Date Field: CAML to filter by date, Say, Get Project List items where the…

Read more

SharePoint Online: CAML Query for Choice Field in PowerShell

Requirement: CAML Query for Choice Field in SharePoint Online using PowerShell. Get List Items Where a Choice Field is Equal to Particular Value: Let’s get all projects from the projects list, where the “Priority” choice field value is “Medium”. SharePoint CAML for Multiple Choice Let’s get all projects where the priority, a…

Read more

SharePoint Online: CAML Query for Lookup Field in PowerShell

Requirement: CAML Query for Lookup field in SharePoint Online using PowerShell CAML for SharePoint Lookup Field Value: Let’s filter projects by parent project lookup field value “Address Book”. Here is the SharePoint CAML for a lookup field. SharePoint CAML Query to Filter Lookup Field by ID: Since the lookup text defined in…

Read more

SharePoint Online: CAML Query for Person or Group Field in PowerShell

Requirement: SharePoint Online CAML Query for Person or Group field SharePoint Online: CAML Query to Filter Person or Group Field in PowerShell Let’s say we want to filter and get all projects where the “Project Manager” user field value is a particular person. SharePoint CAML Query Filter by User Name: The above…

Read more