When I am trying to search using metadata in the document library getting the below error

Error Code - 2147467259

However, whenever I am searching on the OOTB Modern SPO search page, it's giving me the result using same metadata.


I can reproduce your issue.

enter image description here

The error is in response to the View setting of list. You unknowingly was attempting to have many Lookup columns in a single View.

enter image description here

SharePoint Online limits the number of lookup column. Lists created prior to the June 2013 CU update are capped at 8 lookup columns, while those afterward are allowed 12.

Although the official said can have 12 Lookup fields under a single View. But in my test environment, the number of Lookup fields cannot exceed 10, otherwise an error will occur.

Once I edited the view to only contain a few Lookup columns in the default, the problem stopped.

enter image description here

  • Thank you so much for the information. I am using only 6 lookup columns in my view. – Virendra Kumar Feb 1 at 5:42
  • Hi, Virendra Kumar. Thanks for your reply. Glad to hear that your problem has been resolved. You can mark your Answer. This can help users who encounter this problem to reference. Finally, thank you for sharing. Have a nice day! – EchoDu_MSFT Feb 1 at 6:47

I found a solution to my issue. Actually, I created library views using a script as part of site provision, and just editing the views manually solved the issue in my case.

  • Open view
  • Edit view (not made any changes in view)
  • Save view

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.