Monday, 12 February 2018

How to set search on a specific Document library in SharePoint Online

Applies to SharePoint Online / O365
If you have a requirement for to show search results from a specific Document library, here are the things you can do

Step 1.

Add a Search box
Step 2.

On the Search box > Properties > Send queries to a Custom search result >  Provide the URL >{contexturl}

This is the new result page you will be creating in Step 3

Step 3.

Create a Search result page (any new page) and add a Search result webpart

Step 4.

Search Results Property > Search Criteria > Change Query > You can add the below in query text 

To set the scope to a document library add "Path" and the path to exclude a path use "-Path"

Eg - 

{searchboxquery} Path:  

Step 5.

Run the "Test Query" and confirm the result set 

All done, Hope this helps.

Exclude accounts from the SharePoint online search results

Implemented on SharePoint Online

Business asked me to fix the SharePoint Online search site when it started pulling external users and showing System accounts.

Googled did'nt have much luck, spend hours.

Blogging as it will be usefull to someone. 

The key is use "Search Core Results" webpart and then fine tune the query to bring in results and filter and show.

Thursday, 15 September 2016

SharePoint Online restricting Everyone and All users Sharing on people picker

I been asked to restring Sharing for the below from tenant level as there was a business reason to restrict users accidentally sharing site to all users or everyone, the below is the script i ran

Open SharePoint Online Management Shell

Run the below command to get it connected -


Connect-SPOService -Url   -Credential

Once connected run the below code, appropriate for your need

Hide “All Users” form the Sharing window or People picker for entire SharePoint Online
        Set-SPOTenant -ShowAllUsersClaim $false

Hide  “Everyone” form the Sharing window or People picker for entire SharePoint Online
        Set-SPOTenant -ShowEveryoneClaim $false

Hide “Everyone Except External Users” in people picker (while sharing) for entire SharePoint Online
        Set-SPOTenant -ShowEveryoneExceptExternalUsersClaim $false

Hope this helps...

Tuesday, 8 September 2015

SharePoint 2013 Powershell Script for getting all Site collection Users

I had to find all the users of a site collection and write to a file,  to add to another site. I was looking for one but couldn't find any, this script will dump all the users into a file with a semicolumn so it will be a straight copy paste.


Add-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) > $null
$SiteCollectionURL = "http://You site/collection name"
$site = new-object Microsoft.SharePoint.SPSite($SiteCollectionURL)
$web = $site.openweb()
$siteUsers = $web.SiteUsers

foreach($user in $siteUsers)

Write-Host "Site Collection URL:", $SiteCollectionURL
if($user.IsSiteAdmin -eq $true)
Write-Host "ADMIN: ", $user.LoginName 

  <# This will append all users on to a Text file 
  Add-Content c:\userlist.txt  $user.LoginName -Append #>

  <# This will append all users on to a Text file with no newline
  $user.LoginName | Out-File c:\userlist.txt   -nonewline #>

  <# Another way to output the file
  Write-output $user.LoginName  | Out-File c:\myfile.txt -Append #>

  <# This will add all the user on a Single line with a semicolumn so that you can directly reuse this with no formatting #>

  $alluserlist +=  $user.LoginName + ";"

<# Showing the set of userd and writing the users to a txt file #>

  Write-Host $alluserlist
  []::WriteAllText("C:\io.txt", $alluserlist)

Thursday, 30 July 2015

Sorry we can't seem to connect to the sharepoint store

For those who are desperate to fix the SharePoint 2013 SharePoint Store issue, read on -

I had the same issue and i followed the article on the msdn to set up the store, all services started , configured the service application, set up the DNS however still SharePoint store saying "Sorry, we can't seem to connect the SharePoint store, Try again in a bit" .

If you are in the same state and if you are sure you have done everything else then start suspecting the proxy server. In my case the request which was going out from the SharePoint webfront end server was getting denied by the proxy server.

I took a fiddler trace and it started showing, 401 http error stating response header is 401 Unauthorized Header -

To prove and scope this again, give a simple test, Add a RSS webpart and configure an RSS feed on your SharePoint site and see if it is bringing in any results, if you are getting proxy errors then scope the problem more towards proxy server.

I did the same and i got the below error on my RSS webpart -

To resolve the proxy error I did the below things -

1) Add a proxy rule in the Proxy server (Your Server team should help you here) to allow the SharePoint webfront end servers to access Internet unauthenticated -

I added the below rule, this article will help you in configuring -
Proxy Configuration

Configure ISA/TMG to allow unauthenticated traffic to the Internet. Just add a rule which allows the SharePoint frontend server to navigate to the Internet (network External) over port 80.  Rule settings:
Action: Allow

Protocols: HTTP (80)

From / Listener: hostname of your frontend server

To: External (Internet)

Once this is done checked the RSS feed webpart, for me it was still not working.

 So went to the Sharepoint 2013 webfront end servers, Browser > Internet options > Connections > Lan Settings > Unchecked all options to ensure the requests are not going through any proxies on both the servers.

That made it work, the RSS Feed webpart started working now.
I checked the SharePoint store, viola !! it also started working !!

Note: Please make sure you access the SharePoint store from the Site collection level and not from Central Admin as it always gives you error.

Wednesday, 15 October 2014

SharePoint 2010 Menu Customisation

Here is an awesome menu customisation for SharePoint 2010. I used the Css to make it look like on the screenshot, i have uploaded the Css and the image file which you can download.

This post is basically an excerpt from the blog , i am reposting it. Link

Sometimes it’s the small details that matters most and makes the difference. This post is about how to customize the look and feel for the global navigation, one important element in the SharePoint interface. The navigation control renders a fairly deep HTML structure with a lot of classes to keep in mind when you need to set your branding on the top of it. Recently I built an Intranet branding where the agency had the desire to include a small arrow for selected links in the navigation. This CSS do also take care of drop downs, in the case you are using that. I hope this could be useful for you if you need to include graphics, like this arrow in the global navigation.