Monday, August 24, 2015

SharePoint Server 2016 IT preview released

Recently Microsoft released SharePoint Server 2016 IT preview, you can check out some more information in this office blog post.

Apart from this Microsoft also released the new cloud hybrid search preview for SharePoint Server 2013 and 2016.

You can download SharePoint Server 2016 Preview from this link.

Before downloading check out the full hardware and software requirement of SharePoint Server 2016 IT preview here.
Few new features are there in the SharePoint Server 2016 preview like:
- Look and Feel
- Mobile usage improvements
- New APp LAuncher
- Simple Share Option (Easily Share your site with users)
- Large file support etc
Check out more on: SharePoint Server 2016 new features

Some of the features are also removed or deprecated, check out this article for more information on SharePoint Server 2016 features deprecated or removed,

Wednesday, July 1, 2015

The folder name is not valid error while opening SharePoint Online Site in SharePoint Designer 2013

Recently while opening SharePoint online Office 365 site using SharePoint designer, I got the error that is saying: The folder name is not valid. See the fig below:

Also read: Create SharePoint 2013 Online Search Result Sources and attach to Search Result page

In SharePoint 2013 designer I was giving the URL of the online site in the open site dialog box like:

I removed the /SitePages/Home.aspx from the URL and it works fine. The URL will look like:

Hope this will be helpful.

Thursday, June 25, 2015

SharePoint 2013 Quick Edit in List and Disable quick edit in SharePoint 2013 List

In SharePoint 2013 here is a good option to edit SharePoint 2013 list item through quick edit item option. To use this Open your SharePoint 2013 list and then from the Ribbon click on LIST tab and then Quick Edit button as shown in the fig below:

When you click on Quick Edit button, it will display in the Edit mode or Datasheet mode for editing List Items. It will display as below:

Disable Quick Edit in SharePoint 2013 List:
To disable quick edit in SharePoint 2013 list, Open the list using browser and then click on List Settings from the Ribbon. From the General Settings click on Advanced settings.

Then in the List Settings page, go to the Quick Edit section select No like below:

Now if you open the list, then you will be able to see the quick edit button is disabled.

Wednesday, June 17, 2015

Add links to top link bar in SharePoint 2013

Here we will see how we can add links in top link bar in SharePoint 2013. There are two ways to do that, one is to directly we can add links in the home page as well as you can add link to top link bat from the Site Setting page.

You may also read:
- Manage Site Content and Structure in SharePoint 2013

- SharePoint 2013 workflow platform

- Custom Actions Add custom buttons to SharePoint list ribbon using SharePoint Designer 2013

First Approach:
Open your SharePoint 2013 site, then in the top link bar click on EDIT LINKS as shown in the fig below:

You can drag and drop any link to the top link bar where it has written "Drag and drop link here". Suppose I want to give a link item ico then I can drag and drop like below:

Then click on Save, it will save the link.

Else you can click on +link icon as shown in the fig below:

This will open the Add a link dialog box and there put the details linke below:

Once you Save, it will appear like below:

Second Approach:
Open your Site, then from the Settings icon click on Site Settings. Then in the Site Settings page, click on Navigation under Look and Feel section.

Then in the Navigation settings page go to the Structural Navigation: Editing and Sorting section and then select the Global Navigation and then click on Add Link as shown in the fig below:

Then in the Navigation Link dialog box, click on Title and URL as shown in the fig below:

Then click on OK and then Ok to close the Navigation Settings page. Then the link will appear like below:

Friday, June 12, 2015

Manage Site Content and Structure in SharePoint 2013

In this post we will discuss about Manage Site Content and Structure in SharePoint 2013. You may also like to:
- Calculate date from date picker inside InfoPath forms in SharePoint 2013

- Redirect to different page after submitting an item to SharePoint 2013 list

- Enterprise Metadata and Keywords Settings in SharePoint 2013

In SharePoint 2010, the Manage Site Content and Structure appears under Site Actions menu as shown in the fig below:

But in SharePoint 2013 it comes under Settings -> Site Settings.

Then under Site Administration, you will be able to see "Content and structure" as shown in the fig below:

By default if you will not be able to see the link in team sites then activate the following features:

First activate "Office SharePoint Server Publishing Infrastructure" Site collection features.

And then "Office SharePoint Server Publishing" site feature.

Or you can also access the page by using the below URL:


Monday, June 8, 2015

Change Site Logo using PowerShell and Server Side Code in SharePoint 2013

We can change the site logo using PowerShell in SharePoint 2013. Before running the PowerShell command make sure you saved your site logo in any of the document library like SiteAssets.

You may read:
- Configure Following settings in SharePoint 2013

- Calculate difference between two dates Excluding Weekend and Holiday date in SharePoint 2010

- Cancel not completed workflows using PowerShell in SharePoint 2013

Below is the PowerShell command to change the Site Logo:

Add-PSSnapin Microsoft.Sharepoint.Powershell

$web = Get-SPWeb http://SharePointSiteURL

$web.SiteLogoUrl = "/SiteAssets/MyCompanyLogo.png"

$web.SiteLogoDescription = "My Company Logo"



Server Side Code to Change Logo:
Below is the SharePoint server side code to change Logo.

using (var site = new SPSite("http://SharePointSiteURL"))
using (var web = site.OpenWeb())
web.SiteLogoUrl = "/SiteAssets/MyCompanyLogo.png";

web.SiteLogoDescription = "My Company Logo";


Monday, June 1, 2015

Prevent Site from Search Results in SharePoint 2013

In this post we will discuss how to prevent a site to appear in search results in SharePoint 2013. We will see an out of box approach for this.

You may read: Get all items selected using JavaScript in SharePoint 2013 or SharePoint Online, Request approval failed when approving pending request in SharePoint 2013 and Keyword Query Language (KQL) enhancement in SharePoint 2013.

Open the site which you want to prevent to appear in the search result. Then click on the Settings icon. Then click on Site Settings.

This will open the Site Settings page.

Then click on Search and offline availability in the Search section like below:

This will open the Search and Offline Availability page. There click No in the Indexing Site Content section, Then click on OK.

Once you click on OK, it will not appear in the search result, as well as the content from its subsites will not appear in the search result.

Tuesday, May 12, 2015

Change master page in SharePoint 2013

Here we will discuss how we can change master page in SharePoint 2013. SharePoint 2013 has two new default master page: seattle.master and oslo.master. The difference between seattle.master and oslo.master is that if you use oslo.master, the top navigation pane is replaced with the left navigation pane, and the side bar on the left disappears. Meaning that normally in the left navigation Home, Documents, Recent, Site Contents links usually appears. When you apply oslo.master these links will appear in the top navigation pane. And there will be no links in the left side bar.

Also read similar articles:
- Create custom page layout in SharePoint 2013

- Steps to create master page using design manager in SharePoint 2013

- Show flash message and notification in SharePoint page in SharePoint 2013

The default master page in SharePoint 2013 is called seattle.master. But if you want to change you can do this from the browser itself.

Open SharePoint site, go to Site Settings.

From the Look and Feel, click on Master page. This will open the Site Master Page Settings page.

In this page, There are two sections one for Site Master Page and another ont for System Master Page. From the dropdown select the master page, which you want to use and then click on OK. The changes will be reflected.

Saturday, April 11, 2015

Change Office 365 Logo in SharePoint Online Suite Bar

Here we will discuss further how to change office 365 logo in SharePoint Online suite bar.

Open your SharePoint designer and Select the default master page. Right click and open in advanced mode. The default master page is seattle.master.

You may like to read:
- Rest API Create folder inside document library in SharePoint 2013 and Delete folder from Document library using Rest API

- What's new in Developer dashboard in SharePoint 2013?

- OAuth in SharePoint 2013

Before going further make sure you have uploaded your Logo to SiteAssets or any library and copy the path of the image.

Then search for </body>

And then paste the below code after that.

<SharePoint:ScriptBlock runat="server">
if (typeof jQuery == 'undefined')
document.write('<script type="text/javascript" src="//"><' + '/script>');
 var interval = setInterval(function(){
$('#O365_MainLink_Logo').html("<a href='/'><img src='/SiteAssets/YourLogo.PNG' height='25px'></a>");
$('#O365_MainLink_Logo').attr("style","padding-top: 3px");
}, 1000);  

Then Save the master page and then checkin the page. Now when you will refresh your Office 365 site the new logo will appear.

Saturday, March 28, 2015

Calculate date from date picker inside InfoPath forms in SharePoint 2013

In this post we will discuss how to calculate date from a date picker inside a InfoPath forms in SharePoint 2013.

Recently I got a requirement to calculate some date based on a dropdown selected value. Like I have a dropdownlist which contains value like Yearly, half yearly, quarterly, months, week like that. And there is a date picker where user can select a date. If a user select a date from the date picker and then s/he select yearly from the dropdown then anther text should be populate with adding a year. So if user select 28-03-2015 then it should autopopulat 28-03-2016. Like that it should do for quarterly, monthly etc.

You may like to see:
- Format Date in InfoPath form in SharePoint 2013

- Alternative way to promote people picker in infopath form library in SharePoint 2013

- Deploy infopath form using PowerShell or STSADM command

We did not got any proper formula to do this inside the SharePoint infopath form. So we did that through client side code in the page. We have added a script editor webpart in the page and wrote the following code to do the calculation in the page.

Here ctl00_ctl29_g_0d2d6eff_f266_41bf_b14f_ce80bdc728ed_FormControl0_V1_I1_T11 is the id of the calendar control which user selecting.

<script type="text/javascript">
function test(){
var x = 12;
var CurrentDate = new Date();
CurrentDate.setMonth(CurrentDate.getMonth() + x);
var d1=document.getElementById("ctl00_ctl29_g_0d2d6eff_f266_41bf_b14f_ce80bdc728ed_FormControl0_V1_I1_T11").value;
var date = new Date(d1);
date.setMonth(date.getMonth() + x);
<input onclick="test()" type="button" value="Alert value in form control"/>

Friday, March 13, 2015

Get all items selected using JavaScript in SharePoint 2013 or SharePoint Online

In this post we will discuss how to get id of all the selected items from the SharePoint list using JavaScript. The same code will work for SharePoint Online also.

Just put the below code inside a script editor web part. Then on click on the button, it will display you id of all the items you have selected.

<input type='button' id='123' value='Click Me' onclick="getSelectedItems();"/>

<script language="javascript" type="text/javascript">
function getSelectedItems()
var ctx = SP.ClientContext.get_current();
var items = SP.ListOperation.Selection.getSelectedItems(ctx);
var myItems = '';
var i;
for (i in items){
    myItems = items[i].id;

Friday, January 16, 2015

Infosys SharePoint Interview Questions

Here are few SharePoint interview questions asked in a technical interview in Infosys.

1- Tell something about yourself specially the projects you have done in SharePoint

2- What are the difference between SharePoint 2013 and 2010

3- What are App models and what is the difference between sharepoint hosted app and provider

hosted app?

4- What is difference between site collections and sites? When to choose site collection over sites?

5- What is a visual web part? And where you have used visual web part is your project?

6- What is feature? How you can deploy your feature?

7- Have you created any master page in SharePoint 2013?

8- What is difference between Site definition and site template?

9- What is difference between SPSite and SPWeb?

10- Can you write some server object model code to insert an item to a sharepoitn list.

11- Have you worked in infopath in sharepoint 2013? Next version of infopath will not come, then

why you still working on that?

12- Have you written any CAML query? Can you write a sample query?

13- Have you ever work on Search?

14- How crawling works in SharePoint 2010?

15- How search will work if you try to retrieve items from a very large list (more than 1 lakhs

records are there)?

16- My SharePoint site's performace is not good, what are things you will check?

Monday, January 12, 2015

Cancel not completed workflows using PowerShell in SharePoint 2013

We can cancel all workflows having status not equal to "Completed". Suppose you have a list which contains more than 1000 items and you realize the workflow which is attached to the list going to Suspended state or in progress state. Here if you want to cancel the workflows which are not completed, then it can not be a manual task when your list is larger. If you have 10/20 items then you can do manually, but in other case manual process is not a good option.

Also check out: Find larger files inside web application in SharePoint using PowerShell

I got a very good PowerShell approach from Raymun Macaalay's Dev Blog to cancel workflows. Thanks to the author for sharing this.

Below is the PowerShell script:
#Your Shaeproint Site URL
$web = Get-SPWeb "";
$web.AllowUnsafeUpdates = $true;  
#Your List Name
$list = $web.Lists["YourListName"];
$count = 0
#Loop through all Items in List then loop through all Workflows on each List Items.        
foreach ($listItem in $list.Items)
 foreach ($workflow in $listItem.Workflows)
  #Disregard Completed Workflows
  if(($listItem.Workflows | where {$_.InternalState -ne "Completed"}) -ne $null)
   #Cancel Workflows      
   write-output "Workflow cancelled for : " $listItem.Title;

Remove Sharepoint 2013 Quick Launch bar

We can hide quick launch bar in SharePoint 2013 by using css property.

We can remove that by using css and also we can remove that by modifying the master page. If you will modify through css code, then this is going to be page specific, mean which page you want to hide, you need to write the css code in that page.

You can also see: Different ways to add video into blog post in SharePoint 2013

1st Approach:
Put the below css code in the page using a script editor web part to hide the quick launch bar. Edit the page and then add a web part and then selece script editor web part from the web part gallery.

#sideNavBox { display: none }

Here sideNavBox is the <div> id of the Qucik launch bar.

Once you put the above code, it will hide the bar. But the content will be in the same place. If you want to move the content box a bit left then you can give some margin-left to the content box like below:
#sideNavBox { display: none }
#contentBox { margin-left: 25px }

Here contentBox is the <div> id of the Content box.

In which page you want, you can put the above code in Script editor web part.

2nd Approach:
Rather than putting the code in every page, you can put the code in the master page itself. If you put in the master page, then whatever page inherit the master page, will reflect those changes. By default Team site uses seattle.master page. Ok here one point, before doing any changes to the master page, please take a backup of the page and then modify on the page.

You can edit the master page using Sharepoint 2013 designer and then put the below code inside the <body> tag.

#sideNavBox { display: none }
#contentBox { margin-left: 25px }

Twitter Delicious Facebook Digg Favorites More