Latest Posts
How to Resolve InfoPath Error “The amount of data that was returned by a data connection….”
I recently ran into a scenario where a client was getting an InfoPath error after a while, when up until this point the form had been working without fail. This can actually be surfaced as one of two error messages. The details of the errors can be seen below. Either… “The amount of …
Read onHow 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 onSP.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 onHow 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 onSharePoint 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 onJavaScript 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 onStuck 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 onHow 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 onHow to Restart the SharePoint Prerequisite Installer after Reboot (when using a mounted ISO)
I must have run into this dozens of times, and I feel like I should finally blog this. Essentially the problem is that you’ve mounted the SharePoint installation CD/DVD as an ISO (because seriously, who uses physical media these days?) and in doing so, when you reboot the ISO is no longer mounted. I’m sure …
Read onUnable 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