Adding relationships between lists in Microsoft Lists

Question

I have an Access database with multiple tables. I want to use PowerApps with those tables so I exported them to Lists, however how do I add relationships between the Lists?

Answer 1

Dear McBr0wn,

Thanks for your updates.

Based on your scenario in your environment, you may use different formula to create the relationship.

Generally, you may deploy the cascading drop-down list to simulate the relationship scenario in PowerApps.

Create a dependent drop-down list in a canvas app - Power Apps | Microsoft Learn

So please upload some related screenshots of the app you have created and provide some examples about the relationship you want to create for our reference and we can see if there are some formulas meeting your requirements.

Thanks for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 2

I've created the app and it works fine, it's just that I converted my Access tables to Microsoft Lists in-order to create the app. So I was wondering how can I create a relationship between the Lists, like you would in Access?

Answer 3

Dear McBr0wn,

Generally, you may deploy the cascading drop-down list to simulate the relationship scenario in PowerApps.

Create a dependent drop-down list in a canvas app - Power Apps | Microsoft Learn

If it is convenient, please upload some screenshots showing the app you are now creating and provide some examples about what you really want to do in your environment for our confirmation and we can see if we can create a demo app for your reference.

Note: Remove any private information before uploading the screenshots.

Thanks for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator