#SharePoint Tip: Workaround for default value on a form when using a required lookup column (no code).


When using a Lookup Column on a SharePoint form, and it’s a required field, SharePoint unfortunately defaults the value on the Lookup Column, to the first field on the Lookup List. This may not be the best option when completing a form. The user may forget to select the required field, as it is already appears to be completed. A quick solution to this issue, is to add an item in the Lookup List that starts with, ‘……’ including a prompt of some sort as follows:

SharePoint Tip 1This item will then default as the first field that appears on the form as follows:

SharePoint Tip 2



  1. You could envision users missing the selection box and ending up with the default being submitted. Easy to introduce a bit of javascript to either enforce a selection or blank the dropdown when the page loads. For large dropdowns I really like using jQuery AutoComplete.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.