Archive

Latest Posts

How to Disable a Dropdown in InfoPath when Empty

At one point a client asked me to disable a dropdown field in an InfoPath form when that field was empty. Unfortunately this isn’t as easy as it sounds. Here’s my rather roundabout way of solving the problem, which works, but isn’t pretty.     You need to start by creating a second (companion) field, …

Read on

SP.Context Execution Order

We’ve hit a number of problems recently when using JSOM in SharePoint Online. Often when we try to execute a query we get strange errors such as “b is undefined”. It all relates to the SharePoint libraries we need not being available to us when we try to execute the commands. After some trial and …

Read on

How to Filter a SharePoint Date Column by Range

I often require the need to create a date range (or at least an open-ended start or end date) filter in a SharePoint view. However, I can never remember what format the date filter is in (days first, or is it months first?). That’s why I made this blog post, so I can remind myself …

Read on

SharePoint JavaScript Working with Hyperlink Fields

When using JSOM to retrieve SharePoint items (and their columns) getting a value is usually pretty straightforward. The following should look familiar: itemVariable.get_item(‘abc’) where abc is the internal name of the column. (Remember the good old _x0020_ for spaces). But if you try to do the same on a Hyperlink column you will be returned …

Read on

JavaScript that Waits for the SharePoint API’s to be Ready

I’ve run into this countless times in SharePoint where I need the browser DOM to be ready, but also at the same time, SharePoint isn’t yet ready to perform operations against its APIs. The problem with using something like jQuery’s ready method is that will only get you a browser DOM that is ready, but …

Read on

Stuck in Office 365&’s subscription & Reactivate account loop

I had a user who’s install of Office from Office 365 was complaining it had a problem and needed to be Reactivated. Every time an Office program was opened it would ask the user to go to their account. No matter how many times I logged into the users account or clicked Reactivate (which takes …

Read on

How to Determine Which SharePoint Users Have a Profile Picture

I recently needed a means of getting a list of all users who had a profile picture associated with their SharePoint account (well, the client was actually more interested in knowing who didn’t have a profile picture, but this result below worked for them). Below is a simple PowerShell script for being able to get …

Read on

Unable to Delete Search Service Application Databases

A while back I was working on a customer’s broken SharePoint farm (and trust me, this was not a healthy beast), and I ran into a situation where I couldn’t delete the Search Service Application (though I resolved that separately), and subsequently the associated databases. The databases were a huge PITA (Pain In The Arse) …

Read on