SharePoint Online: How to Deploy a Design Package Solution (WSP) using PowerShell?

December 30, 2018    , ,
Requirement: Deploy a design package solution (WSP) in SharePoint Online. Prerequisites: You must activate publishing infrastructure feature both at site collection and site levels before deploying any design package! How to Deploy a Solution Package using PowerShell? You may have a solution package WSP file for site template or design package for branding or some other sandbox solution, Here is how the SharePoint Online Solution Deployment works: Upload the WSP File to Solution Gallery and Activate the solution: Use the following steps to deploy a WSP solution in SharePoint Online. Log in as a Site Collection Administrator >> Navigate to your SharePoint Online Site Collection (Root Site) >> Click on "Site settings". In the site setting page, Click on "Solutions" link under the "Web Designer Galleries" section. This opens the solution page as below screen. On the solutions page, Click on the "upload solution" button from the
SharePoint Online: How to Deploy a Design Package Solution (WSP) using PowerShell? SharePoint Online: How to Deploy a Design Package Solution (WSP) using PowerShell? Reviewed by Salaudeen Rajack on December 30, 2018 Rating: 5

How to Customize Search Navigation in SharePoint Online?

December 28, 2018    ,
Requirement:  Customize search drop down by adding a new search scope in SharePoint Online. How to Customize the Search Navigation in SharePoint Online? The default search drop-down has below options: Everything People Conversations This Site We need a new custom scope (drop down option) to the search drop down to be added. This document outlines How to add a link to search drop down to redirect to the custom search center. Prerequisites: Assuming the custom search center site is ready! SharePoint Online: Configure Search Navigation Here is how to add a link to search drop down - Step by Step: Login to the SharePoint Online site as a Site collection Administrator. Click on Settings gear and then select Site Settings link from the menu. In Site Settings Page, Click on "Search Settings" under Search group. In Search Settings page, scroll to “Configure Search Navigation” Section. Click on “Add Link” Hyperlink Enter the Title for new search scope
How to Customize Search Navigation in SharePoint Online? How to Customize Search Navigation in SharePoint Online? Reviewed by Salaudeen Rajack on December 28, 2018 Rating: 5

How to Add Help Desk Contact to Office 365 Help Menu?

December 14, 2018    ,
How to Add Your Help Desk Contact Information to Help Pane in Office 365? Adding your help desk contact information to the help pane in Office 365 - SharePoint Online helps users to quickly access your help desk. Here is how to add custom help desk info: Sign in to Office 365Admin Center as a Global Admin >> In the Office 365 admin center, Click on Settings >> Organization profile Click on Edit Button next to Provide customized help desk contact info Turn ON Help desk card Provide data for fields which you want to display on Card and Click on Save These changes reflect from next time users sign in. You'll find the custom help desk contact details in SharePoint Online, Exchange, etc.
How to Add Help Desk Contact to Office 365 Help Menu? How to Add Help Desk Contact to Office 365 Help Menu? Reviewed by Salaudeen Rajack on December 14, 2018 Rating: 5

SharePoint Online: PowerShell to Get External Sharing Settings

November 21, 2018    , , , ,
Requirement: Find all site collections with external sharing enabled (or disabled!) PowerShell to Get External Sharing Configuration in SharePoint Online: External sharing (or guest sharing) feature in SharePoint Online enables users to share documents and content outside the organization with people who are not members of your organization such as external vendors, customers, consultants, etc. SharePoint Online: PowerShell to List External Sharing While External sharing settings at tenant level can be configured using links provided in the bottom of this article, We can check external sharing settings for all site collections level using this PowerShell script in SharePoint Online Management Shell: #Config Variables $AdminSiteURL= "https://crescent-admin.sharepoint.com" #Connect to SharePoint Online services Connect-SPOService -url $AdminSiteURL -Credential (Get-Credential) #Get External Sharing Settings for all sites Get-SPOSite | Select-object url,sharingcapab
SharePoint Online: PowerShell to Get External Sharing Settings SharePoint Online: PowerShell to Get External Sharing Settings Reviewed by Salaudeen Rajack on November 21, 2018 Rating: 5

SharePoint Online: How to Disable Sharing for Non-Owners using PowerShell?

November 16, 2018    , , ,
Requirement: Disable Sharing for Non-Owners in SharePoint Online PowerShell to Disable Sharing for Non-Owners: #Config Variables $AdminSiteURL= "https://crescent-admin.sharepoint.com" $SiteURL= "https://crescent.sharepoint.com/sites/marketing" #Connect to SharePoint Online services Connect-SPOService -url $AdminSiteURL -Credential (Get-Credential) #Disable Sharing for Non-Owners Set-SPOSite -Identity $SiteURL -DisableSharingForNonOwners This disables share button for non-owners (members) for a given site collection. Found a problem though! when you run this script for the first time, it disables access request!! To disable share button in SharePoint Online, use: How to Disable Share Feature in SharePoint Online?
SharePoint Online: How to Disable Sharing for Non-Owners using PowerShell? SharePoint Online: How to Disable Sharing for Non-Owners using PowerShell? Reviewed by Salaudeen Rajack on November 16, 2018 Rating: 5

SharePoint Online: Disable Page Comments in Modern Sites using PowerShell

November 14, 2018    , ,
Requirement: Disable page comments in SharePoint Online Modern Sites and Communication sites. How to Disable Page Comments in SharePoint Online? Modern pages in SharePoint Online have a comments section at the bottom of each page for better collaboration. Option 1: Disable Comments at the tenant level Page comments can be turned-off at tenant level by the below settings: Navigate to SharePoint Online Admin Center: https://yourdomain-admin.sharepoint.com   Click on Settings from left navigation On the Settings page, Select "Disable Comments on Site Pages." Click OK to save your changes. Wait for a while, the comments section disabled from all pages in the tenant. Option 2: Disable Comments at the Page Level   Comments can be disabled at page level. Here is how: Navigate to the SharePoint Online Site page >>  Edit the page. Turn off the comments by toggle the switch from ON to OFF position and Publish the page. This disables comments section in t
SharePoint Online: Disable Page Comments in Modern Sites using PowerShell SharePoint Online: Disable Page Comments in Modern Sites using PowerShell Reviewed by Salaudeen Rajack on November 14, 2018 Rating: 5

SharePoint Online: Find All Large Files using PowerShell

November 12, 2018    , , ,
Requirement: Find all large files in SharePoint Online site collection. How to Find Large Files in SharePoint Online? To find large files in SharePoint Online, you can use "Storage Metrics" page. Navigate to your SharePoint Online site collection >> Click on Settings Gear >> Site Settings In Site Settings page, Click on "Storage Metrics" link under "Site Collection Administration" (https://crescent.sharepoint.com/_layouts/15/storman.aspx) The Storage Metrics page gives you the current Storage consumption of the site. You can navigate to each site/folder objects to get the storage stats of the particular object. You can also include the OOTB "File Size" column in your document library views to get the size of individual files! Explorer view also helps!! SharePoint Online: PowerShell to Get All Large Files in a Site Collection Getting large files by navigating into each folder from the above Storage metrics page is cumb
SharePoint Online: Find All Large Files using PowerShell SharePoint Online: Find All Large Files using PowerShell Reviewed by Salaudeen Rajack on November 12, 2018 Rating: 5

SharePoint Online: How to Apply Column Formatting?

November 09, 2018    ,
Column Formatting in SharePoint Online Column formatting in SharePoint Online modern lists and libraries customizes the field's appearance based on its value. In the past, We used SharePoint Designer and jQuery-CSS methods to format columns. But now in SharePoint Online we can apply formatting to columns with JSON. How to Apply Column Formatting in SharePoint Online List? Column formatting in SharePoint Online Choice, Yes/No, Date columns can be applied with few clicks without even JSON knowledge. Here is how we can use column formatting in SharePoint Online list: To apply formatting on a column in SharePoint Online list or library, Click on a column header, select Column settings from the menu, and then click Format this column .  The Format column panel will open. Click on "Edit Template" link Since this is a choice column, SharePoint displays a a list of all choices with a little color palette icon. Select colors for different choice values and click on app
SharePoint Online: How to Apply Column Formatting? SharePoint Online: How to Apply Column Formatting? Reviewed by Salaudeen Rajack on November 09, 2018 Rating: 5

SharePoint Online: Update Content Type using PowerShell

October 14, 2018    , , ,
Requirement: Update content type settings in SharePoint Online using PowerShell How to Update Content Type Settings in SharePoint Online? To editing content type's general settings such as name, description, and group information, follow these steps: Navigate to the SharePoint Online site where the content type was created. Click on Settings >> Site Settings On the Site Settings page, Click on "Site Content Types" link under "Web Designer Galleries" section. On the Site Content Types page, click the name of the content type to be edited. On the edit page, click the "Name,Description, and Group" link in the Settings section. On the Content Type Settings page, You can update the Name, Description, and Group information as necessary.  Click OK button to save your changes. SharePoint Online: Update Content Type using PowerShell Lets update content type name, description and group using PowerShell #Load SharePoint CSOM Assemblies Ad
SharePoint Online: Update Content Type using PowerShell SharePoint Online: Update Content Type using PowerShell Reviewed by Salaudeen Rajack on October 14, 2018 Rating: 5

SharePoint Online: PowerShell to Check If User Exists

October 04, 2018    , , ,
Requirement: SharePoint Online PowerShell to check if user exists There are different cases where you may need to check if a user exists in the Office 365 tenant and here is my PowerShell scripts: Option 1: Check If User Exists in the Tenant using Azure AD Cmdlet We can use the Get-MsolUser cmdlet of Azure AD to check if a given user account is valid. Import-Module MSOnline #User Account Variable $UserAccount = "Salaudeen@crescent.com" Try { #Get Credentials to connect $Cred = Get-Credential #Connect to Azure AD Connect-MsolService -Credential $Cred #Function to check if a user account exists in the tenant Function Check-UserExists() { Param( [Parameter(Mandatory=$true)] [string]$UserID ) $User = Get-Msoluser -UserPrincipalName $UserID -Erroraction SilentlyContinue if ($User -ne $null) { Return $True } else { Return $False } } #Call t
SharePoint Online: PowerShell to Check If User Exists SharePoint Online: PowerShell to Check If User Exists Reviewed by Salaudeen Rajack on October 04, 2018 Rating: 5

SharePoint Online: Get All Folders from List using PowerShell

September 19, 2018    , , , , ,
Requirement: Get All Folders from a SharePoint Online list using PowerShell PowerShell to Get All Folders in a SharePoint Online List Here is the CAML based approach to get all folders and sub-folders recursively from a list. #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 Variables $SiteURL = "https://crescent.sharepoint.com/sites/marketing" $ListName = "Documents" #Get Credentials to connect $Cred = Get-Credential Try { #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password) #Get the List $List = $Ctx.web.Lists.GetByTi
SharePoint Online: Get All Folders from List using PowerShell SharePoint Online: Get All Folders from List using PowerShell Reviewed by Salaudeen Rajack on September 19, 2018 Rating: 5

SharePoint Online: Delete Empty Folders using PowerShell

September 18, 2018    , , , ,
Requirement: Delete Empty Folders in SharePoint Online Document Library using PowerShell SharePoint Online: PowerShell to Remove Empty Folders This PowerShell script deletes all empty folders from a given SharePoint Online 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" Function Delete-SPOEmptyFolders([Microsoft.SharePoint.Client.Folder]$Folder) { #Get All Files and Sub-Folders from the Folder $Files = $Folder.Files $SubFolders = $Folder.Folders $Ctx.Load($Files) $Ctx.Load($SubFolders) $Ctx.ExecuteQuery() #Process Each Sub-Folders recursively ForEach($SubFolder in $SubFolders) { Delete-SPOEmptyFolders $SubFolder } #Delete Empty Folders I
SharePoint Online: Delete Empty Folders using PowerShell SharePoint Online: Delete Empty Folders using PowerShell Reviewed by Salaudeen Rajack on September 18, 2018 Rating: 5

SharePoint Online: Share Site and Invite External Users using PowerShell

September 18, 2018    , , , ,
Requirement: Share SharePoint Online Site with Multiple External Users using PowerShell. SharePoint Online: Share with External Users using PowerShell This PowerShell script invites external users to a SharePoint site and grants View permissions within the site. A custom e-mail message also included in invitation email. #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 Variables $SiteURL = "https://crescent.sharepoint.com/sites/marketing" $Users = "Mark.Ellis@gmail.com","Sayeed.Alhajiri@gmail.com" #Get Credentials to connect $Cred = Get-Credential Try { #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = New-Ob
SharePoint Online: Share Site and Invite External Users using PowerShell SharePoint Online: Share Site and Invite External Users using PowerShell Reviewed by Salaudeen Rajack on September 18, 2018 Rating: 5

SharePoint Online: Create Site Collection from Custom Template

September 16, 2018    , , ,
Requirement: Create Site Collection with Custom Template in SharePoint Online SharePoint Online: Create Site Collection from Custom Template Creating subsites from a custom template is quite straightforward as in my another post: SharePoint Online: Create Subsite from Template using PowerShell . But if you want to create a site collection based on a custom site template, You have to follow below steps: Assuming you have saved a site as template and the Site Template WSP file is ready, here are the steps to create site collection with custom template in SharePoint Online: Step 1: Create New Site Collection without Specifying Site Template Let's create a new site collection with "Select a Template Later" option. Go to your SharePoint Online Admin Center >> Click on "Site Collections" link from left navigation. In the toolbar, Click on "New" >> Private site collection. Provide the URL and other parameters to create the Site Collecti
SharePoint Online: Create Site Collection from Custom Template SharePoint Online: Create Site Collection from Custom Template Reviewed by Salaudeen Rajack on September 16, 2018 Rating: 5

Get SharePoint Online Tenant Settings using PowerShell

September 16, 2018    , , ,
Requirement: Get tenant settings in SharePoint Online PowerShell to Retrieve Tenant Setting in SharePoint Online: Use Get-SPOTenant cmdlet to get all configuration settings of the tenant. #Set SharePoint Online Admin Center URL $AdminSiteURL="https://crescent-admin.sharepoint.com" #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL -Credential (Get-Credential) #Get Tenant Settings Get-SPOTenant This cmdlet gets all settings of the tenant Get SharePoint Online Tenant Settings using PowerShell: #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" Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.Online.ShareP
Get SharePoint Online Tenant Settings using PowerShell Get SharePoint Online Tenant Settings using PowerShell Reviewed by Salaudeen Rajack on September 16, 2018 Rating: 5

SharePoint Online: Compare Features Between Sites using PowerShell

September 16, 2018    , , ,
Have you even wanted to compare features activated between SharePoint Site collections or sites? Well, this nifty PowerShell script does that exactly! PowerShell to Compare Features Between SharePoint Online Sites or Site Collections #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" Function Compare-SPOFeatures { [cmdletbinding()] Param( [Parameter(Mandatory=$True)][URI]$SourceSiteURL, [Parameter(Mandatory=$True)][URI]$TargetSiteURL, [Parameter(Mandatory=$True)][ValidateSet('Site','Web')][String]$Scope ) #Get Credentials to connect $Cred = Get-Credential #Get Source and Target Site Contexts $SourceCtx = New-Object Microsoft.SharePoint.Client.ClientCon
SharePoint Online: Compare Features Between Sites using PowerShell SharePoint Online: Compare Features Between Sites using PowerShell Reviewed by Salaudeen Rajack on September 16, 2018 Rating: 5

SharePoint Online: Enable SharePoint Designer using PowerShell

September 16, 2018    , , ,
Requirement: Enable SharePoint Designer for a SharePoint Online site. SharePoint Online: How to Enable SharePoint Designer? By default, SharePoint designer customizations are disabled for modern group sites in SharePoint Online. It gives an error message "The server could not complete your request." when you try to open a SharePoint Online group site in SharePoint Designer. Also, It gives "You do not have permission to open this web site in SharePoint Designer" error message: How to Enable SharePoint Designer in SharePoint Online? To enable SharePoint Designer, follow these steps: Sign in to Office 365 and go to the SharePoint Online Admin Center. Click on Settings from the left navigation >> Scroll down to "Custom Script" section Under Custom Script section, Set "Allow users to run custom script on personal site" and "Allow users to run custom script on self-service created sites" options.  Click on "OK&
SharePoint Online: Enable SharePoint Designer using PowerShell SharePoint Online: Enable SharePoint Designer using PowerShell Reviewed by Salaudeen Rajack on September 16, 2018 Rating: 5

Co-Authoring Feature in SharePoint Online

September 15, 2018    
Overview of Co-authoring in SharePoint Online What is Co-Authoring in SharePoint Online? Well, Co-Authoring feature in SharePoint Online and OneDrive allows multiple users to edit documents and collaborate concurrently in real time. By default, documents in SharePoint Online document libraries are enabled with co-authoring. When multiple users edit one document (Word, Excel, PowerPoint, etc.) simultaneously other user's changes will be reflecting to everyone! In simple words, when everyone is working at the same time, that's called co-authoring. Prerequisites: Co-authoring feature doesn't work when you enable “Require check out” option or when you explicitly check out a document! It works on Office Online and in locally installed client applications with modern Office documents (.docx (Word), .pptx (PowerPoint), and .xlsx (Excel).) Also, all co-authors must have edit permissions and connected online. How to Co-Author Office Documents in SharePoint Online? Co-authorin
Co-Authoring Feature in SharePoint Online Co-Authoring Feature in SharePoint Online Reviewed by Salaudeen Rajack on September 15, 2018 Rating: 5

SharePoint Online: Unique Permissions Report using PowerShell

September 14, 2018    , , , , ,
Requirement: Get unique permissions report in SharePoint Online using PowerShell PowerShell for SharePoint Online Unique Permissions Report Here is the SharePoint Online PowerShell to get unique permissions: #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" #To call a non-generic Load Method Function Invoke-LoadMethod() { Param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide a Client Object"), [string]$PropertyName ) $Ctx = $Object.Context $Load = [Microsoft.SharePoint.Client.ClientContext].GetMethod("Load") $Type = $Object.GetType() $ClientLoad = $Load.MakeGenericMethod($Type) $Parameter = [System.Linq.Expressions.Expressio
SharePoint Online: Unique Permissions Report using PowerShell SharePoint Online: Unique Permissions Report using PowerShell Reviewed by Salaudeen Rajack on September 14, 2018 Rating: 5

SharePoint Online: Set List Item Permissions using SharePoint Designer Workflow and REST API

September 10, 2018    , , ,
Business Requirement: In "Project Documents" SharePoint Online document library, Project related documents are getting uploaded by the project team. This library has "Permissions" drop-down column (metadata) with values "Restricted" and "Non-Restricted". If the Permission is restricted, we need to break the permissions of the document, remove all users and groups from it and add "Project Teams" SharePoint group to it. If its "Non-Restricted", then the document should inherit permissions from its parent library. Challenge: Unfortunately, we don't have any permissions related workflow actions available in SharePoint designer workflows! We don't have any 3rd party workflow products available in the tenant (Nintex is my choice!) Solution: Use SharePoint Designer Workflow "Call HTTP Web Service" action and REST APIs to set up permissions on the document. Prerequisite: Please note, You must activate "
SharePoint Online: Set List Item Permissions using SharePoint Designer Workflow and REST API SharePoint Online: Set List Item Permissions using SharePoint Designer Workflow and REST API Reviewed by Salaudeen Rajack on September 10, 2018 Rating: 5

SharePoint Online: Site Collection Permissions Report using PowerShell

September 06, 2018    , , , ,
Requirement: Generate permissions report for a SharePoint Online site collection. SharePoint Online: Site Collection Permissions Report using PowerShell Have you ever wanted to get SharePoint Online Site and subsites permissions using PowerShell? Well, This PowerShell script generates permission report on all objects which has unique permissions on the given site collection. It scans through following securables: Site collection administrators group Given site collection and sub-sites with unique permissions All lists and libraries with unique permissions All list items (and folders) with unique permissions. Here is the SharePoint Online PowerShell to get site permissions report: #sharepoint online powershell permissions report 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.Sha
SharePoint Online: Site Collection Permissions Report using PowerShell SharePoint Online: Site Collection Permissions Report using PowerShell Reviewed by Salaudeen Rajack on September 06, 2018 Rating: 5
Powered by Blogger.