Add New Column To SharePoint List

To create a new column in SharePoint list, please follow the below steps

Go to your list/Document library , in the ribbon click on List

Go to your list/Document library , in the ribbon click on List

Click on List Settings

Click on List Settings

Under Columns section, click Create column

Under Columns section, click Create column

Write the column name and choose the type, then click OK

Write the column name and choose the type, then click OK

Change Project Server 2013(EPM) Security Mode

In Project Server 2013 (EPM 2013) there are two security modes:

  • SharePoint Mode (Default)
  • Project Server Mode

In Project Server Mode, there are more customization security groups and other functionality that is distinct from SharePoint groups.

to switch between those modes, user SharePoint 2013 PowerShell console and run the below commands:

  • SharePoint Mode
Set-SPPRojectPermissionMode -Url http://WebApplication/pwa -AdministratorAccount Domain\serviceAccountName -Mode SharePoint
  • Project Server Mode
Set-SPPRojectPermissionMode -Url http://WebApplication/pwa -AdministratorAccount Domain\serviceAccountName -Mode ProjectServer

after using Project server mode, the security will look like below image:




PlatformNotSupportException When Using VS 2012 With SharePoint 2013

While I writing a small console to insert items in SharePoint 2013 task list, I got the follwoing error:

Microsoft SharePoint is not supported in 32-bit process. Please verify that you are running in a 64-bit executable.

An her the screen shot of the exception:



Right click on the project in Solution Explorer and click on Properties


Then go to Build tab and do the following:

  • Platform target >> Any CPU
  • Clear the check box on “Prefer 32-bit


Upload files using Windows Explorer instead Not Available – SharePoint 2013

When you try to upload multiple documents to document library in SharePoint 2013 you may notice that the option “Upload files using Windows Explorer instead” to upload multiple document is not available or hidden.


There is many reasons behind this, one of them is you are opening the document library Internet Explorer 64-bit.


Just open it in Internet Explorer 32-bit.




Get Document Path (ServerRelativeUrl) in SharePoint 2013 using REST API

Suppose we have a document in document library in SharePoint 2013 inside sub folders

Ex: /En/Documents/Folder1/Folder2/stats.png

Now, using REST API we need to get the Server Relative Url (ServerRelativeUrl) by the document ID.


The REST API url will be: http://<server name>/<sub site>/_api/web/lists/getbytitle(‘Documents’)/items(‘<Document ID>’)/File

In my case it will be : http:// <server name>/En/_api/web/lists/getbytitle(‘Documents’)/items(‘5‘)/File


Hiding SYNC from SharePoint 2013

If you need to remove the SYNC option in SharePoint 2013

Go to Settings under Site Collection level and go to Search section


Under “Offline Client Availability” choose NO