SharePoint Diary

How to convert Word documents to PDF by a SharePoint workflow using HarePoint Workflow Extensions?

July 30, 2015 Product Review, SharePoint

Introduction One of the main purposes of SharePoint is collaboration: a group of people can conveniently work with shared documents, making teamwork especially efficient. Usually, text documents are created and edited using Microsoft Word, but when the work is complete, it is convenient to conve…

Product Review: Virto SharePoint Calendar Web Part

July 28, 2015 Product Review, SharePoint

Introduction: Virto SharePoint Calendar Web Part enables users to view all of their events from multiple data sources such as SharePoint Lists, Exchange Calendar, Google Calendar, SalesForce Calendar, SQL Tables or XML and have different views for your easy navigation and reference in one…

SharePoint People Search Results gives "Domain\Account" Instead of User Display Name

July 28, 2015 Search, SharePoint, User Profile

Problem: SharePoint 2010 people search gives "Domain\AccountID" instead of Display name of the user! Solution: SharePoint uses "Preferred Name" property which is mapped with "Display Name" property from AD in People search results. Here, I found the root cause o…

Find All Lists which Exceeds List View Lookup Threashold in SharePoint

July 28, 2015 Admin Reports, CSV, PowerShell, SharePoint

Requirement: Resource throttling feature in SharePoint controls resource usage on SharePoint Farm for optimum usage. My requirement was to find all lists which are exceeding configured list view lookup threashold limit in SharePoint. PowerShell script to find All Lists which are Exceeding List…

Mount-Dismount (Attach-Detach) Content Databases in SharePoint using PowerShell

July 27, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Database

There are occasions when you may need to attach or detach a content database to SharePoint web applications. E.g. during migrations you want to restore a content database from another farm and would like to access the sites in the content database from a new web application.You can attach or deta…

How to Get All Lists in SharePoint Site using PowerShell?

July 26, 2015 List, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Get all lists in SharePoint site using PowerShell: To get all SharePoint lists by using PowerShell, use this script: Add-PSSnapin microsoft.sharepoint.powershell -ErrorAction SilentlyContinue #Configuration Variables for Web URL $WebURL ="https://sharepoint.company.com/" #Get the si…

How to Show Status Message in SharePoint 2013?

July 26, 2015 Client Side Object Model (CSOM), Javascript, JSOM, SharePoint, SharePoint 2013, SharePoint 2016

Requirement: After the launch of new SharePoint intranet portal, we wanted to display a status message in each page. Solution: Here is the script to display status message using SharePoint Javascript client side object model. <script type="text/javascript"> ExecuteOrDelayUnti…

Change Subsite Logo to Link Root Site in SharePoint 2013 / 2016 using jQuery

July 24, 2015 Branding, jQuery, SharePoint, SharePoint 2013, SharePoint 2016, Subsite

Requirement: Change Subsite logo to link root site in SharePoint 2013 / SharePoint 2016 Solution: By default, Subsite logo links points to its homepage. We can change site logo link in SharePoint 2013 using jQuery to point to root site. Change SharePoint 2013 logo link to root site: Add a…

SharePoint Online: Update List Items using PowerShell

July 23, 2015 Client Side Object Model (CSOM), List, Office 365, PnP PowerShell, PowerShell, SharePoint Online

Requirement: SharePoint Online PowerShell to Edit List Item PowerShell CSOM Script to update List Items in SharePoint Online: Here is the example for SharePoint Online PowerShell to update list item. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft…

Apply Theme in SharePoint 2013 using PowerShell

July 17, 2015 Branding, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Themes are the quick and easiest way to apply branding to SharePoint sites. In SharePoint 2013 Themes got changed and redesigned as "Composed Look" feature. As it sounds "Composed" look, it simply defines theming by combining design elements: Master page - AKA site layout, …

Configuring Visio Graphics Service Application in SharePoint 2013 using PowerShell

July 17, 2015 PowerShell, Service Application, SharePoint 2013, SharePoint 2016

Visio diagrams are wonderful way to express ideas, simplify complex topologies, illustrate the process flow, etc. With Visio Services in SharePoint 2013, you can publish Visio diagrams in SharePoint so that they can be Shared and viewed online without installing Visio application in client comput…

Configure Audit Settings for SharePoint 2013 Sites using PowerShell

July 16, 2015 Audit, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016

Audit log feature in SharePoint helps us to analyze how SharePoint contents are being used by users or to track documents and users in accordance to compliance requirements. SharePoint 2013 audit log configuration is explained in my another post: Configuring Audit Logs Feature in SharePoint 2013…

Disable Alerts on SharePoint 2013 List using PowerShell

July 15, 2015 Alerts, PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

Requirement: Temporarily disable Alert Emails on a SharePoint list. Solution: SharePoint Alert objects have "Status" property which can be turned ON or OFF. As there is no UI to disable or enable alerts in SharePoint directly from the browser, we can do it programmatically with Po…

Restore Deleted Items from Recycle Bin in SharePoint Using PowerShell

July 10, 2015 PowerShell, Recycle Bin, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

How to restore deleted items from SharePoint recycle bin? To restore deleted items, Click on "Recycle Bin" link on the Quick Launch. Locate the object that you want to restore by Selecting the check box next to the object and then click Restore Selection. SharePoint: Restore fr…

Delete SharePoint User Profile using PowerShell

July 03, 2015 PowerShell, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, User Profile

Generally SharePoint user profiles will get deleted when any of the below incident happens: User account is deleted in Active Directory Account is disabled User Profile Service Application Connection is changed or recreated Account is recreated in AD or moved out of an OU which is not part o…

Move Site Collection to Another Content Database using PowerShell

July 02, 2015 Content Database, PowerShell, SharePoint, SharePoint 2013, SharePoint 2016, Site Collection

Requirement: Found a SharePoint Site collection growing in size over a period of time and wanted to move the SharePoint 2013 site collection to another content database. Solution: Use the PowerShell Cmdlet Move-SPSite to move site collection from one content database to another. Here is how:…

How to Use JSLink with List View Web Part in SharePoint 2013?

July 02, 2015 Client Side Rendering (CSR), SharePoint, SharePoint 2013

What is JsLink in SharePoint 2013: JSLink is a new method of combining JavaScript, CSS and HTML elements together to customize the look and feel of SharePoint Fields, List Items, List views, List forms and web parts. How to use JSLink in SharePoint 2013? Here is the SharePoint 2013-jslink …

Upload Files to SharePoint Library Remotely using Client Object Model (CSOM) and PowerShell

July 01, 2015 Client Side Object Model (CSOM), PowerShell, SharePoint, SharePoint Online

Requirement: Upload files to SharePoint document library remotely. PowerShell Script to Upload a File to SharePoint Library using Client Object Model: We can upload files to SharePoint Online or SharePoint on-premises document libraries remotely using PowerShell and client side object model …

Disclaimer