How to Pass Parameters to Success method in executeQueryAsync SharePoint

Summary :P assing Parameters to Success method in executeQueryAsync SharePoint, Passing Parameters and Returning Values from Success method in executeQueryAsync + Client Object Model + SharePoint 2010\SharePoint 2013,How to Pass Parameters and Retrieve Values from Success method in executeQueryAsync() SharePoint

This is quick tip about how to Pass Parameters and Retrieve Values from Success method in executeQueryAsync()

To Pass a Parameter in Success method use the following Syntax –

Before passing Parameters:

context.executeQueryAsync(Function.createDelegate(this,this.success)),

Function.createDelegate(this, this.failed));

After passing Parameters:

context.executeQueryAsync(

Function.createDelegate(this,function(){success(_parameter);}),

Function.createDelegate(this, this.failed));

function success(_parameter)
{
alert("In Success Method! " + _parameter);
}

To Retrieve Values from Success method use the following Syntax –

context.executeQueryAsync(

Function.createDelegate(this, function(){ _returnParam = success(_parameter);}),

Function.createDelegate (this, this.failed));

alert(_returnParam);





How to Batch Update List Items in SharePoint 2013 based on a CAML query (using Web Services + AJAX + JQuery)

Example of Batch Updating List Items in SharePoint 2013 based on a query using Client Object Model and Jquery.

In this example we will look at a Script where we make an Ajax call to GetlistItems web service and pass a CAML query to retrieve all Items with "Project Cost" greater than $1000 (as seen in the Before Projects list screen below). Once the Items are Retrieved (based on a "Project Cost" CAML query), we Create a Update Batch of these Items and pass it to the UpdateItems method.The UpdateItems method finally updates the required Items in the Projects List with the appropriate Status (see the After Image below).

Final Result – After running the Batch update script, all the Items with "Project Cost" > $1000 will have an updated Status of "Transferred" in the Custom Project List that we have Created.

Before :

1

After :

2

To begin,

1. Download the Script  and add it to Script Editor or Content Editor WebPart on your Lists Page. 2. Edit the listname, Column names and Value for the CAML query and update batch (in AddTobatch() method). 3. Once done Save and Click the link "Update Status for Items with Project Cost >$1000″ to update the Items that are retrieved from the CAML query. 4. Once updated a Confirmation message – "Update Complete" is displayed.

3





Folders and unsupported file types can’t be uploaded in SharePoint 2013

This is a quick tip about adding Folders or Items to a document Library using the new Drag and Drop feature.

If you are trying to Drag-n-Drop folders into a documnet library, you might run into the following error -

"Folders and Unsupported file types can't be uploaded"

1

The error simply occurs because with the new Drag and Drop feature you cannot add or Upload Folders,Items and Document sets into the library.This is a major limitation for Companies who love to add folders instead of individual Files in the library.

If this what your requirement is, there are few alternatives available for you.

1. Use the conventional Windows Explorer View - To Open Windows Explorer click on Upload Document button as shown in picture below

2

Next in the Add Documents popup click on "Upload Files using windows Explorer Instead" to Open the Windows explorer view where you can Drag and Drop folders.

3

2. Map the Document Library as Network Drive – You can Map any document library as a network drive and then drag and drop folders to it.

4

When you Map a document Library as a Network drive, you might see an error because of the missing "Desktop Experience" feature in Windows Server 2012. Take a look at this post where we resolve this issue and Map Master Page gallery as a Network drive.

 

3. Using SYNC Option - In SharePoint 2013, you can make any Document Library SYNC to your Local Folder (Including the SkyDrive PRO Library) to work with documents Offline. Once the Library is SYNCed users can Open, Edit and Add Files and Folders to the SYNCed Library Folder that gets created on your Local. These additions can be Synced back to the Library either everytime when you connect to SharePoint or On-Demand with "Sync now". Take a Look at the steps at Work with Documents Offline in SharePoint 2013





How to: SharePoint 2010 User Name Displaying Incorrectly in Option Menu

  I found an interesting bug that can occur when SharePoint 2010 syncs with AD and the user name is entered incorrectly in AD then fixed later. The profile sync will fix the name in most places except one of the most important and highly visible locations, the Option Menu. The Option Menu in SharePoint 2010 is the top right of every SharePoint 2010 page on a SharePoint site, it displays your user name, and this bug makes it so it's incorrect until you manually update it.

This isn't a very common problem but it occurs when a user it put into AD incorrectly, then SharePoint does its AD sync and the name is stored in the User Profile database with the wrong spelling. Later the name is updated in AD and SharePoint will sync the correct name. The problem is that for some reason the Option Menu display won't update to the correct spelling. That is unless you force it to, the following steps explain how to force the update and correct the issue.

1. Open the SharePoint 2010 server that hosts Central Admin

2. Click Start

3. Click All Programs

4. Click SharePoint 2010 Products

5. Click SharePoint 2010 Management Shell (run as administrator)

6. Type Set-SPUser -Identity 'Domain\UserName' -Web http://SharePointServer -SyncFromAD

7. Hit Enter (the script will run and once complete will prompt you that it completed)

Once the command completes you should be able to go back to any SharePoint page and the user name should now display properly. If it doesn't this could be a simple browser cache issue, so depending on your browser of choice clear cookies and cache and re-open SharePoint. The issue should now be resolved.

Well hopefully this fixed your issue with the SharePoint 2010 user name displaying incorrectly in the option menu. I know this can be a frustrating issue for users; they of course want their name displayer properly.

If you are unable to use the Exchange AD synch option described earlier, sign into SharePoint as as a different user and delete the wrong username. Open the option menu next to the username in the SharePoint page and choose "Sign in as a Different User" and sign in with a different user credential. Go back to the options menu and choose the "My Settings" option; the wrong user name should still be displayed on the sharepoint site. When the settings page open, click the "Edit Item" option. Within the edit window, choose the option to delete the username with the wrong information. Logout of the sharepoint page and then log back in with the right user credentials. This process should update to the correct user data on the sharepoint page.
 
 
 




Lync State display in a custom webpart for SharePoint 2010

I recently spent a while trying to integrate the Lync state into a custom web part and found it a little tricky so wanted to share my learning's. With SharePoint 2010's new social capabilities, I see this integration as being a must-have for any webpart or other custom interface that refers to people.

How does SharePoint do it?

Whenever a person's name is mentioned in the standard SharePoint UI, if the user has Office Communicator installed, the name will be shown with the Office Communicator 'pawn'. The pawn shows the user's status and gives them access to the pop-up menu to see more details.

Depending on which version of Office the user has installed, the experience will vary, however it will be the same experience as seen in Outlook. In Office 2010 it is a square icon with a richer drop-menu, in 2007 it is round.

SPPresencePawn

In addition to the pawn, the user's name will be a hyperlink to their profile page. This will vary depending on whether the user is in the main 'User Profile Service Application' (or 'profile database' for old-school terminology) or not. If the user does have a profile then the hyperlink will redirect to the user's main profile page under My Site. If the user does not have a profile, the hyperlink will redirect to the SharePoint Foundation 'User Information' page. All users in a site have a 'User Information' page, if they also have a User Profile the settings from the profile are synchronised down to the User Information page on a scheduled basis (by a timer job).

The key piece of information to make the presence work is the user's SIP Address which is basically their IM address (This is not always the same as email address). When a users is either added to a site in SharePoint or has their profile imported, the SIP Address will be drawn from Active Directory which is where OCS stores it and placed into the SIP address field in either the user's profile which will in turn synchronise down to the site's local 'User Information' page.

How does the pawn work in terms of HTML?

The pawn is basically an IMG element which has "IMNRC('[user's SIP Address]')" for the onload function. This will user client-side script that is part of Office to load the presence pawn on the page.

The hyperlink on the user's name is just a simple A element which redirects to "/_layouts/userdisp.aspx?ID=[User's local user information list item ID]". This userdisp.aspx page will then redirect to the user's main profile page if they have a profile, otherwise it will display the basic information that the user information list item stores.

How to get the SIP Address?

Hopefully you'll have spotted by now that the presence pawn relies on the user's SIP Address. To get the SIP address you need to get the user's User Information list item from the local site's (SPWeb to be precise) SiteUserInfoList which is basically a hidden SPList that is in every web.

There is a handy property to get you to this list called 'SPWeb.SiteUserInfoList'. This will give you an SPList object which represents the User Information list. From here you just need to find the item that represents the user you wish to display. The best way to do this is via their ID (the ID of the list item) by calling SPWeb.SiteUserInfoList.GetItemById([int User's ID]), however you can also use a variety of other methods which use SPQuery or match a specific field to a value.

In most scenarios, you may be getting the user information from a SPFieldUserValueCollection which is basically the field type that is used for 'Person' fields. If this is the case you can use SPFieldUserValue.LookupId to get the ID of the user's User Information list item.

Putting it all together

This code sample is a method that accepts an SPFieldUserValueCollection and SPSite as inputs and returns back the HTML for displaying each entry in the SPFieldUserValueCollection with the presence pawn and link to their profile. This will be presented exactly as SharePoint presents it by default. This could be extended to use ALT tags in the IMG and A elements.

I then simply add the HTML to an HtmlWriter or in my case a TableCell.Text property to display it on screen.

I've take a few extra steps here by adding ID and alt tags and trying to make the code readable, but I'm sure you get the idea:

public string GetPresenceHTMLFromUVC(SPSite thisSite, SPFieldUserValueCollection uvc)
{
StringBuilder html = new StringBuilder("");
using (SPWeb thisWeb = thisSite.RootWeb)
{
foreach (SPFieldUserValue uv in uvc)
{
string sipAddress = "";
//Get the sip address if it exists
SPListItem user = thisWeb.SiteUserInfoList.GetItemById(uv.LookupId);
if (user["SipAddress"] != null)
{
sipAddress = user["SipAddress"].ToString();
}
//construct the html for this user and add to overall html
html.Append(String.Concat(
"<div id\"PresenceLink"
, sipAddress
, "\">"
, "<img border=\"0\" height=\"12\" src=\"/_layouts/images/imnhdr.gif\" onload=\"IMNRC('"
, sipAddress
, "')\" ShowOfflinePawn=\"1\" style=\"padding-right: 3px;\" id=\"PresencePawn"
, sipAddress
, "\" alt=\"presence pawn for "
, sipAddress
, "\"/>"
, "<a href=\""
, thisWeb.Url
, "/_layouts/userdisp.aspx?ID="
, uv.LookupId
, "\" id=\"ProfileLink"
, sipAddress
, "\">"
, uv.User.Name
, "</a></div>"
));
}
}
return html.ToString();
}






Sort Folders (Custom Order) in SharePoint Document Library

Sort Folders (Custom Order) in SharePoint Document Library

One of my friend recently asked me this question about sorting the folders (not in alphabetical order) in a document library. The sort order has to be custom and user should be able to specify the order in which folders should appear. Example sort order

 

Top

Middle

Bottom

 

 

In order to implement this you can create a new folder content type and add an order column to this content type. You do need to have the appropriate rights to do so.

 

The steps would be as follows.

·         Go to Site Actions

·         Go to Site Settings

·         Go to Site Content Types

·         Click Create New

·         Give it a name such as Folder Order

·         Select Parent Content Type from as of Folder Content Types

·         Select Folder as the Parent Content Type

·         You can create a new group or leave it in custom content types

·         Click OK

·         At the content type settings click Add from new site column

·         Create a site column called Item Order or something similar, select the type as Number

·         Click OK

·         Go to the list where you want the folders to be ordered

·         Go to the list settings

·         Go to Advanced Settings

·         Select allow management of content types

·         Select No for display new folder command on the new menu

·         Click OK

·         You should now see an area called content types, leave the document as is

·         Click Add from existing site content types

·         Select the Folder Order (or whatever you named it)

·         Click OK







Create a Custom Action Specific to a List for SharePoint 2013/SharePoint 2010

You can create a custom action that is based on the list type by editing the elements.xml file that is associated with the custom feature. However, you can also create a custom action that is specific to a list rather than a list type. To do this, create a custom feature for the content type and then make a minor modification in the elements.xml file. The following steps demonstrate how to do this.

Create a custom content type

  1. Create a custom content type by inheriting from any one of the standard Windows SharePoint Services content types.

  2. Ensure that the identifier (ID) of your custom content type has the ID of the base content type (from which it inherits) as its ID prefix.

    The following example XML code shows the elements.xml file for a custom content type that was inherited from the standard Windows SharePoint Services content type, in this case, the List content type.
    <?xml version="1.0" encoding="utf-8" ?>
    <Elements xmlns="http://schemas.microsoft.com/sharepoint/">
      <ContentType ID="0x01AB"
         Name="MyCustomContentType"
         Group="MyCustomContentTypeGroup"
         Description="Customized Content Type"
         Version="0">
       <FieldRefs>
        <FieldRef ID="{8c06beca-0777-48f7-91c7-6da68bc07b69}"
         Name="Created"
         DisplayName="Field1" />
        <FieldRef ID="{1df5e554-ec7e-46a6-901d-d85a3881cb18}"
         Name="Author"
         DisplayName="Field2" />
       </FieldRefs>
      </ContentType>
    </Elements>

    Create your custom action

    • In the Elements.xml file, create your custom action, as illustrated in the example following.
      <?xml version="1.0" encoding="utf-8" ?>
      <Elements xmlns="http://schemas.microsoft.com/sharepoint/">
      <!-- Document Library Toolbar New Menu Dropdown -->
         <CustomAction Id="UserInterfaceLightUp.DocLibNewToolbar"
          RegistrationType="ContentType"
          RegistrationId="0x01AB"
          Rights="ManagePermissions"
          Location="EditControlBlock"
          Sequence="1000"
          Title="MY DOCLIB NEW MENU TOOLBAR BUTTON">
         <UrlAction Url="/_layouts/LightupHello.aspx?NewMenu"/>
        </CustomAction>
      </Elements>

      Create the list

      1. Create the list where you want to render the custom action.

      2. Change the default content type of the new list to the custom content type that you created above.

      3. Delete the Item content type from the list. At this point, the custom action will be rendered in the Edit Control Block menu of the specified list.





Enable The SharePoint Learning Kit Feature On All Sites In A Site Collection

Sometimes you want to be able to assign work from anywhere within your site collection. For the E-Learning Actions custom action to be added to a document library you need to enable the SharePoint Learning Kit feature on that site, so to enable it everywhere you need to enable the feature on all sites.

To do this in SharePoint 2010 all you need is a simple PowerShell script which iterates through all the sites and then enables the feature if it is not already enabled. The following script will do that for you. You will need to change the url value to reference your site collection, save in a .ps1 file and then run from the SharePoint 2010 Management Shell.

$url = "http://urlOfSiteCollection"  $site = Get-SPSite $url  $featureId = "00057002-c978-11da-ba52-00042350e42e"  $featureName = "SharePointLearningKit"  $site.Urlforeach ($web in $site.AllWebs)  {      # Output the site url for debugging purposes      $web.Url      # Only enable if not already enabled      if (!$web.Features[$featureId])      {          # Output debugging message          "Enabling..."          Enable-SPFeature $featureName -Url $web.Url      }  }

You can also use this for other features, just by replacing the feature id and name with the appropriate values. To find these look in

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES

The feature name is the name of the folder in here and the id is in the feature.xml file in that folder.



Using PowerShell to Bulk Upload Files to SharePoint 2013/SharePoint 2010

While building a school's Learning Gateway I needed to bulk upload all their student images into a picture library so that the My Children web part could display them. Since there were several hundred of them I wrote a little PowerShell script to perform this.

$siteUrl = "http://sharepoint/schools/test" $listName = "Students Picture Library"  [system.reflection.assembly]::LoadWithPartialName("Microsoft.Sharepoint") $site = New-Object Microsoft.SharePoint.SPSite($siteUrl) $web = $site.OpenWeb()$list = $web.Lists[$listName] $fileCollection = $list.RootFolder.Files  $files = get-childItem -Exclude *.ps1  foreach ($file in $files) {     $stream = $file.OpenRead()     $uploaded = $fileCollection.Add($file.Name, $stream, $TRUE)     "Uploaded " + $file.Name      if ($stream) {$stream.Dispose()} }  if ($web) {$web.Dispose()} if ($site) {$site.Dispose()}

In order to use this:

  1. Save as as .ps1 file in the same folder as the files to upload.
  2. Change the site url and name of the list at the beginning of the script to your values
  3. Make sure that only the files to upload and the ps1 file is in the folder
  4. Open PowerShell using Run As Administrator
  5. Navigate to the folder
  6. Run the .ps1 file

The script will then iterate through all files in the current folder and upload them to the given list, overwriting them if they already exist.

SharePoint 2010 - Migrate Users with Move-SPUser from one Active Directory to another

I recently ran into a scenario where a customer was migrating their Active Directory users to a new domain to reflect a naming change for their company. I was tasked with researching and documenting the steps required to migrate their SharePoint 2010 users.

After reading a few different blogs and some Technet articles I found that it was a pretty simple task using basically one powershell cmdlet - Move-SPUser.

List current user in a SP Site:

If you want to list the current users who have access to a SharePoint site you can use the following cmdlet:

Get-SPUser -Web [URL of SiteName to scope]

This will give you a list of current users/Groups with permissions on the site. You can also find this list in the Content_Database in SQL under the dbo.AllUsers table.

The first thing I always do before making any changes is a backup of the Sharepoint Site Collection - seehttp://technet.microsoft.com/en-us/library/ee748617.aspx#section2.

Once the backup is complete you can start migrating your users: Depending on the authentication method your site users E.g. Claims or Classic NTLM you will need to adjust the username.

To migrate the users to the new domain:


(Note for Claims based you woud enter username format as :i:0#.w|domain\user)

$user = Get-SPUser -web http://my.website.url -Identity DomainA\UserA
Move-SPUser -IgnoreSID -Identity $user -NewAlias 'DomainB\UserA'

Currently this does user by user but you can write this up with a CSV as well and import the list. I am working on that script now for my company and will post when it is complete.









SharePoint 2013 Standard vs. Enterprise vs. Foundation Feature Comparison Matrix

SharePoint 2013 Feature Description Foundation Standard Enterprise
Developer
Access Services Build web databases and publish them to a SharePoint site. SharePoint visitors can use your database application in a web browser by using SharePoint permissions to determine who can see what. And you can start with a template so that you can start collaborating immediately. No No Yes
App Catalog (SharePoint) Publish your apps to an internal corporate catalog, hosted on your SharePoint deployment, to make them available to users who have access to that SharePoint deployment. Learn more about publishing apps for Office and SharePoint. No Yes Yes
App Deployment: Autohosted Apps Autohosted Apps are installed to a host web on the customer's SharePoint Online tenancy, with components automatically installed into a Windows Azure website account. The Windows Azure Web Sites infrastructure manages isolation of tenancies. Learn more about hosting options for apps for SharePoint. No No No
App Deployment: Cloud-Hosted Apps Cloud-hosted apps for SharePoint includes at least one remote component and may also include SharePoint-hosted components. Cloud-hosted apps include both autohosted and provider-hosted apps. Learn more about hosting options for apps for SharePoint. No Yes Yes
App Deployment: SharePoint-Hosted Apps SharePoint-Hosted Apps allow you to reuse common SharePoint artifacts, such as lists and Web Parts. When you take this approach, you can use only JavaScript and you cannot use any server-side code. Learn more about hosting options for apps for SharePoint. No Yes Yes
App Management Services The App Management Service database stores licensing information for all of the apps for SharePoint. No Yes Yes
BCS: Alerts for External Lists SharePoint now provides the capability of using alerts for external lists, just as they have been used for traditional lists. A user can subscribe to be alerted when data changes on an external list. Learn more about external events and alerts in SharePoint 2013. No Yes Yes
BCS: App Scoped External Content Types (ECTs) With the addition of the new App model in SharePoint, Business Connectivity Services (BCS) can now scope external content types at the App level instead of at the farm level. This gives great flexibility to App developers by allowing them to use external data inside their Apps. Learn more about app-scoped external content types. No Yes Yes
BCS: Business Data Webparts Business Data Webparts are special web parts that work with external data. They are used like standard SharePoint web parts, but are based on external content types, which are XML descriptions of connections to the external data. No Yes Yes
BCS: External List An external list is a special kind of SharePoint list that displays data from an external data source. It is built on an external content type that describes the data source, and allows users to work with the data in a familiar SharePoint interface. Learn more about external content types. Yes Yes Yes
BCS: OData connector The OData connector is new for SharePoint. It allows for Business Connectivity Services (BCS) to use a RESTful OData endpoint as a data source for external lists, Business Data WebParts, and custom user interfaces. No Yes Yes
BCS: Profile Pages Not available to SharePoint Online customers. Business Connectivity Services (BCS) provides a special WebParts page called Profile pages. Profile pages allows for BCS to display details of the external data in addition to its related external content types. No Yes Yes
BCS: Rich Client Integration Not available to SharePoint Online customers. Business Connectivity Services (BCS) uses a complimentary client and server-side architecture that allows for Office clients, such as Outlook and Excel, to work directly with external data exposed to SharePoint through external content types. Learn more about Business Connectivity Services Client Runtime. No No Yes
BCS: Secure Store Service The Secure Store provides single sign on capabilities to Business Connectivity Services (BCS). Using Secure Store, SharePoint Administrators can map user account credentials to external system account credentials so that data can be secured. Learn more about Secure Store Service. Yes Yes Yes
BCS: Tenant-level external data log Tenant-level external data logging allows for logging of transactions that affect specific SharePoint tenancies. No No Yes
Browser-based customizations You can customize your site without any special tools or coding expertise just by using the site settings. For example, you can change the look, title, and logo, change the navigation links, change the contents of a page, or change the appearance of views for lists and libraries. Learn more about customizing sites. Yes Yes Yes
Client Object Model (OM) SharePoint 2013 has three client object models for managed code: .NET, Silverlight, and mobile. In addition, SharePoint includes a JavaScript client object model. Learn more about choosing the right API set in SharePoint 2013. Yes Yes Yes
Client-side rendering (CSR) Client-side rendering provides a mechanism that you can use to produce your own output for a set of controls that are hosted in a SharePoint page. Learn more about customizing a field type using client-side rendering. Yes Yes Yes
Custom Site Definitions Not available to SharePoint Online customers. SharePoint Server 2013 customers can create their own site definitions that customize and extend standard SharePoint site templates. Learn more about creating custom site definitions. No No Yes
Custom Site Provisioning Not available to SharePoint Online customers. SharePoint Server 2013 customers get a quick and easy way for users to make their site requests and to start using their sites quickly. No No Yes
Developer Site Use an Office 365 Developer Site as a development and testing environment to shorten your setup time and start creating, testing, and deploying your apps for SharePoint. Learn more about signing up for an Office 365 Developer Site. No No although On Prem has it's own Developer Site Template No although On Prem has it's own Developer Site Template
Forms Based Applications A form view is basically a view that contains controls. A Forms Based Application lets the user create and use one or more forms within the application. Learn more about Forms Based Applications. No Yes Yes
Forms on Spreadsheets Forms on Spreadsheets is a lightweight survey tool built on top of the Excel Web App—authenticated or anonymous users can complete the form on internal or public websites, and the data from all users is aggregated into a single private and secured workbook in SharePoint. No Yes Yes
Full-Trust Solutions Not available to SharePoint Online customers. SharePoint Server 2013 customers can create full-trust solutions. Also called farm solutions. Unlike apps for SharePoint, farm solutions contain code that is deployed to the SharePoint servers and makes calls to SharePoint's server object model. These assemblies always run with full trust. Farm solutions should be used for customizations of SharePoint administrative functions, such as custom timer jobs, custom Windows PowerShell cmdlets, and extensions of Central Administration. Learn more about building farm solutions in SharePoint 2013. Yes Yes Yes
InfoPath Forms Services Forms Service provides a Web browser form-filling experience in SharePoint, based on form templates that are designed in InfoPath. Learn more about InfoPath Forms Services. No No Yes
JavaScript Object Model SharePoint provides a JavaScript object model for use in either inline script or separate .js files. It includes all the same functionality as the .NET Framework and Silverlight client object models. The JavaScript object model is a useful way to include custom SharePoint code in an app. It also enables web developers to use their existing JavaScript skills to create SharePoint applications with minimal learning curve. Learn more about JavaScript API reference for SharePoint 2013. Yes Yes Yes
List and Library APIs SharePoint provides Aps for accessing list and library data in the server object model, managed and JavaScript client object models, and the REST web service. Yes Yes Yes
Remote Event Receiver To handle events in an app for SharePoint, developers can create remote event receivers and app event receivers. Remote event receivers handle events that occur to an item in the app, such as a list, a list item, or a web. Learn more about handling events in apps for SharePoint. Yes Yes Yes
REST API SharePoint 2013 provides an implementation of a Representational State Transfer (REST) web service that uses the OData protocol to perform CRUD operations on SharePoint list data. Use this when you must access SharePoint data from client technologies that do not use JavaScript and are not built on the .NET Framework or Microsoft Silverlight platforms. Learn more about programming using the SharePoint 2013 REST service. Yes Yes Yes
Sandboxed Solutions A sandboxed solution, compared to a farm solution, enables site collection administrators to install custom solutions in SharePoint Foundation without the involvement of a higher-level administrator. Learn more about Sandboxed Solutions in SharePoint. Yes Yes Yes
SharePoint Design Manager The Design Manager enables a step-by-step approach for creating design assets that you can use to brand sites. Upload design assets—images, HTML, CSS, and so on—and then create your master pages and page layouts. Learn more about SharePoint 2013 site development. Yes Yes Yes
SharePoint Designer Using SharePoint Designer, advanced users and developers can quicky create SharePoint solutions in response to business needs. Learn more about SharePoint Designer for developers. Yes Yes Yes
SharePoint Store The SharePoint Store provides a convenient location for developers to upload new app solutions that are aimed both at consumers and businesses. Learn more about publishing apps for Office and SharePoint. Yes Yes Yes
Workflow 2010 (.NET 3.5) SharePoint legacy workflow functionality, compatible with .NET 3.5. Learn more about workflows in SharePoint Foundation. Yes Yes Yes
Workflow 2010 (out of the box) Use out of the box workflows included with SharePoint to model common business processes. No Yes Yes
Workflow 2013 SharePoint 2013 workflows are powered by Windows Workflow Foundation 4 (WF), which was significantly redesigned from earlier versions. Perhaps the most prominent feature of the new workflow infrastructure is the introduction of Windows Azure as the new workflow execution host. Learn more about what's new in workflows for SharePoint 2013. No Yes Yes
Workload API: ECM APIs Extend SharePoint enterprise content management capabilities using the Search APIs available in the server, .NET client, and JavaScript object modelsand REST service. Learn more about SharePoint 2013 Sites and Content server class library. No Yes Yes
Workload API: Search APIs Extend SharePoint search capabilities using the Search APIs available in the server, .NET client, and JavaScript object modelsand REST service. Learn more about SharePoint 2013 Search server class library. Yes Yes Yes
Workload API: Social APIs Extend SharePoint social capabilities using the Social APIs available in the server, .NET client, and JavaScript object modelsand REST service. Learn more about SharePoint 2013 Social server class library. No Yes Yes
IT Pro
Active Directory Synchronization If your company has existing users in a local Active Directory environment, there are tools for synchronizing those users to your Office 365 for enterprise directory. The Office 365 directory then feeds the SharePoint Online user profile. Learn more about Active Directory Synchronization. Yes Yes Yes
Alternate Access Mapping (AAM) Not available to SharePoint Online customers. SharePoint Server 2013 customers can configure alternate access mapping to map requests where the URL of a Web request received by Internet Information Services (IIS) differs from the URL that was typed by a user. Yes Yes Yes
Analytics Platform Not available to SharePoint Online customers. SharePoint Server 2013 customers can use the Analytics Platform, which replaces the Web Analytics service application, to help identify and surface the content that users consider to be the most useful and relevant. Learn more about Analytics Platform. No No Yes
Claims-Based Authentication Support Not available to SharePoint Online customers. SharePoint Server 2013 customers configure claims-based authentication for web applications that support SharePoint Server 2013 server-to-server authentication and app authentication. Learn more about claims-based authentication. Yes Yes Yes
Configuration Wizards Not available to SharePoint Online customers. SharePoint Server 2013 customers can use the Farm Configuration Wizard to configure some SharePoint Server 2013 services automatically. Or they can configure services manually, which gives greater flexibility in designing a logical architecture. Learn more about the Farm Configuration Wizard. No Yes Yes
Deferred Site Collection upgrade Site owners can perform their own self-service upgrades to their sites, when it is most convenient for them. SharePoint Online also provides new features to support upgrade, such as the health checker and evaluation site collections. Learn more about Site Collection upgrade. Yes Yes Yes
Distributed Cache Not available to SharePoint Online customers. SharePoint Server 2013 customers can use the Distributed Cache service to cache feature functionality, which improves authentication, newsfeed, OneNote client access, security trimming, and page load performance. Learn more about Distributed Cache. Yes Yes Yes
Host Header Site Collections Not available to SharePoint Online customers. SharePoint Server 2013 site collections can have their own unique host header. Creating a host-named site collection enables organizations' to hose multiple site collections with vanity URLs, which are easier for people to remember. Yes Yes Yes
Improved Permissions Management Three key security elements work together to control user access to sites and site content: Yes Yes Yes
Improved Self-Service Site Creation SharePoint Server 2013 customers can use self-service site creation to configure things such as: whether to use a custom form to create the site, whether to create a subweb or site collection, what path should be used when the site collection is created, and whether to ask or require that a site policy be selected when the site is created. No No Yes
Managed Accounts Not available to SharePoint Online customers. SharePoint Server 2013 system administrators can use a Managed Account, an Active Directory user account whose credentials are managed by and contained within SharePoint, to easily manage administrative tasks. That way the fate of your organization's deployment does not rest on just one person's account. Yes Yes Yes
Minimal Download Strategy (MDS) The minimal download strategy will use a single .aspx file (start.aspx) for your pages, with the actual URL encoded in the text following the hashmark ('#'). When moving from page to page, only the changes between two compatible pages will be downloaded. Fewer bytes will be downloaded and the pages will appear more quickly. Yes Yes Yes
OAuth Oauth is an Internet protocol for creating and managing app identity. Oauth allows for app identity to be recognized apart from user identity. This cross-platform mechanism means apps can be granted more permissions than the current user has. Learn more about server-to-server authentication. No Yes Yes
Patch Management Not available to SharePoint Online customers. SharePoint Server 2013 updates will be released by using a two-step phase process: patching and upgrading. During the patching steps, new binary files are copied to the Central Administration server. Any services that are using files that have to be replaced are temporarily stopped. There are some instances when a server must be restarted. Yes Yes Yes
Quota Templates Not available to SharePoint Online customers. A quota template consists of storage limit values that specify the maximum amount of data that can be stored in a site collection. When the storage limit is reached, a quota template can also trigger an email alert to the site collection administrator. SharePoint Online administrators and SharePoint Server 2013 farm administrators can create a quota template that can be applied to any site collection. Yes Yes Yes
Read-Only Database Support Not available to SharePoint Online customers. SharePoint Server 2013 administrators can set content databases to be read-only. Yes Yes Yes
Remote Blob Storage Not available to SharePoint Online customers. Remote BLOB Storage (RBS) is an add-on feature pack for Microsoft SQL Server. RBS is designed to move the storage of binary large objects (BLOBs) from database servers to commodity storage solutions. If the content databases in Microsoft SharePoint Server 2013 are 4 gigabytes (GB) or larger, consider using RBS as part of your data storage solution. Yes Yes Yes
Request Management Not available to SharePoint Online customers. SharePoint Server 2013 administrators can define rules, by using Request Manager, to do request routing and throttling to improve performance. Yes Yes Yes
Request throttling Not available to SharePoint Online customers. Request throttling provides SharePoint Server 2013 administrators with options for throttling HTTP requests when front-end web servers become too busy to handle all the incoming requests. Yes Yes Yes
Resource throttling Not available to SharePoint Online customers. Resource throttling provides SharePoint Server 2013 administrators with options for monitoring and throttling server resources and large lists for Web applications. Resource throttling can monitor such resources as CPU, memory, and Wait Time, checking resources every 5 seconds. Yes Yes Yes
Service Application Platform SharePoint services can be individually consumed from any Web application. This platform provides the flexibility needed to use services, depending on application needs. Web Analytics is no longer a service application. Analyses and reporting processes were incorporated into the Search service application. Office Web Apps is no longer a service application. Office Web Apps Server is now a separate server product. Depending on what Office 365 plan your organization subscribes to, Office Web Apps may be available to SharePoint Online customers. Learn more about SharePoint service applications. Yes Yes Yes
SharePoint Health Analyzer Not available to SharePoint Online customers. New for SharePoint Server 2013, site collection pre-upgrade health check examines a site collection and then generates a report listing ay potential upgrade issues and how to address the issues. For example, if a file has been customized, it will be flagged, so your organization can identify the custom file and reset it to the default template if the site definition, if you want. Yes Yes Yes
SharePoint Online Admin Center The Microsoft SharePoint Online Administration Center, available to certain SharePoint Online customers only, enables administrators to manage features such as the following: Site collections, InfoPath forms,User Profiles,Business Connectivity Services (BCS),Managed metadata and the Term Store,Records management,Search,Secure Store,Apps for SharePoint,External sharing,Information Rights Management,Self-service site creation N/A N/A N/A
Shredded Storage Not available to SharePoint Online customers. Shredded storage is essentially the chunking of data—only differences are saved. That means if versioning is enabled and someone makes a change to a document, only changes "shreds" are added to the storage footprint of that document. Shredded storage improves I/O performance by reducing how much information retrieved by the web server from the content database. Shredded storage removes duplicate files, and improves data transmission speed. Yes Yes Yes
Site Collection Compliance Policies A site collection policy can be created in the Site Collection Policies list for the top-level site in a site collection. After a site collection policy is created, it can be exported so that site administrators of other site collections can import it into their Site Collection Policies list. Creating an exportable site collection policy enables SharePoint administrators to standardize the information management policies across the sites in an organization. No Yes Yes
Site Collection Health Checks Site collection owners or administrators can use the site collection health checker to detect issues with their site collections and address them before upgrading the sites to the new version. Learn more about Site Collection Health Checks. Yes Yes Yes
State Service Not available to SharePoint Online customers. The State Service allows SharePoint Server 2013 customers to check whether all services in their farm are configured correctly. Yes Yes Yes
Streamlined Central Administration Not available to SharePoint Online customers. SharePoint Server 2013 administrators can use Central Administration to perform administrative tasks from a single location. Yes Yes Yes
System Status Notifications Not available to SharePoint Online customers. SharePoint Server 2013 site collection owners will receive an email message and a status bar notification in a site collection when an upgrade is available. Yes Yes Yes
Unattached Content Database Recovery Not available to SharePoint Online customers. SharePoint Server 2013 customers can recover content from an unattached content database by using Central Administration. Yes Yes Yes
Upgrade evaluation site collections Not available to SharePoint Online customers. A key benefit of separating the process of upgrading software and data from upgrading sites is that it allows site owners or administrators to run sites in SharePoint 2010 mode until the sites are ready to be upgraded to the latest version. In preparation for upgrading the site, site owners or administrators can request an evaluation site collection, which is a copy of the site, for review purposes. Evaluation sites are set to automatically expire and be deleted. Yes Yes Yes
Usage Reporting and Logging Not available to SharePoint Online customers. SharePoint Server 2013 administrators use audit log reports to view the data in the audit logs for a site collection. Learn more about Site Collection audit logs. Yes Yes Yes
Windows PowerShell Support SharePoint Online administrators can use SharePoint Online Windows PowerShell cmdlets to script and automate administrative tasks for their subscription, such as the following: Site creation,Evaluation for site upgrade,Site upgrade,Adding and removing SharePoint users and groups,Site repair,Recycle bin management Yes Yes Yes
Content
Accessibility Standards Support Most SharePoint user interface (UI) elements, such as links, form controls, and buttons are designed to use Microsoft Active Accessibility (MSAA). MSA enables people with disabilities to interact with content by using assistive technologies, such as a screen reader. Learn more about Accessibility features. Yes Yes Yes
Asset Library Enhancements/Video Support An Asset Library is pre-configured to use special features that help users manage rich media assets, such as image, audio, and video files. Learn more about Asset Library. Yes Yes Yes
Auditing SharePoint Online site collection administrators can use the audit feature to track which users have taken what actions on the sites, content types, lists, libraries, lit items, and library files of site collections. Learn more about configuring audit settings for a site collection. No Yes Yes
Auditing & Reporting (e.g. doc edits, policy edits, deletes) SharePoint Online site collection administrators can use the audit feature to track which users have taken what actions on the sites, content types, lists, libraries, and list items of site collections. Learn more about configuring audit settings for a site collection. No Yes Yes
Auditing of View Events Not available to SharePoint Online customers. SharePoint Server 2013 customers who deploy on-premises can track and log when someone views a document. No Yes Yes
Content Organizer The Content Organizer acts as a gatekeeper for documents. You can automatically manage some important library tasks, such as managing folder sizes and routing documents to different libraries or folders. This not only saves time, but can help make sure that a document library is managed consistently. Learn more about Content Organizer. No Yes Yes
Design Manager Design Manager lets organizations change master pages, page layouts, mobile views, and more. This feature is especially useful for advanced site design and branding to your public-facing website or your internal site collection or portal. Learn more about site development. Yes Yes Yes
Document Sets Document sets let users store, act on, export, and add a description to multiple files as a single entity. Policies, tagging, and templates can be applied to any document set that is created. Learn more about Document Sets. No Yes Yes
Document Translation in Word Web App In Reading View, Word Web App now features an option to let organizations translate their documents directly in the browser. Even document comments are translated. Yes Yes Yes
eDiscovery Electronic Discovery, or eDiscovery, features allow organizations to identify, hold, search, and export content from Exchange mailboxes, SharePoint sites, and file shares to support case management in addition to preservation and compliance. Learn more about planning and managing eDiscovery cases. No No Yes
External Sharing: External Access If your organization performs work that involves sharing documents or collaborating directly with vendors, clients, or customers, then you might want to use your SharePoint Online sites to share content with people outside your organization who do not have licenses for your organization's Microsoft Office 365 subscription. Learn more about external sharing. No No No
External Sharing: Guest Link When a site is shared in SharePoint Online, an email message is sent to the external user containing the invitation to join the site. Invitations can be sent to people with any type of email address, such as *.gmail.com, *contoso.com, or *Comcast.net. However, to sign in to the site, the email address has to be associated with a Microsoft account. Learn more about sharing a site with external users. No No No
Folder Sync Users can sync a SharePoint library to their computers, and then work with those files in the library by using File Explorer. Updates to files sync to SharePoint when users are online. SkyDrive Pro or a document library on a team site can be synched. Learn more about syncing a library to your computer. No Yes Yes
Information Rights Management (IRM) SharePoint Online IRM uses Windows Azure Active Directory Rights Management Services (RMS), an information protection technology in Office 365. IRM protection is applied to files at the SharePoint list and library levels. Learn more about IRM in SharePoint Online. No Yes Yes
In-Place Hold When a content source is part of an eDiscovery case, organizations can place it on hold so that a copy preserved. This includes SharePoint sites, documents, or pages, Lync conversations, and Exchange mailboxes. Learn more about placing content sources on hold. Yes Yes Yes
Managed Metadata Service Metadata management provides multiple taxonomies and folksonomies from a tenant-level store service that can be consumed at the site collection level. Metadata fields can even be embedded in documents. Learn more about managed metadata. No Yes Yes
Metadata-driven Navigation Metadata-driven navigation makes it easier to discover content in large lists and libraries. User tagging incentives are introduced and offer anticipatory suggestions of appropriate metadata based on location and context. Learn more about setting up metadata navigation. No Yes Yes
Multi-stage Disposition Retentions policies can have multiple stages, allowing you to specify the entire document lifecycle as one policy. For example, review contracts every year, and delete after seven years. Learn more about storing and managing records. No Yes Yes
Office ProPlus (Osub) Office ProPlus provides the complete Office 2013 application suite as a monthly subscription service. This lets customers purchase monthly licenses for each user that allow five concurrent installations. Learn more about Office ProPlus for Office 365. No No No
Office Web Apps (edit) Organizations must purchase an editing license for users to use the editing features of Office Web Apps. Learn more about Office Web Apps. Yes Yes Yes
Office Web Apps (view) By default, Office Web Apps are view-only. View-only functionality is provided for free. Learn more about using Office Web Apps in your organization's SharePoint site. Yes Yes Yes
Office Web Apps Server integration Not applicable to SharePoint Online customers. In SharePoint Server 2010, Office Web Apps was a SharePoint service application. For SharePoint Server 2013, Office Web Apps are now delivered in a new Office server product, Office Web Apps Server. A single Office Web Apps server farm can support users who access Office files through SharePoint Server 2013, Exchange Server 2013, shared folders, and websites. It's a simpler way of deploying and managing Office Web Apps in an on-premise environment. Learn more about Office Web Apps Server Integration. Yes Yes Yes
PowerPoint Automation Services Not available to SharePoint Online customers. PowerPoint Automation Services helps enterprises manage their presentations. It is a shared service that provides unattended, server-side conversion of presentations into other formats. Learn more about PowerPoint Automation Services in SharePoint Server 2013. No Yes Yes
Preservation hold library Content that is placed on hold is preserved, but users can still change it. The state of the content at the time of preservation is recorded. If a user changes the content or even deletes it, the item is retained at the time of deletion and the original, preserved version is still available. Learn more about placing content sources on hold. No No Yes
Quick Edit The Quick Edit View, also known as Datasheet View, displays list and library items in a grid, similar to a spreadsheet. Quick Edit can be helpful if you have to edit many items in a list or library at the same time. This view quires a control or program that is compatible with SharePoint, such as Microsoft Office, and ActiveX control support. Learn more about editing list items. Yes Yes Yes
Related Items Related Items is a site column that enables you to associate a related list item with another item. Yes Yes Yes
Rich Media Management An Asset Library is pre-configured to use special features that help you manage rich media assets, such as image, audio, and video files. Learn more about setting up an Asset Library to store image, audio, or video files. No Yes Yes
Shared Content Types To share content types among site collections, you make on content type gallery the "hub" of a managed metadata service, create connections to the service from each web application that contains a site collection, and specify that site collections should use the content types in the service. Learn more about sharing term sets and content types in SharePoint Server 2013. This feature is not available in SharePoint Online. No Yes Yes
SharePoint Translation Services The Machine Translation Service lets users automatically translate documents. You can create a Machine Translation service application and configure the Machine Translation Service by using Central Administration, or Windows PowerShell. Learn more about creating and configuring Machine Translation services in SharePoint Server 2013. Yes Yes Yes
Site mailbox A site mailbox is a shared inbox in Exchange Online that all the members of a SharePoint Online site can access. It is implemented in SharePoint Online as an app. No Yes Yes
Unique Document IDs The unique Document ID services improves the managing and tracking of information by assigning a unique, human-readable identifier to every piece of content, making it easier to locate, even if the content was moved from its original location. Learn more about Document IDs. No Yes Yes
Video Search An Asset Library is pre-configured to use special features that help you manage rich media assets, such as image, audio, and video files. Learn more about setting up an Asset Library to store image, audio, or video files. No No Yes
WCM: Analytics Not available to SharePoint Online customers. The Analytics Processing Component helps SharePoint Server 2013 administrators identify and surface content that users consider to be the most useful and relevant. The component analyzes both the content itself, and also the way users interact with it. The results from the analysis are added to the items in the search index so that search relevant improves automatically over time. Also, the results are used in reports that help search administrators see which manyual steps they can take to improve the search system. Learn more about analytics processing in SharePoint Server 2013. This feature is not available in SharePoint Online. No Yes Yes
WCM: Catalog Not available to SharePoint Online customers. A catalog is a library or list that is shared across other sites and site collections. Lean more about catalog content for SharePoint authoring sites. No No Yes
WCM: Cross-site publishing Not available to SharePoint Online customers. Cross-site publishing allows SharePoint Server 2013 customers to use one or more authoring site collections to author and store content, and one or more publishing site collections to control the design of the site and to show the content. The authoring site collection contains catalogs, such as Pages libraries and lists, which contain content that is tagged with metadata. These catalogs are indexed by the search system and made available to the publishing site collection. The publishing site collection issues queries for data that was indexed and shows it on web pages by using Web Parts that use search technology. Learn more about cross-site publishing in SharePoint Server 2013. This feature is not available in SharePoint Online. No No Yes
WCM: Designer Tools If an organization needs to completely redesign a site from scratch or reuse a previous site design, the Design Manager allows the modification of master pages, page layouts, mobile views, and more. This feature is especially useful for advanced site design and branding to a public-facing website or internal site collection or portal. No Yes Yes
WCM: Faceted navigation Not available to SharePoint Online customers. Faceted navigation help users browser for content more easily by filtering on refiners that are tied to terms in a term set. By using faceted navigation, SharePoint Server 2013 administrators can configure different refiners for different terms in a term set without having to create additional pages. Learn more about refiners and faceted navigation. No No Yes
WCM: Image Renditions Not available to SharePoint Online customers. Image renditions let organizations have large source images on a SharePoint Server 2013 site and also have places on a site where pages only use smaller versions. No No Yes
WCM: Mobile and Device Rendering SharePoint supports targeting different devices, such as smartphones, tablets, and set-top boxes. Designers can create channels that allow a single publishing site to be rendered in multiple ways by using different designs that target different devices. Learn more about design channels. No Yes Yes
WCM: Multiple Domains Not available to SharePoint Online customers. SharePoint Server 2013 can create host-named site collections with the host header. Host-named site collections in SharePoint provide URL management and scalability of sites within a single web application. This feature is not available to SharePoint Online customers. No No yes
WCM: OOTB Recommendations Webparts The Recommended Items Web Part shows content recommendations based on how users have previously interacted with the site. For example, you can add this Web Part to a catalog item page. If a user views a specific item, this Web Part will show other items that users have previously viewed, such as "Users who viewed this item also viewed these items." Lean more about Search Web Parts. No Yes Yes
WCM: Search Engine Optimizations (SEO) Optimizing a public website for search is very important to connecting with new and returning customers. SharePoint Online includes built-in SEO features, such as customizable robots.txt and page-level metatagging so organizations can easily tune sites for better search results. Learn more about optimizing your website for search. No Yes Yes
WCM: Topic Pages Not available to SharePoint Online customers. Category pages and catalog item pages are page layouts that you can use to show structured catalog content consistently across a SharePoint Server 2013 site. Learn more about cross-site publishing. This feature is not available in SharePoint Online. No No Yes
Word Automation Services Not available to SharePoint Online customers. Word Automation Services enables unattended, server-side conversion of documents that are supported by Microsoft Word. With Word Automation Services, tasks that previously required you to run the Word desktop application can be automated in SharePoint Server 2013. No Yes Yes
Insights
Business Intelligence Center The Business Intelligence Center site enables you to store data connections, workbooks, reports, scorecards, and dashboards in a central, secure location. Learn more about configuring Business Intelligence Center. No No Yes
Calculated Measures and Members When you create PivotChart reports of PivotTable reports that use data that is stored in SQL Server Analysis Services, you can create calculated measure and calculated members for that report. Learn more about Business intelligence capabilities in Excel Services. No No Yes
Data Connection Library A data connection library is a special SharePoint library that is designed to store and manage shared data connections. These can include ODC files that you create by using Excel. Learn more about Trusted Data Connection Libraries in SharePoint Server 2013. No No Yes
Decoupled PivotTables and PivotCharts When you create a PivotChart report, a corresponding PivtoTable report is automatically created. New in Excel 2013, you do not have to display a PivotTable report on the same worksheet as its corresponding PivotChart report. You can choose to display only the PivotChart report. This capability is called "decoupled PivotTables and PivotCharts". Learn more about PivotTables and PivotCharts. No No Yes
Excel Services Excel Services enables you to share workbooks with others, view and explore information in a browser window, and refresh data. Excel Services enables you to view and interact with reports, scorecards, and dashboards in a browser window, much like you would use the Excel client. Excel Services also enables you to share all or parts of workbooks with others, and control what information is displayed in those workbooks. Learn more about Excel Services. No No Yes
Field list and Field Support Excel Services enables you to open the Field List and Field Well for PivotChart reports and PivotTable reports that are viewed in a browser windows. This capability makes it easy to temporarily change the information that is displayed in a PivotChart report or a PivotTable report without having to open Excel. Learn more about Business Intelligence in Excel Services. No No Yes
Filter Enhancements Slicers are easier to create and connect to reports and scorecards. You can adjust the size and orientation of a slicer. You can also format slicers by applying built-in styles or defining your own style. No No Yes
Filter Search You can search on filter results, which makes it easy to jump to a particular item in a long list. Learn more about using filters and slicers. No No Yes
PerformancePoint Services Not available to SharePoint Online customers. PerformancePoint Services enables SharePoint Server 2013 customers to create interactive dashboards that display key performance indicators (KPIs) and data virtualizations in the form of scorecards, reports, and filters. Learn more about PerformancePoint Services. No No Yes
PerformancePoint Services (PPS) Dashboard Migration Not available to SharePoint Online customers. With Dashboard Migration, SharePoint Server 2013 customers will be able to copy complete dashboards and dependencies. This includes the .aspx file, to other users, servers, or site collections. This feature also allows the ability to migrate single items to other environments and migrate content by using Windows PowerShell commands. Learn more about creating Dashboards by using PerformancePoint Services. No No Yes
Power View Power View is an add-in for Excel that enables organizations to visualize and interact with modeled data by using highly interactive visualizations, animations, and smart querying. Organizations can present insights with other through storyboard presentation capabilities. Power View is powered by BI Semantic Model and the VertiPaq engine. Learn more about Power View. No No Yes
PowerPivot PowerPivot is an add-in that organizations can use to perform powerful data analysis and create sophisticated data models. PowerPivot also enables organizations to mash up large volumes of data from various sources, analyze data quickly, and share insights. Learn more about PowerPivot. No No Yes
Quick Explore Quick Explore enables organizations to select a value in a PivotChart report or a PivotTable report and see additional information about that value. For example, if you are viewing a sales report and you select a value that represents total sales amounts, you can use Quick Explore to view additional information such as sales amounts across different product categories or geographical areas. Learn more about Quick Explore. No No Yes
Scorecards & Dashboards Not available to SharePoint Online customers. A scorecard shows at a glance whether performance is on or off target for one or more key performance indicators (KPIs). A dashboard is a collection of views that can include scorecards and other reports. Scorecards and dashboard are designed to show current performance information and are typically rendered in a site such as a SharePoint Server 2013 site. Learn more about creating and using a report or a scorecard. No No Yes
SQL Server Reporting Services (SSRS) Integrated Mode When SQL Server 2012 Reporting Services is integrated with SharePoint, you can use powerful SharePoint collaboration and centralized document management features for SQL Server 2012 Reporting Services content. Reports are stored in SharePoint document libraries, alongside other reports such as Excel Services files. SharePoint permissions can be used to control access to Reporting Services content, and people are able to start Report Designer, Model Designer, and Report Builder within a document library. Learn more about Reporting Services Report Server. No No Yes
SQL Server Reporting Services (SSRS) Integrated Mode When SQL Server 2012 Reporting Services is integrated with SharePoint, you can use powerful SharePoint collaboration and centralized document management features for SQL Server 2012 Reporting Services content. Reports are stored in SharePoint document libraries, alongside other reports such as Excel Services files. SharePoint permissions can be used to control access to Reporting Services content, and people are able to start Report Designer, Model Designer, and Report Builder within a document library. Learn more about Reporting Services Report Server. No No Yes
Timeline Slicer A timeline slicer is a control that can be added to a dashboard created by using Excel. A timeline control enables people to view information for a particular period of time. Learn more about Business Intelligence in Excel Services. No No Yes
Visio Services Visio Services is a service application that lets users share and view Microsoft Visio Drawing (*.vsdx) and Visio 2010 Web drawing (*.vdw) files. Learn more about Visio Services. No No Yes
Search
Advanced Content Processing Not available to SharePoint Online customers. To improve SharePoint Server 2013 search relevance, the document parsing functionality in the content processing component analyzes both the structure and content of documents. Documents parsers extract useful metadata and remove redundant information. For example, parsers extract heading and subheadings from Word documents, and titles, dates, and authors from slides in PowerPoint presentations. For HTML content, redundant generic information such as menus, headers, and footers are removed from document summaries in the search results. Learn more about search improvements. Yes Yes Yes
Content Search Web Part Not available to SharePoint Online customers. The Content Search Web Part is a SharePoint Server 2013 feature that displays content that was crawled and added to an organization's search index. It is a very powerful and versatile Web Part, especially when it is used in combination with managed navigation and category pages. The Content Search Web Part allows you to select a result source. This makes it very easy to specify which content should be searched. You can also use Keyword Query Language to add more filters and search terms to the query in this Web Part. Learn more about Content Search Web Part. No No Yes
Continuous crawl Not available to SharePoint Online customers. Configure crawl schedules for SharePoint Server 2013 content sources so that crawls are performed continuously. This option eliminates the need to schedule incremental crawls and automatically starts crawls as necessary to keep the search index fresh. Learn more about managing continuous crawl. Yes Yes Yes
Custom entity extraction Not available to SharePoint Online customers. SharePoint Server 2013 administrators can create and deploy custom entity extraction dictionaries to configure the search system to look for specific words or phrases (entities) in unstructured content. The extracted entities are stored in separate managed properties, and you can use them to improve your organization's search experience, for example by creating refiners. Learn more about creating and deploying custom entity extractors. No No Yes
Deep links The search system automatically creates links directly to sub-sections of a main page that is frequently visited. These links are called "deep links". No Yes Yes
Event-based relevancy The search system determines the relevance of search results in part by how content is connected, how often an item appears in search results, and which search results people click. The analytics component tracks and analyzes this information and uses it to continuously improve relevance. Learn more about analytics processing. No Yes Yes
Expertise Search In SharePoint, it is easier to find people with specific skills or expertise in the People Search vertical. The search results are based on information such as the metadata users have entered about themselves on their personal sites, and information from the content that they have created. Yes Yes Yes
Extensible content processing Not available to SharePoint Online customers. Developers can call out to an external content enrichment web service to change the managed properties of crawled items before they are indexed. The ability to change managed properties for items during content processing is helpful for tasks such as data cleansing, entity extraction, classification, and tagging. Learn more about custom content processing. No No Yes
Graphical refiners The new graphical refiners provide a more visual way of filtering search results. Learn more about configuring the Refinement Web Part. No Yes Yes
Hybrid search In a hybrid deployment of SharePoint, search result content can come from both SharePoint Online and SharePoint Server 2013 on-premise sites. Yes Yes Yes
Managed navigation Managed navigation lets organizations define and maintain the navigation on a site by using term sets. Managed navigation supplements the existing SharePoint navigation that is based on site structure. The managed navigation structure is created by adding terms to term sets in the Term Store Management tool. Learn more about managed navigation. No Yes Yes
On-premises search index The search index is stored in the on-premises SharePoint Server 2013 environment and is not available to SharePoint Online customers. Learn more about search schema in SharePoint Server 2013. N/A N/A N/A
Phonetic name matching Improved phonetic name matching finds search results for similar sounding names (is it John or Jon?). Yes Yes Yes
Query rules—Add promoted results In a query rule, specify conditions and correlated actions. When a query meets the conditions in a query rule, the search system performs the actions specified in the rule. The "Add promoted results" action lets you promote individual results so that they appear at the top of search results. No Yes Yes
Query rules—advanced actions In this query rule, specify conditions and correlated actions. When a query meets the conditions in a query rule, the search system performs the actions specified in the rule. No No Yes
Query spelling correction Edit exclusions and inclusions lists to decide which queries the search results page should display alternative query spellings for. This features is often called "Did you mean?". Learn more about query spelling correction. Yes Yes Yes
Query suggestions Query suggestions are suggested phrases that users have already searched for. The suggestions appear in a list below the Search Box as a user types a query. Query suggestions are generated automatically, and phrases can be added to the system as "always" or "never" suggest. No Yes Yes
Query throttling If query resources become limited, you can decide how queries should be prioritized based on the client type the queries are coming from. No Yes Yes
Quick preview Users can rest the pointer over a search result to preview and interact with the document or site content in the hover panel to the right of the result. The preview shows rich metadata and has deep links to the main sections of the document or site. Yes Yes Yes
Recommendations The search system looks for patterns in how users interact with content items, sites and people, and can use the information to display recommendations on a site, for example, "People who viewed this also viewed". Learn more about configuring recommendations and usage event types in SharePoint Server 2013. No Yes Yes
Refiners Not available to SharePoint Online customers. Refiners categorize the top documents in SharePoint Server 2013 search results into groups that lets users filter the search results. Learn more about the Refinement Web Part. Yes Yes Yes
RESTful Query API/Query OM Developers can create .NET code to access the public search object model. This includes search administration operations in addition to submitting search queries. To interact with the service side object model, the .NET code must run on a web server in the farm. A sub-set of the object mode can be accessed from a remote computer by using the Client Side Object Model (CSOM). Features of the Client Side Object model (CSOM) can be accessed by using a REST-based web service or oData. This allows developers to submit queries to the SharePoint Server 2013 farm using popular web development tools. Yes Yes Yes
Result sources Create and use a result source to specify a location from which to obtain search results and to specify the protocol for getting those results. Result sources replace scopes and federated locations. Learn more about result sources. Yes Yes Yes
Search connector framework SharePoint Server 2013 provides default connectors (protocol handlers) for the most popular protocols, which can be used to crawl and index content. To crawl content that requires a non-default connector, your organization can purchase and install third-party connectors or build your own custom connectors. Learn more about default connectors in SharePoint Server 2013. No No No
Search results sorting Users can choose to sort search results by different criteria, for example relevance, freshness, and social distance (people names). Yes Yes Yes
Search vertical: "Conversations" A targeted search experience that displays results that are custom filtered and formatted for conversations content. Learn more about configuring the Search Navigation Web Part. No Yes Yes
Search vertical: "People" A targeted search experience that displays results that are custom filtered and formatted for people content. The search results are based on metadata about the people in an organization and on the content those people have produced. Learn more about configuring the Search Navigation Web Part. No Yes Yes
Search vertical: "Video" A targeted search experience that displays results that are custom filtered and formatted for video content. Learn more about configuring the Search Navigation Web Part. No No Yes
Tunable Relevancy The search system has strong built-in relevant that will automatically improve over time. In addition, many tools can be used to manually tune the relevancy to match content and to create specific search experiences for an organization. Learn more about managing search relevance in SharePoint Server 2013. No No No
Sites
Change the look You can quickly customize your team site so that it's easier to use and reflects your professional style and brand. You can change the background image, colors, site layout and fonts with just a few clicks. Learn more about customizing team sites. Yes Yes Yes
Connections to Microsoft Office Clients By using the Connect to Office commands, you can conveniently access commonly used libraries from a Microsoft Office program. Learn more about Connect to Office commands. Yes Yes Yes
Cross Browser Support SharePoint Online supports several commonly used web browsers, including the latest three versions of Internet Explorer, and the latest versions of Google Chrome, Mozilla Firefox, and Apple Safari. Learn more about planning browser support. Yes Yes Yes
Custom Managed Paths By defining managed paths, you can specify which paths in the URL namespace of a Web application are used for site collections. You can specify that one or more site collections exists at a specified path. This can be a convenient method of consolidating multiple site access to users in various departments. Learn more about managed paths. Yes Yes Yes
Governance An important but often invisible part of any site is its governance model—the set of policies, roles, responsibilities, and processes that you establish to determine how the people in your group use SharePoint. Learn more about best practices for creating and managing team sites. Yes Yes Yes
Large List Scalability and Management By planning and using key list and library features, you can ensure that you and other users quickly find information without adversely affecting the performance of the rest of your site. Learn more about managing lists and libraries. Yes Yes Yes
Mobile Connectivity You can access SharePoint sites on the go from an Internet-connected mobile phone or tablet. You can view and update documents, lists, and other site content and collaborate with colleagues, all from your mobile device. Learn more about using a mobile device to work with SharePoint Online sites. Yes Yes Yes
Multi-Lingual User Interface Use the Multi-Lingual User Interface (MUI) feature to create sites in different languages that the default language for your SharePoint installation. Learn more about multilingual features. Yes Yes Yes
My Tasks The My Tasks page on your personal site enables you to see all of the tasks that you are working on in one central location. Tasks are pulled from your personal site, project and team sites, Microsoft Outlook, and Project Web App. Learn more about working with tasks on your personal site. Yes Yes Yes
OOTB Web Parts A Web Part is a modular unit of information that forms the basic building block of a Web Part page. Yes Yes Yes
Permissions Management SharePoint permissions are flexible and configurable enough for an organization to manage permissions at whatever level of detail that is needed. Three key security elements work together to control use access to sites and site content: permissions inheritance, permission levels (sometimes known as SharePoint roles), and SharePoint groups (or SharePoint security groups). Learn more about controlling user access with permissions. Yes Yes Yes
Project functionality for team sites Add project functionality to your team site to help plan and track a project. This functionality includes a task list with a visual timeline, a calendar, and the Project Summary web part. Learn more about project sites. Yes Yes Yes
Project site template Use the project site template to create a site where you can capture tasks and assign them to people in your organization, store and manage project-related documentation, and track project team events on a common calendar. Learn more about project sites. Yes Yes Yes
Project Summary web part The Project Summary web part provides a visual timeline for a task list, and information about late and upcoming tasks and events. By default, it is included on the Home page for a project site, and it can be added to any other site that includes a task list. Learn more about the Project Summary web part. Yes Yes Yes
Project workspace Existing project workspace sites are upgraded in this version to look similar to newly-created project and team sites that include the project functionality. Upgraded project workspace sites can be used to capture tasks and assign them to people in your organization, store and mange project-related documentation, and track project team events on a common calendar. Learn more about project sites. Yes Yes Yes
Public Website (SPO) Your Office 365 account includes a public website that you can use to create a professional online presence for your organization. Learn more about Public Website. N/A N/A N/A
SharePoint Lists A list is a collection of data that you can share with team members and other site users. For example, you can create a sign-up sheet for an event or track team events on a calendar by using a list. You can use several ready-to-use lists and list templates, which provide a good starting point for organizing list items. Learn more about SharePoint lists. Yes Yes Yes
SharePoint Ribbon Similar to the interface in products such as Microsoft Word, the ribbon is a toolbar that appears across the top of each SharePoint page and displays the most commonly-used controls and commands. The controls that appear on the ribbon vary according to the page you are viewing and the context. Yes Yes Yes
Task list Task lists are used for managing work in a hierarchical way, with summary tasks and subtasks appearing in a single list. Tasks can have start and end dates, can be assigned to people in your organization, and can be included in an illustrated timeline. Learn more about adding tasks to your project. Yes Yes Yes
Team Site: Drag & Drop You can upload documents, pictures, and other types of files to your site by dragging them from your computer to a library on your site, such as Documents or your SkyDrive Pro library. Yes Yes Yes
Team Site: Notebook When you create a team site, a OneNote 2013 shared notebook is automatically created as part of the site. You can use this notebook to capture, compile, and share information. (This feature is available only if you have signed up with an Office 365 suite that includes Microsoft Office Web Apps support.) Yes Yes Yes
Team Site: Simplified Access When you share a site, you invite other people to have access to the site. You can share any site in which you have the required permissions. As you set up sharing, you may be able to set permissions for the people you're inviting to the site, depending on your own permissions. Yes Yes Yes
Templates When you create a new site in SharePoint, you start by selecting a site template to base your site on. Site templates contain lists, libraries, pages, and other elements or features that support the needs of an organization. Learn more about customizing your team site. Yes Yes Yes
Themes You can quickly customize your team site so that it's easier to use and reflects your professional style and brand. Themes are a quick and way to apply colors and fonts to sites. Yes Yes Yes
Work Management Service The Work Aggregation Service finds and pulls together tasks from all of your projects, across SharePoint, Outlook, and Project Web App. Learn more about working with tasks on your personal site. Yes Yes Yes
Usage Analytics Web Analytics reports are pre-built reports in SharePoint that use usage data to analyze various aspects of sites and site collections. Yes Yes Yes
Social
Ask Me About The Ask Me About section of your profile lets you list your areas of expertise, presenting yourself as a go-to person for those areas to anyone who visits your profile page. Learn more about SharePoint profiles. No Yes Yes
Blogs Blogs can enable an organization to quickly share information among employees, partners, or customers. People can add insight to a difficult subject area, provide inspiration and guidance, or explain a new guideline or procedure. Yes Yes Yes
Communities Reputation, Badging, and Moderation When you participate in community discussions, you build your reputation as an expert and earn points and badges that reward your contributions. If you're really into it, you can become a moderator and work behind the scenes to makes sure the community thrives. Learn more about moderating a community. No Yes Yes
Community An online community is a virtual place where ideas are discussed and shared. It promotes open communication by fostering discussions among users who both share their expertise and learn from others. Learn more about creating a community. Yes Yes Yes
Company Feed The company feed is an organization's public newsfeed. All posts appear to the company, including those created by people that users might not be following. Learn more about Company Feed. Yes Yes Yes
Follow Users can follow people, documents, sites, and tags to see newsfeed postings associated with people documents, sites, and tags that interest them. Learn more about following in SharePoint. No Yes Yes
Microblogging Microblogging lets users post items of interest in a newsfeed and participate in conversations. Learn more about microblogging. No Yes Yes
Newsfeed A newsfeed is a place to post information and reply to other posts, and to get updates about people and content you're following. You can post to the public newsfeed or to newsfeeds on team sites on which you're a member. Learn more about the SharePoint newsfeed. No Yes Yes
One Click Sharing You can easily share documents and sites with others in your organization, from your SkyDrive Pro and Sites pages, helping promote team collaboration. Learn more about sharing ideas, sites, and content. No Yes Yes
People, Sites, Document Recommendations Your SkyDrive Pro and Sites pages give you suggestions for documents and sites to follow, based on your profile information and newsfeed activity. Learn more about suggested documents to follow. No Yes Yes
Personal Site Each SharePoint Online users has a personal site where data is personalized for them. Personal site includes a Newsfeed, SkyDrive document library, and Sites pages. Learn more about sharing ideas, sites, and content. No Yes Yes
Photos and Presence Exchange Online and Lync Online integration with some Office 365 plans allows users to sync their profile pictures and presence indicator with SharePoint Online. Photos appearing in a person's About Me page are managed by Exchange Online and are no longer managed by using the Microsoft SharePoint Online Administration Center. Yes Yes Yes
Profile Part of a user's profile is fed in from the Office 365 directory service. If an organization sets up Office 365 Directory Synchronization (DirSync), then user profiles will sync with that organization's Active Directory accounts. Learn more about SharePoint profiles. No Yes Yes
Ratings Users can add ratings to their SkyDrive Pro libraries that allow sites visitors to 'Like' a library document or to use a 'star' tool to rate it. Learn more about adding a ratings feature to a library. No Yes Yes
Site Feed A site feed, similar to a newsfeed, is a place on a team site to post information, and reply to other posts. Learn more about posting something to a small group of people. Yes Yes Yes
Skydrive Pro SkyDrive Pro is a service available with SharePoint Online that lets users sync documents to the cloud, and also to their computers. Learn more about SkyDrive Pro. Yes Yes Yes
Tag profiles Tag profiles display information about tags that appear in a newsfeed. Information includes conversations that reference the tag and a list of related tags. Learn more about tags. No Yes Yes
Tasks integrated with Outlook You can synchronize your SharePoint task lists with Exchange so that you can manage and add tasks by using Outlook. No Yes No (seems like a mistake!)
Trending Tags Currently popular #tags references appear in public newsfeed posts. No Yes Yes
Wikis A wiki is a site designed for groups of people to quickly capture and share ideas by creating simple pages and linking them together. Every team site is a wiki, but you can also add a separate wiki page library to a site, or create a large-scale Enterprise wiki as a separate site or site collection. Learn more about creating a wiki. No Yes Yes
Add-Ons
Additional Storage Should you require more storage, it is available at a cost per gigabyte (GB) per month. N/A N/A N/A
App Hosting: Base The add-on is used to buy additional app hosting licenses which provide hosting resources to the Autohosted Apps in SharePoint app catalog. N/A N/A N/A
App Hosting: Per User The add-on is used to buy additional app hosting licenses which provide hosting resources to the Autohosted Apps in SharePoint app catalog. N/A N/A N/A
Azure Provisioned Apps: Access Services Access Services allows business users to quickly create apps that run in Office 365 and store their data in SWL databases on Windows Azure. N/A N/A N/A
Azure Provisioned Apps: Custom Code in Azure Lightweight Web Role (LWR) Provider-hosted apps for SharePoint include components that are deployed and hosted outside the SharePoint farm, usually by a developer, but in some scenarios by the customer. The provider-hosted app for SharePoint interacts with a SharePoint site but also uses resources and services that reside on the remote site. Learn more about hosting options for apps for SharePoint. N/A N/A N/A
Duet Online Duet Online for SharePoint and SAP is a jointly developed product from SAP and Microsoft that enables interoperability between SAP applications and SharePoint Online. Learn more about Duet Online. N/A N/A N/A