Others

Fix Microsoft Lists Forms Cannot Add a Lookup Column Issue

John Wilson Oct 1, 2026 868 views

Question details

Users are unable to add or view lookup columns in the new Microsoft Lists Forms designer, despite the columns working perfectly in the standard list form.

Fix Microsoft Lists Forms Cannot Add a Lookup Column Issue

Product: Microsoft Lists
Device & OS: not provided
Scenario: Creating a custom input form using the new Forms designer feature in Microsoft Lists.
Observed behavior: Lookup columns do not appear as an option in the 'Show or hide fields' section of the new Forms builder.

Before you start

Verify that you are using the new custom Forms designer rather than the standard built-in form, as this product limitation specifically affects the new builder.

Solution 1Recommended

Use the Standard Microsoft Lists Form

Since the new Forms designer lacks support for lookup columns, using the default standard list form ensures all your configured fields remain accessible.

This is the fastest workaround. The missing lookup column is currently a product limitation in the new custom Forms builder, not a configuration error on your part. The standard form retains full functionality.

Navigate to your List

Open Microsoft Lists and navigate to the specific list containing your lookup column.

Open the standard form

Click the 'Add new item' or 'New' button located at the top left of the list view. Do not use the custom form link.

Verify field visibility

The default standard form will slide out. Verify that your lookup column is visible and allows you to select data.

Product Limitation: Microsoft currently does not support lookup fields in the new Forms designer. This limitation is expected to be addressed in future product updates.

Solution 2

Create a Customized Form using Power Apps

If you require a highly customized form layout that must include lookup columns, integrating with Power Apps is the recommended official alternative.

Free Microsoft Office alternative

Enhance Your Daily Productivity with WPS Office

While Microsoft Lists is a powerful tool for complex data tracking, WPS Office serves as the perfect lightweight, free alternative for all your standard document, spreadsheet, and presentation needs. Experience familiar tools with zero learning curve.

1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install the software: Run the downloaded installation file and follow the simple on-screen instructions.
3. Open your files: Launch WPS Office and instantly open your existing Word, Excel, and PowerPoint documents without formatting issues.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) file formats.Lightweight architecture ensures fast installation and smooth operation on any PC or Mac.Intuitive, tabbed interface that feels instantly familiar to Microsoft Office users.Built-in advanced PDF editing capabilities alongside standard office applications.

microsoft office alternative - wps office

Frequently Asked Questions

Why are lookup columns missing in the new Microsoft Lists Forms designer?

This is a known product limitation. The new Forms designer feature currently does not support advanced column types like lookup fields. Microsoft may add this functionality in future updates.

Can I use Choice columns instead of Lookup columns in Microsoft Lists Forms?

Yes. If your data set is relatively small and static, you can replace a Lookup column with a Choice column. Choice columns are fully supported and will appear normally in the new Forms designer.

How can I check if my lookup column is configured correctly?

Simply open the standard 'Add new item' form. If the lookup column appears and allows you to select options from the linked list, it is configured correctly. The issue lies solely with the new Forms builder interface.

Office Quick Solutions