Two ways to get to a filtered data table

[Techgallagher]

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:

Gallery 2: 

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')

[yashag2255 · Accepted solution]

Hi @Techgallagher 

Can you try to setup the configuration as:

Part Selection Gallery -> OnSelect -> Set(SelectedPart, 'Part Selection Gallery'.Selected.PartName)

Image Gallery-> OnSelect -> Set(SelectedPart, 'Image Gallery'.Selected.'Part Name')

DataTable -> Items -> 

SortByColumns(Search(Filter('[dbo].[970_item_format_item_mast]',part_name = SelectedPart),...Search expression),...sort expression)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Techgallagher]

For some reason still when I choose from the first gallery it keeps showing me the first item in that gallery and not the one I selected from the image. All the details on this gallery are below

Social Feed layout displaying the image and the body
Items property of the image gallery:

Filter('inventory Catalog - Details', Categories = cat_Gallery.Selected.Result)

Body Text property: 

ThisItem.'Part Name'

On select property of the image: 

Navigate('Individual Part Data Screen',ScreenTransition.Fade);
Set(SelectedPart, 'Image Gallery'.Selected.PartName);
UpdateContext({filterOn:true})

Here is what the gallery looks like

When I select the image for this it should take me to that data table screen and show me a symmetrical u cup info but it keeps defaulting to Piston buffer cap which is the first item in this image gallery

[yashag2255]

Hi @Techgallagher 

Can you append Select(Parent) at the beginning of the OnSelect property of all the controls inside Gallery?

Example: Select(Parent);Set(SelectedPart, 'Image Gallery'.Selected.PartName); UpdateContext({filterOn:true});Navigate('Individual Part Data Screen',ScreenTransition.Fade);

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Techgallagher]

I updated it, but still no luck 😕

[yashag2255]

@Techgallagher 

What happens when you change 'Image Gallery'.Selected.PartName to ThisItem.PartName? Try to change this at both galleries and let me know the results.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Techgallagher]

Okay, so I am dumb and the initial answer with selected part worked, I just never updated the label to display selected part instead of the firstgallery.selected.partname

But now I have another issue: So I changed the label to be "Part Name: " & SelectedPart and that works as it should, but below that I have an html text box that is supposed to be the selected part's description. If I do SelectedPart I get no options to show part description. Any thoughts? 

[yashag2255]

@Techgallagher 

If you want to show the show the related details elsewhere, I would suggest you to change a few things:

Part Selection Gallery -> OnSelect -> Set(SelectedPart, 'Part Selection Gallery'.Selected)

Image Gallery-> OnSelect -> Set(SelectedPart, 'Image Gallery'.Selected)

DataTable -> Items -> 

SortByColumns(Search(Filter('[dbo].[970_item_format_item_mast]',part_name = SelectedPart.'Part Name'),...Search expression),...sort expression)

Label -> "Part Name "&SelectedPart.'Part Name'

Description can be retrieved using SelectedPart.'Part Description'

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Techgallagher]

Thank you for the quick response, but I am getting an incompatible type error when I set it at that. I think it needs to be a text value 

[yashag2255]

@Techgallagher 

The issue is occurring because the schema for both tables is different. You should create a new variable to save Description.

Select(Parent);Set(SelectedPart, 'Image Gallery'.Selected.PartName);Set(SelectedPartDescription, 'Image Gallery'.Selected.PartDescription); UpdateContext({filterOn:true});Navigate('Individual Part Data Screen',ScreenTransition.Fade);

Apply the same change to other gallery. You can use SelectedPartDescription variable to retrieve the value.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!