SharePoint Diary

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

November 30, 2016 Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online

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

November 29, 2016 Client Side Object Model (CSOM), Office 365, PowerShell, SharePoint Online

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

November 27, 2016 Permission, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, Users and Groups

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?

November 27, 2016 Branding, Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online, Tenant

Changing logo is a common requirement when it comes to branding SharePoint online sites. How to change Logo in SharePoint Online: Changing logo in SharePoint online is a matter of few clicks. To add logo to SharePoint online, follow these steps Log in as a Site Administrator to your SharePoi…

SharePoint Online: Add Currency Column to List using PowerShell

November 26, 2016 Client Side Object Model (CSOM), PnP PowerShell, PowerShell, SharePoint Online

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?

November 26, 2016 Client Side Object Model (CSOM), List, PowerShell, SharePoint Online

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.

November 26, 2016 Errors, Known Issues, PowerShell, SharePoint Online

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

November 22, 2016 Client Side Object Model (CSOM), Permission, PnP PowerShell, PowerShell, SharePoint Online

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

November 20, 2016 Client Side Object Model (CSOM), Document Library, PnP PowerShell, PowerShell, SharePoint Online

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

November 16, 2016 CSV, Managed Metadata, PowerShell, SharePoint Online, Term Store

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

November 15, 2016 Errors, Installation, SharePoint 2013, SharePoint 2016, SharePoint Products Configuration Wizard, SQL Server

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?

November 08, 2016 BCS, Security, SharePoint, SharePoint 2013, 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?

November 08, 2016 Client Side Object Model (CSOM), Library, List, Office 365, PnP PowerShell, PowerShell, SharePoint Designer 2013, SharePoint Online

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. There are many ways to hide a SharePoint online list. He…

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

November 07, 2016 Client Side Object Model (CSOM), CSV, Managed Metadata, PowerShell, SharePoint Online, Term Store

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

November 06, 2016 Client Side Object Model (CSOM), Managed Metadata, PnP PowerShell, PowerShell, SharePoint Online, Term Store

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…

Disclaimer