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 Exporting a SharePoint Online list to an XML file using PowerShell can be a useful way to make a backup of the list or to transfer the list data to another system. In this article,…

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 called “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…

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

How to Use Choice Field in Lookup Columns in SharePoint?

Problem: Could not create lookup columns on the Choice field in SharePoint list! Solution: Want to use a choice column as a lookup in SharePoint? Well, Not all column types are supported in the lookup column. Supported column types are: In SharePoint, a Lookup column allows you to create a relationship between…

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 a 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. Adding a lookup column using PowerShell…

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? You might want to export SharePoint Online list items to Excel or CSV for several reasons. For example,…

Read more