Skip to main content

Posts

There is no exclusive SharePoint Online Administrator role!

SharePoint Online is part of O365 tenancy. O365 Global administrators are something like farm administrators in our On-Premise SharePoint deployment. However, global administrators will have complete control over O365 tenancy components such as SPO, Exchange Online, Lync etc. In a typical large enterprise, you would expect SharePoint Administrators who are currently managing on-prem farm to manage SPO as well. With this in mind, I started Googling and I was taken to this specific article which talks about something called SPO Admin. However, when I looked at such a role in O365 Admin console, I could not find any such group. After digging more into this, I got hold of a few articles where authors have clearly mentioned that Global Administrator is SPO Administrator. These two are not segregated. I really wonder what could be the thought process behind this design from MS. A separate role could have resulted in delegating SP specific administration activities to SP team. Hope MS w...

Members group is more powerful in SharePoint 2013!

Some of my colleagues who are end users are familiar with SharePoint as they have been using it since 2007 version. They have the understanding that default Members group in a site collection will have Contribute permission. They are right! However, when they added users to Members group in SharePoint 2013, they had surprise as well as scared for the fact that Members were able to delete List/Document Library. Members Group Yes, in SharePoint 2013, by default Members group is mapped to "Edit" permission. Edit permission is a superset of Contribute permission. With "Edit", users will have permission to create/modify/delete List. Basically, Edit = Contribute + "Manage Lists" permission Just take a note of this before you add users to Members group . You can either change the permission of Members group or create a new group mapping to Contribute permission.

How to add Twitter Widget to SharePoint

Adding Twitter widget to SharePoint page has many useful cases for users such as You can display the feed on specific topic relevant to the site You can display the feed from specific Twitter handle relevant to the site Site users can tweet from within SharePoint Adding the widget is very simple and am going to show these steps. In this example, I want to display the Twitter feed on tag "SharePoint". 1. Login to Twitter 2. Search for a tag. Here I searched for SharePoint. In the search result, click on ellipses and select "Embed this search" Embed this search 3. In Create Widget screen, select your options and click on Create Widget button Create Widget 4. Copy the code. You can save these changes for future use as well Copy the code 5. Back in SharePoint, use Content Editor Web Part to paste the above code and save the page Twitter Feed on SharePoint page That's it! Now your SharePoint site users can see the latest f...

Bug: Column filter does not work with Metadata Navigation

Here is another bug. When you are using Metadata navigation for a Library, column filter does not work! This was tested in SharePoint 2013 on-premise and Online versions. Here are simple steps to reproduce this bug. 1. There is a document library which has Managed Metadata column (Locations) and Metadata navigation is enabled for this library. Library with Metadata Navigation  2. A value ("Bengaluru") is selected from metadata navigation and corresponding filter is applied in the library. Filter from Metadata Navigation 3. Additionally filter is applied on Title column (selected only Desert). However, items are not filtered. Column filter has no effect Note: This works fine in SharePoint 2010.

Embedding Excel in SharePoint is more easy!

Earlier if any Excel need to be embedded in a page, user had to use Excel Web Access Webpart and set the property to point to Excel. Now it has become much simpler and more powerful. Just by copying the URL with adding few parameters and using the URL in  iframe HTML tag is all required to embed it in a page. I'm going to show you this in simple 3 steps. Step 1: Prepare an Excel. I used Microsoft provided Excel template for this demo. I saved this excel directly to a SharePoint library. Excel Workbook Save to Library Step 2: URL manipulation Click on the document to open it within browser. Copy the URL from browser and paste it in a Notepad. Replace the parameter from " action=default " to " action=embedview " and add another parameter wdbipreview=true . So your URL looks something like this (you have changed only highlighted ones). http://[your domain]/sites/[your Site Collection]/_layouts/15/WopiFrame.aspx?sourcedoc=xxxxx&file=Pr...

How to get Search Refiners using REST API

As Title says this blog is about getting SharePoint Search Refiners using REST API. I could not find examples in internet for getting refiners and how to read refiner JSON data. So I did kind of research and trials and finally I was able to get the refiners using REST API. I assume that you are already familiar with fetching search results using REST API. If not, I suggest to read this fantastic post by Chris O'Brien . I have extended the example given in this blog to refiners. Let us first understand how to frame REST query to get refiners. The syntax of the URL is http://[your site]/_api/search/query?querytext='SharePoint'&refiners='[refiner]' To get refiners, refiners keyword should be passed as a parameter along with the actual refiner that we need. Before I show an example, let us first check how XML response would look like if you don't add this keyword. Without Refiner As marked in Red, if we don't pass refiner as parameter, Refinemene...