Others

Fix SharePoint Lists Location Column Missing from New Form

Maira Mehtab Sep 21, 2026 868 views

Question details

The Location column (named Destination) and its subcomponents are missing and cannot be added to the new form experience in Microsoft Lists.

Product: Microsoft Lists
Device & OS: not provided
Scenario: Customizing the new list form experience for a Travel Approval list template.
Observed behavior: The Location column, including critical subcomponents like City and Coordinates, is completely unavailable in the new form interface.

Before you start

Check whether your Microsoft List is currently using the classic or the new list form experience, as certain column types are only supported in the classic view.

Solution 1Recommended

Use Alternative Text and Choice Columns

Since the native Location column is unsupported in the new form interface, creating custom text or choice columns is the most effective workaround for data collection.

The new Microsoft Lists form experience currently lacks integration for the dynamic Location column. To continue collecting essential travel and destination data without reverting to the classic experience, you can manually recreate the necessary fields.

Add a New Column

Navigate to your Microsoft List, open the default view, and click the '+ Add column' button at the top of the list header.

Select Column Type

Choose 'Text' for specific street addresses or 'Choice' if you want users to select from a predefined dropdown list of approved destinations.

Create Subcomponents Manually

Add separate columns for 'City', 'State', and 'Zip Code' to replace the dynamic subcomponents previously handled automatically by the Location column.

Verify Form Display

Click 'New' to open the new list form experience and ensure your newly created alternative columns are visible, ordered correctly, and fully functional.

Data Consistency: While this workaround lacks the automated map integration of the Location column, utilizing Choice columns heavily can help maintain strict data entry consistency across your team.

Solution 2

Submit Feedback to the Microsoft Lists Community

Reporting this missing feature helps the product team prioritize bringing the Location column to the new list form experience in future updates.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Management

If limitations in Microsoft Lists are slowing down your approval workflows, consider using WPS Spreadsheet to manage custom data trackers, travel approvals, and extensive address lists without restrictive form limitations.

1. Open WPS Spreadsheet: Launch WPS Office and select WPS Spreadsheet to create a new blank workbook or open your exported SharePoint list data.
2. Set Up Data Columns: Create customized headers such as Destination, City, and Coordinates to structure your travel approval data.
3. Create a Data Entry Form: Select your data range and use the built-in Data Form tool to quickly input location records securely and efficiently.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) ensuring seamless data migration from SharePoint.Create highly customizable data entry forms without encountering restrictive 'new form' limitations.Lightweight, free alternative with intuitive and familiar spreadsheet functionalities.Built-in robust templates tailored for travel approvals, project tracking, and inventory management.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Location column missing in the new Microsoft Lists form?

Microsoft has not yet developed support for the dynamic Location column and its automated subcomponents (like City and Coordinates) in the updated 'new form' architecture. It currently only functions in the classic view.

Can I revert to the classic form to use the Location column?

Yes, you can configure your list settings to default to the classic experience. Go to Settings > List Settings > Advanced settings, and under 'List experience', select 'Classic experience'.

Does the Travel Approval template work without the Destination column?

The template itself continues to function, but you will need to replace the default Destination/Location column with standard Text or Choice columns to successfully capture travel addresses in the new form view.

Office Quick Solutions