Check if Service Application is Running in SharePoint using PowerShell

Couple of times, I had to get the service application’s status prior performing activities such as: Stop and Start the service, Monitoring service application’s availability, etc. Here is how we can check if the service application is running / created using PowerShell. PowerShell script to check service application’s status: This script gives…

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 time Column to SharePoint list: This Adds a new field. Set Date Time Column Settings using PowerShell: While the above code adds a new field to a given list, there are additional settings on the column…

Read more

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

Requirement: Send E-mail from PowerShell script with HTML formatted body. Solution: Here is an example for sending E-mail as HTML from PowerShell script with Send-MailMessge cmdlet: and the output: Instead of directly embedding the HTML into the script, you can also store it in an external file and retrieve the HTML format/template…

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…

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

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. Quite often, the end-user clicks on the lookup link and edits the parent lookup item by mistake – People get confused about which link to click. So we wanted…

Read more