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 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 items…

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: How to Use CAML Query in PowerShell?

Requirement: Use CAML Query with PowerShell in SharePoint Online. CAML is an XML-based query language, It stands for Collaborative Application Markup Language and used to query against items from SharePoint lists and libraries. CAML Query Elements and Operators: Here is the commonly used elements and operators in CAML queries. Operator Meaning Eq…

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 you are 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…

Read more

SharePoint Online: CAML Query for Date Time Field 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 “created date” field. CAML Query to Filter by Date Field: CAML to filter by date, Say, Get Project List items where the “Project…

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 projects list where the “Priority” choice field is “Medium” SharePoint CAML for Multiple Choice Let’s get all projects where the priority multichoice column has…

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 lookup field. SharePoint CAML Query to Filter Lookup Field by ID: Since the lookup text defined in the…

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 “Project Manager” user field value is a particular person. SharePoint CAML Query Filter by User Name: The above PowerShell…

Read more