Been having intermittent issues in a SharePoint custom list when trying to filter it by one of it’s fields (a person or group field).

In this situation I had a field called ‘User’ which displayed a person. In the standard view this could be filtered fine. However the filter in the edit in datasheet view left out random ‘users’.

Initial investigations into permissions and user account did not produce anything. Then I can across these discussion points and tried changing the field value from ‘name’ to ‘user name’ and the filtering worked as it should.

image