SharePoint Online: Upload a Folder using PowerShell

Requirement: Upload a Folder to SharePoint Online using PowerShell. How to upload a Folder to SharePoint Online Document Library? You can upload a folder along with its contents to SharePoint. Here is how to upload a folder with its sub-folders and files to a SharePoint Online document library: Navigate to your SharePoint…

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: Import XML to List using PowerShell

Requirement:  Import XML to SharePoint Online List PowerShell to Import XML to SharePoint Online List Here is the PowerShell to import XML to the SharePoint Online list My XML Structure: Here is my List structure I’ve created before running the script: Here is my another post written for SharePoint On-premises: PowerShell to…

Read more

SharePoint Online: Export Site Collection Administrators to CSV Report

Requirement: Get Site Collection Administrators Report for SharePoint Online. You must have site collection Admin rights, in order to get existing site collection administrators of a SharePoint Online site through PowerShell! PowerShell to Get Site Collection Administrators in SharePoint Online and Export to CSV: Let’s get site collection admins of all SharePoint…

Read more

SharePoint Online: Export List Version History to Excel using PowerShell

Requirement: Export all versions of SharePoint Online List Items to CSV (Excel) file. PowerShell to Extract and Export List Item’s Version History to CSV File: This article assumes you have an existing SharePoint Online list with columns given below. You may have to create and change columns according to your requirement. Important:…

Read more

SharePoint Online: Find and Delete Orphaned Users using PowerShell

What is “Orphaned Users” in SharePoint Online? In short, orphaned users are those who deleted from the authentication provider (such as removed from Active Directory when the user leaves the organization), and still continue to exist in SharePoint online sites! Scanning each user in the SharePoint Online site collection for orphaned users…

Read more