SharePoint Online: Bulk Update Metadata Properties from a CSV File using PowerShell

Requirement: Bulk Update Metadata of Multiple Documents from a CSV in SharePoint Online. SharePoint Online: PowerShell to Bulk Edit Metadata Properties from a CSV File We have a document library with 100s of documents in several sub-folders and wanted to bulk update the metadata of all those documents. In comparison, the quick…

Read more

SharePoint Online: Update List Items from a CSV File using PowerShell

Requirement: Update SharePoint Online List from a CSV using PowerShell. PowerShell to Update SharePoint Online List from CSV File Have you ever needed to update SharePoint Online list items from a CSV file? Perhaps you need to do some bulk editing of list data. In this guide, we’ll show you how to…

Read more

SharePoint Online: Fix Lookup Field using PowerShell

Problem: SharePoint Online lookup column in a list is broken when the parent lookup list is recreated! Root Cause: SharePoint Online list lookup columns are connected with its parent lookup list column through the “List” (GUID of the parent list) and “ShowField” attributes. When the parent lookup list is re-created, its GUID…

Read more

SharePoint Online: Export List Data to XML using PowerShell

Requirement: Export SharePoint Online List data to XML file. PowerShell to Export SharePoint Online List to XML XML file generated through PowerShell script: This PowerShell script extracts data from all columns and exports to XML. You may have to handle columns like People Picker, Lookup, etc., separately. Last but not least: You…

Read more

SharePoint Online: Get Lookup Column Value using PowerShell

Requirement: Get Lookup field value in SharePoint Online using PowerShell. Scenario: We have a parent list called “Parent Projects” and a child list “Project Milestones”. The “Parent Project Name” field in the child list is being looked up from the parent list’s “Project Name” field. Here is my PowerShell script to get…

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

How to Use Choice Field in Lookup Columns in SharePoint?

Problem: Could not create lookup columns on Choice field in SharePoint list! Solution: Not all column types are supported in the lookup column. Supported column types are: Single line of text,  Number, Date and Time,  Calculated (Single Line of text),  External Data So, what’s the trick? Well, in the parent lookup list,…

Read more

SharePoint Online: PowerShell to Update Lookup Field Value

Requirement: Update the Lookup field using PowerShell in SharePoint Online. We have a parent list called “Parent Projects” and a child list “Project Milestones”. The “Parent Project Name” field in the child list is being looked up from the parent list’s “Project Name” field. Here is my PowerShell script to set lookup…

Read more

SharePoint Online: Add Lookup Column to List using PowerShell

Requirement: Create a new Lookup Column to a SharePoint Online List. How to Create Lookup Column in SharePoint Online List? The Lookup column in SharePoint Online lets you populate the column value based on another column’s value from a different list on the same site. To add a lookup field, follow these…

Read more

SharePoint Online: Export List Items to CSV using PowerShell

Requirement:  Export SharePoint Online list items to a CSV file. How to Export Sharepoint Online list items to Excel or CSV? Do you need to export data from a SharePoint Online list to CSV? There could be several reasons why you might want to export SharePoint Online list items to Excel or…

Read more