Power Platform Community Forum Thread Details

Hi everyone,

I am working with 2 galleries to drill down into a database:

- The first gallery shows the consolidated info by topic and the count of identified gaps.

- The second drills down into the specific Policy topic and shows the gaps individually.

I am able to link both of them via an variable, called VarGaps, which is set on the magnifying button on screen 1 via the code below.

Set(VarGaps, ThisItem.Policy);
Navigate('GAP Dashboard_1')

The goal is for the gallery to be filtered by the VarGaps value but also to allow the user to change via the dropdown menu. The code for the gallery is via a filter where:

Filter(
 Sort(varCol, Requirement_ID),

 (1)VarGaps in Policy_Paper,

 (2)IsBlank(Dropdown_Filter_PolPaper_1.Selected.Policy) Or Dropdown_Filter_PolPaper_1.Selected.Policy in Policy_Paper
)

If I use (1), the filter works moving from screens but I can't use the dropdown.

if I use (2), I am able to filter using the dropdown but not to filter with the VarGaps. The Dropdown has on its DefaultSelectedItems