Others

How to Create Relationships Between Microsoft Lists in Power Apps

Algirdas Jasaitis Oct 19, 2026 869 views

Question details

The user wants to know how to create and represent data relationships between different Microsoft Lists within a Power Apps canvas app, similar to the functionality found in Microsoft Access.

How to Create Relationships Between Microsoft Lists in Power Apps

Product: Power Apps and Microsoft Lists
Device & OS: not provided
Scenario: Migrating tables from Microsoft Access to Microsoft Lists and needing to link these distinct data sources properly within a custom Power Apps application.
Observed behavior: Microsoft Lists do not natively support robust relational database table structures like Access, requiring users to simulate relationships using lookups or Power Apps formulas.

Before you start

Ensure you have the appropriate edit permissions for both the Microsoft Lists data sources and the Power Apps canvas app, and identify the specific columns that will serve as the common ID or key between your lists.

Solution 1Recommended

Use Power Apps Formulas (LookUp and Filter)

Use built-in Power Apps functions to dynamically retrieve and display related records by matching a common ID stored in both lists.

Since Microsoft Lists lack native table relationships, storing a common identifier (like a Parent ID) in your secondary list allows Power Apps to connect the data on the fly.

This method gives you the most flexibility when building galleries, forms, or custom data displays in canvas apps.

Add Data Sources

Open your canvas app in Power Apps Studio. Go to the 'Data' tab and add both of your Microsoft Lists as data sources.

Insert a Gallery for Parent Data

Add a Gallery control to your screen and set its 'Items' property to your primary Microsoft List.

Filter the Child Data

Insert a second Gallery or Data Table. Set its 'Items' property using the Filter function to match the selected parent item, for example: Filter(ChildList, ParentID = Gallery1.Selected.ID).

Use Power Apps Formulas (LookUp and Filter)

Performance Tip: Ensure the columns you use for matching relationships are indexed in Microsoft Lists to prevent delegation warnings in Power Apps.

Solution 2

Create a Lookup Column in Microsoft Lists

Establish a basic relationship at the data source level by using a Lookup column.

Solution 3

Implement Cascading Drop-down Lists

Simulate a relationship by having one drop-down selection filter the options available in a subsequent drop-down.

Free Microsoft Office alternative

Manage Data Easily with WPS Office Spreadsheet

If building custom applications in Power Apps and managing Microsoft Lists feels too complex for your data needs, WPS Office offers a straightforward, powerful alternative. WPS Spreadsheet allows you to manage structured data, link tables effortlessly using advanced formulas, and handle large datasets securely.

1. Download and Install: Visit the official WPS website to download the free WPS Office suite for your device.
2. Open Your Data Tables: Launch WPS Spreadsheet and instantly open your existing Excel or CSV data files.
3. Link Data Using Formulas: Use built-in functions like VLOOKUP to easily establish relationships and pull data across multiple sheets.

100% compatible with Microsoft Excel (.xlsx, .csv) file formats.Easily link multiple data tables using VLOOKUP, XLOOKUP, and Pivot Tables.Free, lightweight, and incredibly fast to launch without complex setups.Familiar tabbed interface ensures a seamless transition from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Lists automatically handle one-to-many relationships?

Unlike Microsoft Access, Microsoft Lists do not inherently support strict relational database functionality like enforcing referential integrity. You must simulate one-to-many relationships using Lookup columns or by utilizing formulas within a front-end interface like Power Apps.

What should I do if my relationship requires complex relational data structuring?

If your application requires complex, robust relational database features that exceed the capabilities of Microsoft Lists and Lookups, Microsoft recommends migrating your data source to Microsoft Dataverse.

How do I avoid delegation warnings when filtering related lists in Power Apps?

To avoid delegation warnings, ensure that the columns you are using in your Filter or LookUp formulas (such as ID or text matching columns) are properly indexed in Microsoft Lists. Additionally, avoid using non-delegable functions like Search on complex LookUp columns.

Office Quick Solutions