Filtering by Person/Group does not return results

%3CLINGO-SUB%20id%3D%22lingo-sub-925756%22%20slang%3D%22en-US%22%3EFiltering%20by%20Person%2FGroup%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-925756%22%20slang%3D%22en-US%22%3E%3CP%3EI%20clicked%20on%20%22Person%2FGroup%22%20column%20and%20manually%20typed%20in%20a%20person's%20name.%20I%20waited%20for%20the%20results%20to%20appear%20and%20then%20clicked%20on%20the%20name%20I%20wanted.%26nbsp%3B%20I%20can%20see%20in%20the%20header%20that%201%20value%20has%20been%20selected.%26nbsp%3B%20I%20then%20clicked%20%22Apply%22%20and%20was%20returned%20to%20the%20list%20with%20zero%20results.%26nbsp%3B%20I%20clicked%20on%20the%20%22Person%2FGroup%22%20column%20again%20and%20then%20scrolled%20down%20to%20find%20the%20name%20I%20wanted.%26nbsp%3B%20I%20ticked%20the%20box%20and%20can%20now%20see%20in%20the%20header%20that%202%20values%20have%20been%20selected.%26nbsp%3B%20I%20clicked%20%22Apply%22%20and%20now%20can%20see%20the%20list%20filtered%20by%20the%20name%20I%20had%20just%20selected.%26nbsp%3B%20Why%20is%20the%20first%20method%20or%20typing%20in%20name%20and%20selecting%20from%20list%20not%20working%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-925756%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-927450%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20Person%2FGroup%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927450%22%20slang%3D%22en-US%22%3ESounds%20like%20you%20possibly%20have%202%20entries%20for%20the%20same%20user%20in%20your%20directory%3F%20Possibly%20a%20guest%20user%20or%20something%20that%20you%20may%20be%20selecting%20when%20searching%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-932799%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20Person%2FGroup%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-932799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BI%20randomly%20selected%203%20different%20users%2C%20with%20the%20same%20result.%26nbsp%3B%20I%20cannot%20confirm%20100%25%20if%20they%20have%20guest%20accounts%20too%2C%20but%20I%20do%20doubt%20it...%20how%20do%20I%20check%20this%20or%20what%20else%20can%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-933268%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20Person%2FGroup%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-933268%22%20slang%3D%22en-US%22%3EDo%20you%20have%20your%20column%20settings%20to%20allow%20all%20users%20or%20some%20other%20option%20for%20available%20users%20you%20can%20use%20to%20populate%20the%20list%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-940317%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20Person%2FGroup%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-940317%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BAll%20I%20did%20was%20create%20a%20new%20column%2C%20select%20it%20as%20Person%2FGroup%20type%20and%20then%20at%20the%20option%20of%20%22Choose%20from%22%2C%20I%20checked%20%22All%20Users%22.%26nbsp%3B%20The%20other%20option%20was%20%22SharePoint%20Group%22.%3C%2FP%3E%3CP%3ENote%20that%20my%20list%20has%20about%204000%20rows.%3C%2FP%3E%3CP%3EI%20went%20into%20a%20test%20list%20of%20about%2020%20rows%20and%20did%20the%20same%20thing%20on%20the%20Person%2FGroup%20column.%26nbsp%3B%20Method%201%20of%20type%20name%20and%20select%2C%20worked!%26nbsp%3B%20Could%20this%20be%20related%20to%20the%20size%20of%20the%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-940907%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20Person%2FGroup%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-940907%22%20slang%3D%22en-US%22%3EDon't%20think%20so%20I%20have%20a%20list%20that's%20got%20over%204000%20items%20and%20a%20person%20column%20that%20is%20filtering%20just%20fine.%20I'm%20wanting%20to%20lean%20towards%20some%20data%20issues%2C%20but%20I%20don't%20see%20how%20that%20would%20be%20since%20it%20kind%20of%20forces%20you%20to%20have%20proper%20data%20in%20the%20list%2C%20at%20least%20I%20think%20it%20does.%20Maybe%20export%20to%20Excel%20the%20list%20and%20check%20the%20column%20for%20some%20odd%20data%20in%20that%20column%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-941631%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20by%20Person%2FGroup%20does%20not%20return%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-941631%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BI%20exported%20to%20Excel%20and%20eyeballed%20the%20values%20-%20they%20all%20look%20to%20be%20valid%20addresses%20with%20%40abc.com.%26nbsp%3B%20There%20are%20some%20rows%20which%20are%20blank%2C%20which%20is%20expected%20as%20this%20is%20not%20a%20mandatory%20field.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I clicked on "Person/Group" column and manually typed in a person's name. I waited for the results to appear and then clicked on the name I wanted.  I can see in the header that 1 value has been selected.  I then clicked "Apply" and was returned to the list with zero results.  I clicked on the "Person/Group" column again and then scrolled down to find the name I wanted.  I ticked the box and can now see in the header that 2 values have been selected.  I clicked "Apply" and now can see the list filtered by the name I had just selected.  Why is the first method or typing in name and selecting from list not working?

7 Replies
Highlighted
Sounds like you possibly have 2 entries for the same user in your directory? Possibly a guest user or something that you may be selecting when searching?
Highlighted

@Chris Webb I randomly selected 3 different users, with the same result.  I cannot confirm 100% if they have guest accounts too, but I do doubt it... how do I check this or what else can I do?

Highlighted
Do you have your column settings to allow all users or some other option for available users you can use to populate the list?
Highlighted

@Chris Webb All I did was create a new column, select it as Person/Group type and then at the option of "Choose from", I checked "All Users".  The other option was "SharePoint Group".

Note that my list has about 4000 rows.

I went into a test list of about 20 rows and did the same thing on the Person/Group column.  Method 1 of type name and select, worked!  Could this be related to the size of the list?

Highlighted
Don't think so I have a list that's got over 4000 items and a person column that is filtering just fine. I'm wanting to lean towards some data issues, but I don't see how that would be since it kind of forces you to have proper data in the list, at least I think it does. Maybe export to Excel the list and check the column for some odd data in that column?
Highlighted

@Chris Webb I exported to Excel and eyeballed the values - they all look to be valid addresses with @abc.com.  There are some rows which are blank, which is expected as this is not a mandatory field. 

Highlighted

@Chris Webb Oh! I found something: my column is Person/Group Type and I chose to display the work email ID, i.e. "Mei.tan@abc.com" instead of "Tan, Mei".  When I filtered and selected my name from the results list, I see that "Tan, Mei" is ticked but "Mei.tan@abc.com" is not ticked.  This is why the filter returned zero results!  How do I work around this?  I must have the email address displayed to ensure people are selecting the correct person since it is possible for duplicates of Last Name, First Name.