SharePoint Document Issues

How to Work Around Unsupported SharePoint Lookup Column Types

Camila Milosovich Sep 30, 2026 868 views

Question details

The user needs to find a workaround for connecting SharePoint lists using column types that are not natively supported by SharePoint lookup relationships.

How to Work Around Unsupported SharePoint Lookup Column Types

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Attempting to create a lookup column in a SharePoint list using restricted data types like multiple lines of text or calculated fields.
Observed behavior: SharePoint restricts the creation of lookup columns for several field types, including multiple lines of text, multi-value choices, calculated fields, hyperlinks, custom fields, multi-value lookups, multi-value person fields, and Yes/No fields.

Before you start

Ensure you have access to Microsoft Power Apps and the necessary permissions to edit and connect the affected SharePoint lists in your Microsoft 365 environment.

Solution 1Recommended

Use Microsoft Power Apps to Create Custom Relationships

Since SharePoint restricts certain lookup column types by design, the official workaround is to build a custom relational interface using Power Apps.

SharePoint lookups intentionally block complex data types to maintain database performance and integrity. To bypass this native limitation, you can build a Canvas app in Power Apps to act as a custom user interface that connects multiple lists seamlessly.

Launch Microsoft Power Apps

Log into your Microsoft 365 account, open the app launcher, and select Power Apps. Choose the environment where your SharePoint lists are hosted.

Connect the SharePoint Lists

Navigate to the 'Data' section in Power Apps, select 'Add data', and choose the SharePoint connector. Enter your site URL and select the primary and related lists you want to connect.

Relate the Data Using Formulas

Insert a Gallery or Data Table to display your main list. To show related complex fields (like multiple lines of text or calculated fields), use the LookUp() or Filter() functions in the 'Items' or 'Text' property to match the ID or Title between the two lists.

Publish and Consult the Community

Save and publish your custom form. For advanced UI patterns, consult implementation guides from Power Apps experts like Matthew Devaney, or seek specific relational logic help in the official Power Apps Community forum.

Use Microsoft Power Apps to Create Custom Relationships

Limitation by Design: This is a hardcoded limitation within SharePoint. No native settings can force standard SharePoint views to accept these unsupported column types as lookups.

Free Microsoft Office alternative

Simplify Your Document Management with WPS Office

While resolving complex SharePoint list limitations requires specialized Microsoft tools, processing your exported data and daily documents should be hassle-free. WPS Office is a highly compatible, all-in-one suite that perfectly handles your exported list data without the heavy resource usage of traditional office software.

Seamlessly open and analyze SharePoint list data exported to CSV or Excel formats.Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx).Free and lightweight, ensuring fast performance on any device.Familiar tabbed user interface, requiring zero learning curve for new users.

microsoft office alternative - wps office

Frequently Asked Questions

Which column types are unsupported for SharePoint lookups?

SharePoint does not support using multiple lines of text, multi-value choices, calculated fields, hyperlinks, custom fields, multi-value lookups, multi-value person fields, and Yes/No fields as lookup columns.

Is there a way to enable calculated fields in standard SharePoint lookups?

No, you cannot enable this natively. The limitation is established by design to prevent circular reference errors and performance degradation within the SharePoint SQL backend.

How can I analyze my SharePoint list data without building a Power App?

If you only need to view or analyze the data, click 'Export to Excel' or 'Export to CSV' from the SharePoint list command bar. You can then open the downloaded file in a spreadsheet program like WPS Spreadsheet to filter and cross-reference the data using VLOOKUP or XLOOKUP functions.

Document & File Issues