SharePoint Online: Update Created By / Modified By, Created At / Modified At Field Values using PowerShell

Requirement: Update 'Created By' column in SharePoint Online using PowerShell At times, you may have to create list items or set existing item's metadata fields such as Created by, Modified by, Created at, Modified values to a specific user - time stamp. Say, You are importing or m…

SharePoint Online: PowerShell to Send Email

We can send emails from SharePoint online, either with SPUtility's SendEmail function or with PowerShell cmdlet Send-MailMessage . Here are examples in both the cases: PowerShell to Send Email in SharePoint Online: Here is how to send an E-mail from SharePoint Online using PowerShell Clien…

Copy Group Membership Permissions of a User in SharePoint using PowerShell

Requirement: Copy SharePoint Group Memberships of one user to another user Solution: You can copy group memberships of one user to another user to have identical SharePoint Permissions for a SharePoint Site. Here is the PowerShell Script: PowerShell Script to copy Group Memberships from On…

SharePoint Online: How to Change Site Logo using PowerShell?

Requirement: Change Logo in SharePoint Online site. How to change Logo in SharePoint Online? Changing the logo is a common requirement when it comes to branding SharePoint Online sites and it can be achieved in few clicks. To add a logo to SharePoint Online, follow these steps: Log in as a …

SharePoint Online: Add Currency Column to List using PowerShell

Requirement: Add Currency Column to SharePoint Online List How to Create Currency Field in SharePoint Online List? Similar to Number field, The Currency column in SharePoint Online is used to capture currency values as metadata and adds currency formatting options. Browse to your SharePoin…

SharePoint Online: How to a Get List in PowerShell?

Requirement: SharePoint Online PowerShell to Get List SharePoint Online: Get List from PowerShell Here is the PowerShell to Get SharePoint Online List #sharepoint online get list powershell Import-Module Microsoft.Online.SharePoint.Powershell -DisableNameChecking #Config Variables for Site…

Import-Module: The specified module 'Microsoft.Online.SharePoint.Powershell' was not loaded because no valid module file was found in any module directory.

Problem: When trying to add PowerShell module for SharePoint online, using " Import-Module Microsoft.Online.SharePoint.PowerShell", it resulted in below error in both PowerShell console and in PowerShell ISE. "Import-Module : The specified module 'Microsoft.Online.SharePoint…

SharePoint Online: Create Permission Level using PowerShell

Requirement:  Create a new permission level in SharePoint online site collection for contribute without delete permissions. SharePoint Online Permission Levels: SharePoint Permission levels are set of actions user can perform in SharePoint, packaged as a group to make permission management ea…

SharePoint Online: PowerShell to Create a Document Library

Requirement: Create a Document Library in SharePoint Online using PowerShell. Create Document Library using PowerShell in SharePoint Online: The document library is the most commonly used type of library in SharePoint Online used to store and collaborate Office documents such as Word, Excel, P…

SharePoint Online: Import Terms to Term Set from CSV using PowerShell

Requirement: Import terms to a term set in SharePoint Online from a CSV file using PowerShell. How to Import Terms to a Term Set in SharePoint Online? Here is my CSV file with a list of Terms for a Term set called "Job Title" and we can use PowerShell to bulk create terms to a term …

Fix for "Cannot Connect to Database Master at SQL Server at Server Name. The Database might not exist, or the current user does not have permission to connect to it" SharePoint Error

Problem: When trying to create a new SharePoint farm using PowerShell, the SharePoint 2016 management Shell gave an error message: New-SPConfigurationDatabase : Cannot connect to database master at SQL server at <SQL-Server-Alias>. The database might not exist, or the current user does …

How to Create New Target Application ID in Secure Store Service for BCS in SharePoint 2016?

When you want to consume external data in SharePoint, such as data from your other business applications, you can use Business Connectivity Services (BCS) together with Secure Store Service. The external data source that you can connect to is called a Secure Store Target Application. BCS makes…

SharePoint Online: How to Hide a List or Library using PowerShell?

Requirement : Hide a list or library from SharePoint Online site. SharePoint Online: Hide Document Library using PowerShell For a custom application, we wanted to hide the config list in SharePoint Online, to prevent edit or deletions. How to hide a list in SharePoint Online? There are many …

SharePoint Online: Bulk Add Terms, Term Sets and Term Groups from CSV using PowerShell

Requirement: Bulk Add Terms, Term Sets and Term Groups from a CSV File into SharePoint Online term store. Here is the format and data to import: PowerShell Script to Bulk Add Terms, Term Sets and Groups to SharePoint Online Term Store: ##Load SharePoint CSOM Assemblies Add-Type -Path "…

SharePoint Online: Create Term in Term Store using Powershell

Requirement: Create a Term in SharePoint Online Term Store. How to Create a Term in SharePoint Online Term Store? Term store in SharePoint Online enables you to categorize and standardize data. You can define categories and tag your data for classification. To create a new term in SharePoint o…