I am trying to create a view for our agents so that they can see if they created an item or if they have been added to an item. To do this I thought it would be as simple as:

Agent Name (Indexed) 
is equal to


Lead originator (Indexed) 
is equal to

However when I do this it returns everything (I am assuming this as its goes over 5000 record when the totals for a single agent doesn't go over 1000).

Both columns are a "Person or Group" type. It will work if I only use one of the columns, this only fails when I use both columns

Is there a way to get this to work?


It may be the case that your indices were not created correctly. If you had more than 5k items in the list the index creation will fail. you need to create new list create indices and migrate content from the other list.

| improve this answer | |
  • Do you know of a resource that explains how to do this? – Mr.Burns Mar 12 '19 at 12:38
  • There is no easy way to do it. I would recommend some migration software like Sharegate, using it at the moment and it is quite stable migrator. According to some you can create indices up to 20k items now. sharepoint.stackexchange.com/questions/207367/… – Marek Sarad Mar 12 '19 at 13:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.