Let's say I have a list which is opened in quick edit mode(Datasheet view) have a lookup column when I click on any cell of the column I can see a drop down of items and also that drop down getting filtered based on the input/text that I type in the cell. The default search filter in the lookup column drop-down matches the characters entered with the starting characters of the items in the drop-down. Eg: If there is an item called "ABC DEF" in the drop-down list, this item will be shown in the filter only If I enter "AB" If I want to search by entering "DEF" it's not working.

So is there any way where I can change the custom search filter way of lookup column drop-down (or) Is there any way where we can embed a search field in the drop-down which filters out the drop-down of items based on the regular expression match that I prefer.

1 Answer 1


Datasheet view is configured by Access ActiveX component in SharePoint Online.

We are not able to change its default behavior.

  • Are you certain it's ActiveX (or even Access)? It was in 2010 but I thought it was removed in 2013/16/SPO. Commented Apr 20, 2018 at 12:56
  • Is there any way that we can do this to achieve a customized drop-down of lookup? I found this string online: link I don't know whether this thing is a workaround for this issue or not Commented Apr 20, 2018 at 15:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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