Others

How to Create Two-Way Relationships and Lookups in Microsoft Lists

John Wilson Oct 12, 2026 869 views

Question details

The user wants to model one-to-many relationships and establish two-way lookups between different lists, such as a Pack List and an Asset List.

How to Create Two-Way Relationships and Lookups in Microsoft Lists

Product: Microsoft Lists
Device & OS: not provided
Scenario: Modeling relational data structures between lists to track linked assets and packs bidirectionally.
Observed behavior: Microsoft Lists does not natively support two-way relationships or related-item counts, requiring a workaround to link lists bidirectionally.

Before you start

Ensure you have adequate permissions to create and edit columns in both of your Microsoft Lists, as well as access to Power Automate for building the necessary synchronization workflows.

Solution 1Recommended

Use Power Automate to Create Bidirectional Lookups

Since Microsoft Lists lacks native two-way relationship functionality, you can use Power Automate to synchronize data and maintain one-way lookups in both directions.

Microsoft Lists is not designed as a full relational database, meaning it cannot natively handle bidirectional connections or related-item counts out of the box. By setting up a Power Automate workflow, you can trigger automatic updates across lists to simulate a two-way connection.

Please note that this workaround may have capability and performance limitations when applied to extremely large datasets, as synchronization delays can occur.

Set up your primary and secondary lists

Create your two lists in Microsoft Lists, for example, a 'Pack List' (primary) and an 'Asset List' (secondary).

Create reciprocal lookup columns

In the Pack List, add a Lookup column pointing to the Asset List. In the Asset List, add a corresponding Lookup column pointing back to the Pack List.

Build a Power Automate flow

Open Power Automate and create an Automated Cloud Flow. Set the trigger to 'When an item is created or modified' and select your primary Pack List.

Configure the update action

Add an action to 'Update item' for the secondary Asset List. Map the ID of the primary list item to the lookup column in the secondary list so that both lists remain synchronized whenever changes are made.

Use Power Automate to Create Bidirectional Lookups

Performance Limitations: This Power Automate workaround is best suited for small to medium-sized lists. Large datasets may experience API throttling and synchronization delays.

Free Microsoft Office alternative

Manage Relational Data Effortlessly with WPS Office

While Microsoft Lists handles simple tracking, managing complex relational data often requires the robust processing capabilities of a spreadsheet. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office, making it easy to organize, link, and analyze datasets with powerful lookup formulas.

Free and lightweight Microsoft Office alternativeHigh compatibility with Microsoft Excel (.xlsx) formatsAdvanced spreadsheet formulas for dynamic data lookups like VLOOKUP and XLOOKUPFamiliar user interface for a seamless migration with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I create a one-to-many relationship natively in Microsoft Lists?

Yes, you can create a basic one-to-many relationship natively using a standard Lookup column to link items from one list to another. However, this connection only works in one direction and does not automatically update the related secondary list.

Why doesn't Microsoft Lists support two-way relationships natively?

Microsoft Lists is designed primarily for flat data tracking and simple task management, rather than functioning as a fully relational SQL database. Complex relational features like bidirectional syncing and dynamic related-item counts are beyond its core architecture.

Is there an alternative to Power Automate for syncing list data?

You can use Microsoft Power Apps to build a custom front-end interface that patches and updates data across multiple lists simultaneously. However, the underlying lists themselves will still require manual or automated synchronization to maintain true two-way lookups.

Does WPS Spreadsheet support complex data lookups?

Yes, WPS Spreadsheet supports all standard and advanced lookup functions, including VLOOKUP, HLOOKUP, and XLOOKUP. This allows you to easily link and retrieve relational data across multiple sheets without needing complex automation workflows.

Office Quick Solutions