Monday, 15 March 2021

SharePoint Template Sites


SharePoint look book

Get inspired

Discover the modern experiences you can build with SharePoint in Microsoft 365

Create stunning sites

Reinvent the intranet with solutions for collaboration, communication, engagement, and knowledge management. Today it's simple for any user to create beautiful, fast sites and pages that look great on any device or screen. Get inspired with these designs or add them to your tenant to start building your next stunning site with them.

Monday, 29 June 2020

SharePoint home sites: a landing for your organization on the intelligent intranet

Visionaries driving digital transformation and creating the modern workplace know the intelligent intranet is the heart of a digital workplace.  The intelligent intranet delivers experiences that provide shared content and solutions for collaboration, drives employee engagement and communications, and harnesses collective knowledge by connecting people and content.

Today at the SharePoint Conference, we announced SharePoint home sites, the latest innovation for the intelligent intranet, powered by Microsoft 365.

Introducing SharePoint home sitesIntroducing SharePoint home sites
SharePoint home sites are the landing sites for your organization that bring together news, events, content, conversations and video to deliver an engaging experience that reflects your voice, your priorities, and your brand.  Home sites are built on top of familiar communication sites.

Novartis is a leading global healthcare company committed to reimagining medicine. As part of its focused data and digital transformation, Novartis will launch a new global corporate intranet for its 100,000+ employees. The solution, built with Microsoft certified partner Wizdom, intends to use SharePoint Online and will embrace all relevant functions of Office 365 to fuel its digital ambitions. Novartis is excited to explore the new Home site capabilities, especially the improvements to search, cross-site navigation, organizational news and the mobile front page.” – Philip Martucci, Director Content & Channels, Novartis

Wizdom homesite site designWizdom homesite site design
Home sites are natively responsive, so you can rest assured that every page will be beautiful, fast, and accessible on any device.  Coming later this year, a dedicated home button will allow one touch access to your home site in the SharePoint mobile app.  You can also configure your company logo in the Office 365 navbar to link to your home site. Doing this means your home site will always be one click away in any of the Microsoft 365 web applications.

One touch access to your home site from anywhere in the SharePoint mobile appOne touch access to your home site from anywhere in the SharePoint mobile app
Admins can configure a custom Microsoft 365 theme for their organization so that their company logo, i.e. Contoso Electronics, will take employees back to the home site from many Microsoft 365 web application. Support for larger images and additional file types has recently been added. Learn more here.
Admins can configure a custom Microsoft 365 theme for their organization so that their company logo, i.e. Contoso Electronics, will take employees back to the home site from many Microsoft 365 web application. Support for larger images and additional file types has recently been added. Learn more here.

News can come from many different sites in your organization but often you want to have an "official" or "authoritative" site for organization news. Home sites allow you to balance organization news, which is distinguished with a visual cue, with personalized, relevant content that can be targeted to employees.

Visually highlight news from organizational news sites for employees

Engaging experiences are key to the intelligent intranet and home sites allow you easily embed conversations, video, and content from Microsoft 365 and more so you can connect with the information and activities that matter to you, across all your devices.

It’s easy to embed rich video from Microsoft Stream, conversations from Microsoft Yammer, or other social
Integrated search, powered by artificial intelligence, allows deeply personalized insights to be surfaced to make employees more productive and take advantage of the collective knowledge from your organization both inside and outside of Microsoft 365.

Microsoft search is fully integrated to allow employees Discover answers, insights and take actions in your modern workplace

Robust menu options, such as the recently released megamenu, allow you to create a visually engaging navigation experience that can show multiple levels at the same time.  This enables you to better organize and showcase the related content and sites from across your organization.

The mega-menu allows you to show multiple levels at the same time, no fly-outs needed
Building a great looking home sites shouldn’t have to take months.  With the new organization design for communication sites, you have a great starter to get you going fast.  New page options, like a vertical column, and ever-increasing list of out of the box web parts provide additional design options to meet your needs with less development time.

Once you have built your communication site how you like it, as the admin you can make it a home site with a simple PowerShell command.  That PowerShell command will automate all the essential configurations for you:
  • The site is configured as an official organizational news site.
  • Search scope is set to tenant wide for the home site.
  • Enables one click access from the SharePoint mobile app.
  • Automatically connected to the SharePoint start page.
The SharePoint start page is connected to your home site with the My SharePoint link, and carries your home site branding to allow your employees to transition seamlessly between their “we space” and their “me space” with the “My SharePoint” link.  Having personalized and relevant content is key to the success of the home site and we are making it easy by providing several out-of-box user personalized webparts and the integrated experience with SharePoint start page.

SharePoint home sites empowers you to create beautiful, fast, natively mobile, digital experiences for organizations, divisions or functions with just a few clicks.  To see these technologies in action, watch the SharePoint Conference 2019 keynote, and check out the other posts today to the SharePoint community blog.  We are excited to see what you will create.

Monday, 27 May 2019

Create a SharePoint list from an existing list or from Excel

Lists from lists

You can create a list from all existing lists within any site where you’re an editor.  When the new list is created, the entire list structure is copied, including forms, formatting, and custom metadata columns.   (Content will not be copied.)
L2.jpgCreating a list from other lists
Figure 1 - Creating a list from other lists

Lists from Excel

To create a list from Excel, you can select a table from your most recent Excel files in SharePoint or OneDrive.  You can change the field type of the column if needed, and all your table data will be copied to the new lists.

L6.jpgMapping Excel data to the new list

Multi-geo capabilities for SharePoint and Office 365 Groups

Multi-geo capabilities for SharePoint and Office 365 are designed to meet even the most complex data residency requirements. Today we announced multi-geo capabilities for SharePoint and Office 365 Groups are generally available, which means you can get started right away.

These new multi-geo capabilities allow you to store your SharePoint and Office 365 Groups mailbox/sites data in one or more worldwide locations to satisfy data sovereignty requirements specific to those locations.

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.

SharePoint Template Sites

  SharePoint look book Get inspired Discover the modern experiences you can build with SharePoint in Microsoft 365 https://lookbook.microsof...