filter gallery with lookup

[Mammifero]

Good Morning to the forum from Italy, i'm like a "new kid on town" in terms of building power apps so i ask for a little help

I have two sharepoint lists

One called ListFamilies with 3 fileds:  Family – Family Description – Image

and the other one called ListArticles with the following fileds: Lookup Family – Articles – Articles Description – Price

I have created 2 screen – but i don’t know how to view on the screen “Articoli” the relative filtered item 

a big thank to anyone who can help me

regards

[Drrickryp · Accepted solution]

Hi @Mammifero 

If you have a one to many relationship between the two lists, you will need a second gallery to show them. There should be a field in the second list that relates it back to the Family list, ideally, familyID. This should be a number field that is the ID field from the Family list. You would have the items property of the Article gallery Filter(Article, familyID=Gallery1.Selected.ID)

[Mammifero]

Dear Drrickryp, thanks for the answer

if i undestood well i have to modify my sharepoint lists like follow 

ListFamilies:

Family – Family Description – Image

ListArticles:

Lookup Family – Articles – Articles Description – Price - FamilyID (formatted as number)

[Drrickryp]

@Mammifero 

You are exactly correct.  For an explanation and examples of how to implement the relationships in Powerapps see https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-...  and  https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Design-fundamentals-Imple... .  You will also need to add a screen with edit form to add/modify the Family list and one for the Article list.