Migrate SharePoint 2010 Document Libraries to SharePoint Online using PowerShell

June 16, 2019    , , , , , ,
Requirement: Migrate Document Libraries from SharePoint 2010 to SharePoint Online. How to Migrate SharePoint 2010 Document Libraries to SharePoint Online? The idea is: Export all document libraries from SharePoint On-premises to local drive, export metadata of each document to a CSV file and then Import them to SharePoint Online. Before we begin, Please note, this is not a full fledged migration script which can migrate metadata, security, version history, etc. This script only copies document libraries with its file-folders and metadata "Created by", "Created On", "Modified By", "Modified On" to SharePoint Online. You need 3rd party migration tools if you want migrate all missing pieces! Step 1: Export SharePoint On-Premises Document Library As a first step, Login to any of your SharePoint On-premises web front end server and run the below PowerShell script to export either a single document library or all document libraries from ShareP
Migrate SharePoint 2010 Document Libraries to SharePoint Online using PowerShell Migrate SharePoint 2010 Document Libraries to SharePoint Online using PowerShell Reviewed by Salaudeen Rajack on June 16, 2019 Rating: 5

SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell

May 19, 2019    , ,
Requirement: Change Classic Experience to Modern Experience and Modern UI to Classic in SharePoint Online. How to Activate Modern Experience from Classic? The modern experience in SharePoint Online lists and libraries is faster, mobile friendly and easier to use.  It brings new functionalities and components, However, some features can only be used in the classic experience. So, you may need to switch between modern UI and classic experience in SharePoint Online. To enable modern experience in SharePoint Online, use the link "Exit classic Experience" at the bottom left corner. This turns ON modern experience. To disable modern experience and switch back to classic in SharePoint Online use the link "Return to Classic SharePoint" PowerShell to Switch Between Modern Experience and Classic Experiences To enable modern experience, we have to disable classic experience feature and to disable modern experience we should re-enable the classic experience feature
SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell Reviewed by Salaudeen Rajack on May 19, 2019 Rating: 5

SharePoint Online: Find Duplicate Files using PowerShell

April 23, 2019    , ,
Requirement: Find Duplicate Documents in SharePoint Online. When multiple people from different teams work together, there is a huge possibility for duplicate content in SharePoint. People may have uploaded a same document to different libraries or even different folders in document libraries. So, How to find duplicate documents in SharePoint Online? SharePoint Online: Find Duplicate Documents using PowerShell - File Hash Method Lets find duplicate files in a SharePoint Online document library by comparing File hash. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Parameters $SiteURL = "https://crescenttech.sharepoint.com" $ListName ="Documents" #Array to Results Data $DataCollection = @()
SharePoint Online: Find Duplicate Files using PowerShell SharePoint Online: Find Duplicate Files using PowerShell Reviewed by Salaudeen Rajack on April 23, 2019 Rating: 5

How to Get Office 365 Group Members using PowerShell?

April 07, 2019    ,
Requirement: Get Members of Office 365 Group using PowerShell How to Get Office 365 Group Members? To get a list of members in Office 365 group from Microsoft 365 admin center, Login to the Microsoft 365 Admin Center site: https://admin.microsoft.com Expand Groups and Click on Groups link in the left navigation.  Groups page lists all groups in your Office 365 tenant. Pick the desired group to list users in group. This opens the group's details page which lists group members PowerShell to Get Group Members in Office 365: Here is the Office 365 PowerShell get group members #Get Credentials to connect $Credential = Get-Credential #Create the session $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ ` -Credential $Credential -Authentication Basic -AllowRedirection #Import the session Import-PSSession $Session -DisableNameChecking #Get all Members of Office 365 Group Get-Unifie
How to Get Office 365 Group Members using PowerShell? How to Get Office 365 Group Members using PowerShell? Reviewed by Salaudeen Rajack on April 07, 2019 Rating: 5

How to Export a List Template in SharePoint Online using PowerShell?

January 30, 2019    , ,
Requirement: Export List Templates in SharePoint Online using PowerShell List templates in SharePoint Online enables you to reuse any list with its fields, formulas, formatting, and optionally data in other site collections without re-creating the list again. List Templates should be downloaded and uploaded to another sites in order to create lists from it. Here is how to download a list template SharePoint Online. How to Export a List Template in SharePoint Online? To download a list template from SharePoint Online site,   Click on Settings gear >> Site settings page >> Click on "List Templates" under Web Designer Galleries (List template gallery in SharePoint Online URL: https://yourdomain.sharepoint.com/_catalogs/lt/Forms/AllItems.aspx) In the "List templates Gallery", Click on "Name" column link for the list template you want to download.  This triggers file download prompt, click Save to download the file. List Templates fe
How to Export a List Template in SharePoint Online using PowerShell? How to Export a List Template in SharePoint Online using PowerShell? Reviewed by Salaudeen Rajack on January 30, 2019 Rating: 5

How to Import List Template in SharePoint Online using PowerShell?

January 30, 2019    , , ,
Requirement: Import List Templates in SharePoint Online using PowerShell Why we need list templates in SharePoint Online? Well, If you have a list with set of columns and customization in SharePoint Online, You can reuse it in any other site collections without re-creating the list again from the scratch. A list template contains fields, formulas, formatting, and optionally data as well. List Templates can be downloaded and uploaded to another sites. Here is how to use list template SharePoint Online: SharePoint Online List Template Gallery URL List template gallery in SharePoint Online URL: https://yourdomain.sharepoint.com/_catalogs/lt/Forms/AllItems.aspx How to Import a List Template in SharePoint Online? List templates (.STP) downloaded, should be uploaded to any site collection's list template gallery in order to re-use. Here is how to upload a list template to SharePoint Online. Go to Settings >> Site settings page >> Click on "List templates"
How to Import List Template in SharePoint Online using PowerShell? How to Import List Template in SharePoint Online using PowerShell? Reviewed by Salaudeen Rajack on January 30, 2019 Rating: 5

Connect Existing Team Sites to New Office 365 Group

January 26, 2019    ,
Requirement:   A SharePoint Online team site (Classic / Modern Experience) users wants to  transform their existing site to Office 365 group to take advantage of Office 365 Group offerings such as Shared mailbox, Planner, Teams, etc. How to Connect to New Office 365 Group in SharePoint Online? When you create a new Office 365 group, there will be an associated SharePoint Team site is created automatically. In this case, we need a new Group with an existing team site. To start with, make sure connect to Office Group is enabled at tenant level. Login to SharePoint Online Admin Center >> Click on Settings from left navigation In settings page, under "Connections from sites to Office 365 groups", Set "Allow site collection administrators to connect sites to new Office 365 groups". Not all site templates can be associated with Groups (Not supported: BICENTERSITE#0, BLANKINTERNET#0, ENTERWIKI#0, SRCHCEN#0, SRCHCENTERLITE#0, POINTPUBLISHINGHUB#0, POINTPUBLI
Connect Existing Team Sites to New Office 365 Group Connect Existing Team Sites to New Office 365 Group Reviewed by Salaudeen Rajack on January 26, 2019 Rating: 5

SharePoint Online: Get OneDrive URL of a User using PowerShell

January 25, 2019    , , , ,
Requirement: PowerShell to Get OneDrive URL in SharePoint Online How to Get OneDrive URL of a User? Typically, OneDrive sites are located at the URL: https:// tenant -my.sharepoint.com/personal/ upn   (E.g. https://crescent-my.sharepoint.com/personal/salaudeen_crescent_com), To get a SharePoint Online user's OneDrive site, follow these steps: Login to SharePoint Online Admin Center Click on "User Profiles" link from left navigation >> Click on "Manage User Profiles" link under "People" group Search and pick the user profile which you want to gain access. From the search result, Click on the menu item "Manage Personal Site" from the context menu. This takes you to the OneDrive site! SharePoint Online: PowerShell to Get OneDrive URL Let's query user profile to retrieve Personal site URL. Remember to set the user name and admin site URL parameters prior running the script. #Load SharePoint CSOM Assemblies Add-Type
SharePoint Online: Get OneDrive URL of a User using PowerShell SharePoint Online: Get OneDrive URL of a User using PowerShell Reviewed by Salaudeen Rajack on January 25, 2019 Rating: 5

SharePoint Online: Grant Permission to Each Folder in a Document Library using PowerShell

January 23, 2019    , , , , , ,
Requirement: Grant permission to all sub-folders in a SharePoint Online document library SharePoint Online: Grant Permission to Folders using PowerShell Here is the PowerShell to add a user to each folder in SharePoint Online list or document library. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Set Config Variables $SiteURL = "https://crescent.sharepoint.com/sites/marketing" $ListName = "Documents" $UserAccount = "Salaudeen@crescent.com" $PermissionLevel= "Contribute" #Function To call a non-generic Load Method Function Invoke-LoadMethod() { Param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide a Client Object"), [stri
SharePoint Online: Grant Permission to Each Folder in a Document Library using PowerShell SharePoint Online: Grant Permission to Each Folder in a Document Library using PowerShell Reviewed by Salaudeen Rajack on January 23, 2019 Rating: 5
Powered by Blogger.