SPO– Broken list view when filtered on choice column value with an apostrophe

OK – first blog post in literally years, so bear with me!

I came across this issue in SharePoint Online last week, and I was able to reproduce it in 2 tenants.  Microsoft support were also able to reproduce it in a 3rd tenant.

Note: This issue seems to only affect lists / libraries created before approx. late August 2016 – it does not occur for a list / library created after that time.

The Scenario

You have a list or library with a choice column, where one or more of the choices contain an apostrophe.

In the example below, I created a column named ‘choice’, with a type of Choice (imagination isn’t my strong point).

I entered a single choice value of “Mother’s day”.


A view on the list / library is configured to to show only items where the choice column value is one that contains an apostrophe.


Note: I used ‘is equal to’ – but ‘contains’ shows the same behaviour.


The Behaviour

One or more items in the list / library are configured with a value for the choice column that contains an apostrophe.

No items are shown in the view – despite there being valid items for that view.


Note: Other views filtering on the same choice column, but for values without apostrophes, work fine – e.g. “Easter”.

What Microsoft said

I raised a support case, and spoke at length with a very helpful engineer.

We determined that the issue was not reproducible on a newly created list / library in his test tenant, or in my tenant.

We then saved my list (which was created in early 2016) as a template (including content) – and deployed a new list from that template.

Using the new list (from template) we could still reproduce the issue.

The engineer then configured an existing list (created in early August 2016) in his tenant, in which he was able to reproduce the issue.

This confirmed that the issue was resolved around the end of August 2016, but pre-existing lists would continue to have the issue – even if a choice column was added now.

We also noted that it only affects choice columns, and only values in them with apostrophes – e.g. a text column is fine, and a choice column value without an apostrophe is also fine.

The workaround

I took the easy way out – I simply removed the apostrophes from the choices.

An alternative would be to create a new list / library and migrate items to it.

Note: Just creating a new choice column in the existing list / library isn’t enough – you have to create a new list / library.

Posted in Office 365, SharePoint | Tagged , , | Leave a comment

2012 in review

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

600 people reached the top of Mt. Everest in 2012. This blog got about 3,800 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 6 years to get that many views.

Click here to see the complete report.

Posted in Uncategorized | Leave a comment

2011 in review

The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.

Here’s an excerpt:

A New York City subway train holds 1,200 people. This blog was viewed about 4,000 times in 2011. If it were a NYC subway train, it would take about 3 trips to carry that many people.

Click here to see the complete report.

Posted in Uncategorized | Leave a comment

Turning off Social features in SharePoint 2010

If for whatever reason you want to prevent your users from using the social features in SharePoint 2010, here is how to do it.

Deactivate Farm level feature

Firstly, in Central Admin, you need to deactivate the Farm level feature called ‘Social Tags and Note Board Ribbon Controls’, as referred to on Technet.


Note that as this is a farm level feature, its turning this off globally – you don’t have the option of doing this at a web app level, for example.

Having deactivated that feature, you should find that the ‘I Like It’ and ‘Tags & Notes’ controls, normally found on the top right of pages, like this…


…have now been removed:


At this point, the user will still see the ‘Tags and Notes’ tab in their profiles, like this:



Removing ‘Tags and Notes’ tab from MySites

There doesn’t appear to be a clean way of removing this, other than removing the user permission for ‘Use Social Features’ in the User Profile Service Application, as follows.

[Update 28/7/2011] Based on feedback from a couple of people, here is how to remove the ‘Tags and Notes’ tab:

Browse to the MySite Host – in my case, the URL is http://mysite/_layouts/settings.aspx

(You can check you are in the right place by looking for the ‘My Site Host’) –


In the ‘Look and Feel’ section, click ‘Quick launch’


Click the Edit button next to the ‘Tags and Notes’ item



Click ‘Delete’


Click ‘OK’

You will now find that the ‘Tags and Notes’ tab has been removed for all users:


Removing ‘Use Social Features’ permission

As a final step (and this is not strictly necessary if you have followed the above steps, but for completeness…)

In Central Admin, click ‘Manage service applications’, click your User Profile Service Application, and then in the People section, click ‘Manage User Permissions’:



The permission to untick is ‘Use Social Features’ – note that for a default install you will need to untick it twice – once for Authenticated Users and then again for All Authenticated Users – then click OK.

Users will then see a 403 – Forbidden type error if they browsed to the Tags and Notes URL /_layouts/thoughts.aspx (which they would have to, seeing as the link has been removed)


Posted in IT, SharePoint | Tagged , , | 6 Comments

Unable to sign in to Windows Live Messenger–Error 81000490


Ok, so I’ve been getting the above error on my Windows7 netbook for a while now.  The official reason for the error is ‘the service may be temporarily unavailable’.

I found that I could log in fine on the netbook using a different Live account, and the problem account worked fine on a desktop PC, which pointed to the problem being somewhere in the Windows profile on the netbook, and not a service problem.

I tried an uninstall and reinstall of WLM, which made no difference.

I then used the ‘forget me’ option on the login screen – this also made no difference.

I then found that for each Live account, there is a folder at the following location:

C:\Users\<username>\AppData\Local\Microsoft\Windows Live\Contacts

The folder names are the email address for the related Windows Live accounts.

I simply deleted the folder for the problem account, at which point I was able to login to WLM without a problem.

(If you get an error when trying to delete the folder, make sure that WLM is not running, then if you still get an error, check in Task Manager for the wlcomm.exe process, and end it if present.)

Posted in IT, Windows7 | Tagged , | 34 Comments

ActiveSync via IAG – # Character in Password Not Allowed??

Came across a strange one last week.  IAG 2007 with SP2, ActiveSync trunk, using an Active Directory Repository.

Working fine for pretty much everyone, except one user, who is getting constant prompts from the Windows Mobile device to ‘correct your password’.

IAG is showing an authentication failure, and is logging the correct username and domain, which only really leaves the password.

Further investigation determined that the user had a # symbol in their password.  When the password was changed to one without a #, ActiveSync started working fine.

I’ve since tested a non-IAG ActiveSync installation with a password including a #, and it works fine, which suggests that IAG is the problem.

I’ve now got a ticket logged with our IAG vendor, and I will post again here when I’ve worked through the issue with them.

Posted in Exchange, IAG, IT, Windows Mobile | Tagged , , | 1 Comment

3G Commuter Forums now live

I’ve been thinking about it for a while now, and last night I finally got around to creating the 3G Commuter Forums.

Its all a bit empty at the moment, but hopefully it will start getting some traffic soon.

If you use a 3G dongle, or a laptop with built in 3G, please do sign up, comments and suggestions for new forums, etc, are welcome.

Anyone fancy designing me a logo for the site?

Posted in 3G, IT, Mobile Broadband | Tagged , , | Leave a comment