SharePoint Document Issues

How to Show a SharePoint Form Field Based on a Lookup Value

Tauseeq Magsi Oct 21, 2026 868 views

Question details

The user needs to configure a SharePoint form to conditionally display a field based on the value selected in a lookup column.

How to Show a SharePoint Form Field Based on a Lookup Value

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Configuring conditional-display formulas for SharePoint list forms.
Observed behavior: Conditional-display formulas fail to apply correctly to lookup columns due to incorrect value matching, formatting, or syntax issues.

Before you start

Ensure you have design or edit permissions for the SharePoint list and note down the exact internal name of the lookup column you are referencing.

Solution 1Recommended

Verify and Adjust the Conditional Formula Syntax

Ensure the formula perfectly matches the lookup column's returned text, including spaces and capitalization.

Conditional formulas in SharePoint evaluate the exact string returned by a column. Because lookup columns can sometimes return complex objects or slightly altered text, ensuring a perfect match is the most critical step.

Open List Settings

Navigate to your SharePoint list, click the gear icon in the top right corner, and select 'List settings'.

Access Form Settings

Select 'Form settings' to access the customized form layout and conditional formulas.

Verify Lookup Value

Check the exact text returned by the lookup column in your standard list view. Pay strict attention to capitalization, trailing spaces, and exact characters.

Apply the Formula

Enter the conditional display formula comparing the lookup column's internal name to the exact text string (e.g., =[$LookupColumnName] == 'Target Value'). Save your form changes.

Verify and Adjust the Conditional Formula Syntax

Lookup Column Quirks: Lookup columns often return complex objects or text with hidden spaces. Make sure you are referencing the text value correctly without leading or trailing spaces.

Solution 2

Consult the SharePoint Development Community

If standard formula adjustments fail, specialized coding support from SharePoint engineers may be required.

Free Microsoft Office alternative

Looking for a Simpler Way to Manage Team Documents?

While SharePoint offers complex form logic, it can be overwhelming for simple document collaboration. Try WPS Office as a free, lightweight, and highly compatible alternative for your team's document management and editing needs.

1. Download the Installer: Visit the WPS Office website and download the free installer for your operating system.
2. Install WPS Office: Run the setup file and follow the on-screen instructions to install the software suite on your device.
3. Open Your Files Seamlessly: Open any exported SharePoint documents, Excel spreadsheets, or PowerPoint presentations directly in WPS Office with full format retention.

Fully compatible with Microsoft Word, Excel, and PowerPoint formatsLightweight application that doesn't consume excessive system resourcesFree alternative to expensive Office subscriptionsIntuitive interface for seamless document creation and collaboration

Frequently Asked Questions

Why is my SharePoint conditional formula not recognizing the lookup value?

Lookup columns can be tricky because they often store data differently than standard text columns. Ensure your formula accounts for exact text matches, including case sensitivity and any hidden spaces.

Can I use multiple conditions for a single SharePoint form field?

Yes, you can use logical operators like && (AND) and || (OR) within your conditional formulas to evaluate multiple column values before showing or hiding a specific field.

Where do I find the internal name of my SharePoint column?

Go to your List settings, click on the column name, and look at the URL in your browser's address bar. The internal name is the text located at the very end of the URL after 'Field='.

Document & File Issues