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’ve a document library with a 100s of documents in several sub-folders and wanted to bulk update metadata of all those documents. While quick edit is one…

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 We have a list called “Projects” with a bunch of columns and wanted to update items from a CSV file. Here is the PowerShell CSOM script to update the SharePoint Online list from…

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

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 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, Create…

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 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: Browse to your…

Read more

SharePoint Online: Export List Items to CSV using PowerShell

Requirement:  Export SharePoint online list items to CSV file from client side. PowerShell Script to Export SharePoint List Items to CSV: Here is how you can export SharePoint online list to CSV via PowerShell Please note, this script gets all list items under a list, but doesn’t recursively get items of folders…

Read more