Oct 21 2019 07:13 PM
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?
Oct 22 2019 10:11 AM
Oct 22 2019 11:00 PM
@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?
Oct 22 2019 11:48 PM
Oct 23 2019 04:30 PM
@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?
Oct 23 2019 05:22 PM
Oct 23 2019 07:42 PM
@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.
Oct 23 2019 07:49 PM
@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.