Check if a Service Application is Running in SharePoint using PowerShell

If you are a SharePoint administrator, then there may be times when you need to check if a service application is running. In my case, A couple of times, I had to get the service application’s status before performing activities such as: Stop and Starting the service, monitoring the service application’s availability,…

Read more

Move SharePoint Web Application’s IIS Physical Path to a New Location

Requirement: Move SharePoint web application’s IIS physical location from system drive (c:\) to application drive (d:\) due to new server support policies! Solution: SharePoint web applications, by default placed under: “C:\inetpub\wwwroot\wss\VirtualDirectories” when we create them. There is no UI/direct way to change the physical location of SharePoint IIS web sites later. However,…

Read more

How to Add Date Time Field to SharePoint List using PowerShell?

Requirement: Add Date and Time Column to SharePoint list using PowerShell. PowerShell Script to add Date and Time Column to SharePoint list: If you need to add a date-time field to a SharePoint list, you can do so easily using PowerShell. In this guide, we will walk you through the steps of…

Read more

Send HTML Format E-Mails with Send-MailMessage in PowerShell

Requirement: Send E-mail from PowerShell script with HTML formatted body. How to use Send-MailMessage with HTML body? Do you need to send an HTML formatted email from PowerShell? If so, you can use the Send-MailMessge cmdlet with the -BodyAsHtml parameter. I will show you how to use the Send-MailMessage cmdlet to send…

Read more

Fix “The form cannot be rendered. This may be due to a Misconfiguration of the Microsoft SharePoint Server state service” Error in SharePoint 2013

Problem: InfoPath form-based list form in a migrated SharePoint 2013 environment from SharePoint 2010 gave this error message: “The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server state service.” Solution: Create a State Service Application as in How to Create State Service Application in…

Read more

Set Default Value for Hyperlink or Picture Column in SharePoint

Requirement: Set Default value for Hyperlink or Picture Column in SharePoint List There is no provision for specifying default value in Hyperlink or Picture type columns in SharePoint! In some scenarios, we may want to specify SharePoint 2010/2013 hyperlink column default value. But there is no option in SharePoint web UI to…

Read more

How to Remove Hyperlink from Lookup Columns in SharePoint?

Problem:When we add a lookup column to any SharePoint list, it appears with the link to the parent item in SharePoint list views. The end-user often clicks on the lookup link and mistakenly edits the parent lookup item! People get confused about which link to click. So, we wanted to remove hyperlinks…

Read more