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

November 30, 2016    , , ,
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    , , , ,
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    , , , , , ,
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    , , , , ,
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

November 26, 2016    , , ,
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…

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    , , ,
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    , , , ,
Requirement:  Create a new permission level in SharePoint online site collection for contribute without delete permissions. SharePoint Online Permission Levels: SharePoint Permission levels are a set of actions users can perform in SharePoint, packaged as a group to make permission management…

SharePoint Online: PowerShell to Create a Document Library

November 20, 2016    , , , ,
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…

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    , , , , ,
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    , , , ,
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    , , , , , , , ,
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

November 07, 2016    , , , , ,
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    , , , , ,
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…

Powered by Blogger.