Third-party tools like SharePoint Manager allow you to change settings on your web application. I need to toggle the LookupDropDownUseStandardControl from TRUE to FALSE, but SharePoint Manager is not working for some reason. I posted this to the SPM site back in December, then reported it as an issue in January. I haven't gotten a response yet, and the business unit needs me to find an alternate way of fixing this issue. The setting was flagged TRUE after an update and broke all of our complex lookup dropdowns.

Is there a way to apply this change via Powershell, or even in the database directly via SQL?

I also have access to Visual Studio, although I'm only an amateur developer at best.

1 Answer 1


Via PowerShell, this is simple.

$wa = Get-SPWebApplication https://webAppUrl
$wa.LookupDropDownUseStandardControl = $true | $false

Direct updates to SQL are wholly unsupported.

You'll use the SharePoint Management Shell on one of the SharePoint servers which is a member of the farm.

EDIT: Disregard the above. It can't be set!

public bool LookupDropDownUseStandardControl
    get => 
  • Great answer, fast too! Is there anything that would lock the setting to TRUE? Both this command and SPM seem to have no effect on the setting value.
    – Omegacron
    Mar 8, 2017 at 21:23
  • Updated my post. It can't be set.
    – user6024
    Mar 8, 2017 at 21:26

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.