cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Techgallagher
Helper I
Helper I

Two ways to get to a filtered data table

Hi, I have two galleries, one is a more detailed gallery and the other is more general; however, I want to be able to navigate to a different screen that has a data table on it that will populate based on whether I pick from the first gallery or the second. As of now, it only is working on the first gallery selection, if I choose an item from the second gallery selection it will still just bring up whatever was last selected on the first gallery. 

 

Gallery 1:

Techgallagher_0-1599845378728.png

Gallery 2: 

Techgallagher_1-1599845413452.png

 

This is the current formula I have for the items property of the data table:
SortByColumns(Search(Filter('[dbo].[970_item_format_item_mast]',
(part_name = 'Part Selection Gallery'.Selected.PartName || part_name = 'Image Gallery'.Selected.'Part Name')

 

 

10 REPLIES 10

You're the best! Thank you so much!

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.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

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,729)