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 their 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 the SharePoint…

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, which stands for Collaborative Application Markup Language, and is used to query against items from SharePoint lists and libraries. This post will teach you the basics of using the CAML query in PowerShell. We’ll show you how…

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 Collaboration Application Markup Language (CAML) is an XML-based language used to define and query SharePoint data. In this article, we will explore how to use CAML to query the Date and Time fields in…

Read more

CAML Query to Filter Yes/No (Check box) Field Values using PowerShell

Requirement: CAML Query to Filter Yes/No Field Values in PowerShell. CAML Query to Filter Yes/No Field Values in SharePoint Online: Let’s use PowerShell to query Yes/No field type values from a SharePoint Online list. 

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: Lookup fields in SharePoint allow users to select a value from another list, which is then linked to the current list item. Lookup fields are used to create a relationship between two lists. CAML (Collaborative…

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 In SharePoint Online, the Person or Group field allows users to select one or more people or groups from a SharePoint site. CAML (Collaborative Application Markup Language) is an XML-based…

Read more