Fix Missing SharePoint Lookup Column in Microsoft Lists Mobile App
Question details
The user is unable to view or edit a SharePoint lookup column in the Microsoft Lists mobile app on iOS, despite the column displaying and functioning correctly in the desktop web version.
- Product
- Microsoft Lists
- Device & OS
- iOS
- Scenario
- Accessing and editing list data that contains lookup columns pulling from another SharePoint list or Excel data source via a mobile device.
- Observed behavior
- The lookup column is completely absent from the list view and form in the mobile app, preventing the user from viewing or inputting data for that specific field.
Verify that your Microsoft Lists mobile app is updated to the latest version in the App Store, and confirm that the missing column is explicitly configured as a Lookup column on the desktop web version.
Use a Mobile Web Browser Workaround
Since the iOS mobile app has known rendering limitations for complex column types like Lookups, accessing the list via a mobile web browser bypasses the app restrictions.
The Microsoft Lists mobile app currently does not support displaying, adding, or editing certain complex field types in the same way the web interface does. Until an official app update resolves this, the web browser is the most reliable method to manage lookup columns on the go.
Launch Safari, Google Chrome, or Microsoft Edge on your iOS device.
Go to the Microsoft 365 portal or type in the direct SharePoint site URL where your list is hosted, then sign in with your credentials.
Open the specific list. The web interface will render all columns, including Lookup columns, allowing you to view and edit the data as you normally would on a desktop computer.
Submit Feedback for App Improvement
Report the missing feature directly to the Microsoft development team to help prioritize support for lookup columns in future iOS app updates.
Manage Your Spreadsheets and Data Seamlessly with WPS Office
If you are frustrated by mobile app limitations with complex data linking in Microsoft Lists, consider exporting your lists and managing them as spreadsheets using WPS Office. It provides a robust, free alternative for managing data and documents across all devices without missing feature limitations.
- 1. Export your list to Excel: From the SharePoint or Microsoft Lists web view, select 'Export to Excel' to download your data as an .xlsx file.
- 2. Open in WPS Office mobile app: Transfer the file to your iOS device and open it using the free WPS Office app.
- 3. Edit data seamlessly: View and modify all your columns and data without the rendering restrictions found in the Lists mobile app.
Frequently Asked Questions
Why do some columns appear on the SharePoint web but not in the mobile app?
The Microsoft Lists and SharePoint mobile apps currently have limited native support for certain complex column types, such as Lookup, Managed Metadata, or highly customized calculated columns. These columns are automatically hidden in the app interface.
Can I edit a Lookup column directly from my iPhone?
You cannot edit it directly via the Microsoft Lists iOS app if the column is missing. However, you can edit it by opening the same list using a mobile web browser like Safari or Chrome on your iPhone.
Will Microsoft fix the missing lookup column issue in the iOS app?
Microsoft continuously updates its mobile applications. Submitting feature requests through the app's 'Help and Feedback' section helps alert developers to user demand and prioritizes adding support for Lookup columns in future updates.
