cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olsen9
Resolver II
Resolver II

Using SharePoint Lists to display Parent/Child Relationships via a lookup ID in Powerapps

List A shows items in powerapps, would like a Tab at the top that shows the 1 to many relationship in List B when clicking the Tab it opens List B items that have the same Lookup ID from List A.  I've seen someone do this with a 1 to 1 but not sure on the new form to show List B when selecting the Tab what would be the syntax to show all items related.

1 ACCEPTED SOLUTION

Accepted Solutions
mrleetyler
Resolver II
Resolver II

Screen 1:

Gallery1 - linked to main Data Source

 

Screen2

Gallery 2 - "Items" - filter(<data source>, LinkedID = Gallery1.selected.ID)

 

 

View solution in original post

5 REPLIES 5
mrleetyler
Resolver II
Resolver II

Screen 1:

Gallery1 - linked to main Data Source

 

Screen2

Gallery 2 - "Items" - filter(<data source>, LinkedID = Gallery1.selected.ID)

 

 

olsen9
Resolver II
Resolver II

Is this the information I add to the button that will look like a tab?

olsen9
Resolver II
Resolver II

It doesn't work since my list A is not a Gallery, just a SharePointForm1

olsen9
Resolver II
Resolver II

so the filter is now working in my new gallery, the only piece I need to update is the button to show this filtered gallery.  I've tried Launch(browsegallery1) but not working

olsen9
Resolver II
Resolver II

figured it out with the navigate option.  thanks for the help on the filters.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,152)