Others

How to Create Two-Way Relationships Between SharePoint Lists and Libraries

Olivia Miller Sep 28, 2026 869 views

Question details

The user wants to set up automatic two-way relationships connecting people, projects, and documents across SharePoint lists and libraries without relying on heavy custom coding.

How to Create Two-Way Relationships Between SharePoint Lists and Libraries

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Linking related records between different SharePoint lists and document libraries so that updating one side automatically reflects on the other.
Observed behavior: Standard SharePoint lookup columns only offer one-way data linking and do not automatically maintain complete bidirectional data relationships between different lists.

Before you start

Verify your Microsoft 365 licensing plan to confirm you have access to Power Apps and Power Automate, as advanced automatic synchronization requires these tools.

Solution 1Recommended

Use Power Automate to Synchronize Related Records (Recommended)

Leverage Power Automate to create background workflows that automatically update and synchronize fields bidirectionally between your SharePoint lists and libraries.

Since native SharePoint lookup columns only provide a one-way relationship, Power Automate allows you to bridge the gap. By setting up triggers on both lists, you can ensure that modifying a record in one list automatically updates the corresponding record in the other.

To prevent infinite loops where both lists continuously trigger each other, you must add condition checks in your flow to verify if the data actually changed before updating.

Create a new automated cloud flow

Open Power Automate, navigate to 'Create', and select 'Automated cloud flow'. Choose 'When an item is created or modified' as your SharePoint trigger and connect it to your primary list.

Add an update action

Add a new step and search for the SharePoint 'Update item' action. Select your secondary list or document library as the target.

Map the fields

Configure the 'Update item' action by mapping the unique identifier (such as Project ID) and other relevant dynamic content from the primary list to the secondary list's fields.

Build the reverse flow

Create a second, identical automated flow that runs in reverse (triggering from the secondary list and updating the primary list). Ensure you add a 'Condition' step to only run the update if the values differ, preventing an infinite update loop.

Use Power Automate to Synchronize Related Records (Recommended)

Licensing Requirement: This method requires standard Microsoft 365 licenses that include Power Automate for Office 365. Consult your IT administrator if the workflow triggers are disabled.

Solution 2

Utilize Lookup Columns and Grouped Views (No-License Workaround)

If you do not have Power Automate licenses, use a structured metadata design with lookup columns and custom views to simulate a two-way relationship.

Free Microsoft Office alternative

Looking for a seamless alternative to Microsoft Office? Try WPS Office.

While managing complex SharePoint list relationships requires Microsoft's enterprise tools, managing your daily documents, spreadsheets, and presentations shouldn't be expensive or complicated. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for your everyday productivity needs.

1. Download the software: Visit the official WPS website to download the free WPS Office suite for your operating system.
2. Install and launch: Run the installer. The lightweight design ensures a fast setup process.
3. Open your Office files: Launch WPS Office and directly open your existing Microsoft Office files. You can edit, save, and share with perfect format compatibility.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation with a user-friendly, familiar tabbed interface.Includes a robust built-in PDF editor to manage, merge, and sign documents easily.Seamlessly integrates with cloud storage services for easy document collaboration.

microsoft office alternative - wps office

Frequently Asked Questions

Why don't SharePoint lookup columns automatically update both ways?

SharePoint lookup columns are designed natively as a one-directional relational reference mapping a child list to a parent list. They pull data for display purposes but do not have built-in triggers to write data back to the parent list without the help of external workflow automation like Power Automate.

Can I link a SharePoint document library to a custom list?

Yes. You can add a lookup column within your document library settings that points directly to a specific custom list. This allows you to tag uploaded documents with metadata from the list, such as project names, client IDs, or department tags.

Are Power Automate flows for SharePoint included in basic Microsoft 365 plans?

Most standard Microsoft 365 business and enterprise plans include basic Power Automate rights for SharePoint, which allow you to create standard synchronization flows. However, connecting to premium connectors or external databases may require a standalone Power Automate premium license.

Office Quick Solutions