Sharepoint: Site owners with full control get access denied error when trying to create a subsite

Published on

A site owner or user with full control should / would normally be able to create a sub site. However sometimes we get calls where by a site owner cannot create a sub site, when they submit the create new site form they get an access denied page display. If you are getting this error … Continue reading Sharepoint: Site owners with full control get access denied error when trying to create a subsite

Sharepoint online – Sharepoint client browser

Published on

A great free tool that gives you a good insight into you SharePoint online environment http://spcb.codeplex.com Why use this tool? Get insight in your site collection structure Find hidden lists, items or documents Discover artifact properties Easily start PowerShell, via context menu, and run (scripted) queries against your remote site collection Support for both SharePoint … Continue reading Sharepoint online – Sharepoint client browser

Sharepoint 2013: Missing search results in search results webpart compared to result source

Published on

In SharePoint 2013 / SharePoint online you may come across a weird thing where: – You create a result source & verify the results & all appear correct – Configure a search results webpart to use your new result source but you see numerous results missing This is typically happening because by default the search … Continue reading Sharepoint 2013: Missing search results in search results webpart compared to result source

Calculated columns: Using [Today] in a Sharepoint calculated column

Published on

When using [Today] in a formula / calculated column in SharePoint you get the following error: “Calculated columns cannot contain volatile functions like Today and Me” For SharePoint 2010 / SharePoint 2013 / SharePoint Online you can use the Today() function eg. =TODAY()+365   =IF(AND([Date Ordered]<Today()-5, OR([Purchase Status]=”SOLD”,[Purchase Status]=”NOT SOLD”,[Purchase Status]=”ITEM NEVER DELIVERED”,[Purchase Status]=”NO STOCK … Continue reading Calculated columns: Using [Today] in a Sharepoint calculated column

Sharepoint: Open content from CSWP in Office web apps

Published on

When surfacing content using the CSWP it always opens document in the client application instead of the web apps regardless of the configuration. There is a managed property called ‘ServerRedirectedURL’ which provides the correct URL to open documents in the relevant web app. The trouble is that if you users upload non office documents the … Continue reading Sharepoint: Open content from CSWP in Office web apps

O365 Sharepoint: How to get the GUID of a site

Published on

Browse to your site eg. https://yourdomain.sharepoint.com/sites/yoursite/yoursubsite/ Then append _api/web So your complete URL looks like: https://yourdomain.sharepoint.com/sites/yoursite/yoursubsite/_api/web Now look for:

O365 – Querying office graph

Published on

Graph Query Language (GQL) is a preliminary query language designed to query the Office graph via the SharePoint Online Search REST API. By using GQL, you can query the Office graph to get items for an actor that satisfies a particular filter. https://msdn.microsoft.com/en-us/office/office365/howto/query-Office-graph-using-gql-with-search-rest-api?f=255&MSPPError=-2147217396

O365 useful troubleshooting tools

Published on

O365 health readiness & connectivity checks (For end users to run from their PCs) – www.aka.ms/checkmypc Directory sync troubleshooter (Needs to be run from dir sync server by an admin) – www.aka.ms/dsup The above tools are available from the O365 admin center along with some other tools https://portal.office.com/Admin/Default.aspx#ToolsPage

O365: Display content in a accordian in O365

Published on

This JSLink sample will show how to change rendering logic for the whole List View. This sample will read the Title and Description fields’ values and render the fields in an accordion style view. https://code.msdn.microsoft.com/office/Client-side-rendering-code-ccdb2a0e

O365: Tabbed forms in O365

Published on

This JSLink sample allows you to use JQuery Tabs within your SharePoint List Forms. https://code.msdn.microsoft.com/office/Client-side-rendering-code-b2eedf92 I had a bit of trouble getting this to work so I had to: 1) I think #4 is a typo 2) Upload my JS file to the master page gallery as a ‘JavaScript Display Template’ In my case changing … Continue reading O365: Tabbed forms in O365

Sharepoint 2010 Search Refinement Panel: Some refiners tool tips are bank or empty

Published on

Implemented the Sharepoint search refinment panel on a Sharepoint 2010 enterprise search center. The content for this search center was tagged using both standard Sharepoint column types and some managed metadata columns. What I noticed was that when you hover over some of the refiners on the refinement panel the tooltip would display as expected … Continue reading Sharepoint 2010 Search Refinement Panel: Some refiners tool tips are bank or empty

Sharepoint 2010: How to copy a Sharepoint page with all webparts included

Published on

How to copy a Sharepoint page with all webparts included: 1) Open the site in SharePoint Designer 2010 & browse to the ‘Pages’ library 2) Create a ‘Temp’ folder 3) Right click the page you want to copy and select ‘Copy’ 4) ‘Paste’ the page into the ‘Temp’ folder 5) Rename the page & copy … Continue reading Sharepoint 2010: How to copy a Sharepoint page with all webparts included

Sharepoint 2010 – Solution stuck on Retracting

Published on

On our Sharepoint 2010 Dev farm we we’re trying to remove solutions from Central Admin & they were just stuck on ‘retracting’ Turns out the the Sharepoint Timer Service had stopped, start the Sharepoint Timer Service and your solutions should start to retract as expected.

How to format a date field in a CQWP

Published on

To format a date field in a Sharepoint Content Query Webpart (CQWP) you can do the following: 1) Edit your itemstyle.xsl 2) Add a reference to 3) Now you can use the following syntax to format your date 4) Save your itemstyle.xsl & your date should be formatted

Sharepoint 2010: Add top link navigation bar to Enterprise Search Center

Published on

The Enterprise Search Center in Sharepoint 2010 uses the minimal.master masterpage which doesn’t have any navigation meaning that if you dont find the search result you’re looking for you cant easily navigate away from the site. To add the top links navigation bar, edit the masterpage & find: Above the paste in the below code:

Infopath: Repeating Table outputs as one long string with no delimiters

Published on

In an Infopath form I was using a repeating table to collect a random number of external users email addresses. The repeating section worked fine in collecting the email addresses but when you came to do anything with the data they were captured as one long string with out any delimiters. My repeating table was … Continue reading Infopath: Repeating Table outputs as one long string with no delimiters