(PowerApps) how can I create relationship between SharePoint files?

[christinadot]

I can have a one to many relationship when I use SharePoint. But when it comes to PowerApps how lookup from one table to another can be succeedeed?

[Ryanmch · Accepted solution]

If you have 2 SharePoint lists where one column references a unique column in the other list, displaying the items can be done using a condition with the filter formula.

Say you have a gallery where the source is the first SharePoint list and a second gallery where the source should be the items related to the selected item in the first gallery. Your formula for the items of the second gallery would look like this:

Filter(List2, List1ID = Gallery1.Selected.ID)

See https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/ for more information on the filter formula.

Ryan McHenry [MSFT - PowerApps]