Filtering gallery on screen 2 with collection from screen 1

[Miss_Zo]

Hello, 

I'm trying to filter a gallery on screen 2 from selections placed on screen 1. From what I could find, the best way to do this is by making a collection of screen 1 to then filter screen 2. 

Screen 1

Region - Radio button, single select, has default option select.

Metal Types - Gallery of multiple choice checkboxes - Saved as Variable

Protection Time - Gallery of single select checkbox - Saved as Variable

Product Type - Radio button, single select, no default option

Search button to collect and navigate

ClearCollect(coltemp,
{
colregion:Region_select.Selected.Value,
colmetals:varMetalTypes,
coltime:varprotectiontime,
coltype:Product_type.Selected
}
);

Navigate(Screen2)

Example of a collection to show it is working properly.

Screen 2

Gallery1 consisting of values from my SharePointList to correlate to the selected on screen 1

Metals_List

Protection_List

Product_List

Region_List

So I need to filter the gallery based on the selections from screen 1. I tried to use the follwing to filter one category (similar to a previous app).  It does not work in this scenario probably for obvious reasons to some. 

Search(

    'Product Family Grouping',

    CountRows(

        Filter(

            ForAll(

                Metals_List,

                If(

                    Value in varMetalTypes.Value,

                        {is_match: 1},

                        {is_match: 0}

                )

            ),

            is_match = 1

        )

    )= CountRows(varMetalTypes)

)

I'm doing it this way because I want the gallery to filter only for options that contain all the selected options and not just 1. Trying to get this to work for now, but I will then add in blank statements to make sure that if the selection wasn't make and there's no collection, the filter shows all options for that cate

Would someone be willling to help guide me on how to do this?

[M_Ali_SZ365]

Hi @Miss_Zo 

To filter your gallery on Screen 2 based on choices made on Screen 1, you'll want to use a Filter function that checks if each choice has been made and then applies it to your gallery. Your filter formula would look something like this:

Filter(
    SharePointList,
    (coltemp.colregion = "" || RegionColumn = coltemp.colregion) &&
    (IsEmpty(coltemp.colmetals) || MetalColumn in coltemp.colmetals.Value) &&
    (coltemp.coltime = "" || TimeColumn = coltemp.coltime) &&
    (coltemp.coltype = "" || TypeColumn = coltemp.coltype)
)

• Replace SharePointList with the actual name of your list.
• Replace RegionColumn, MetalColumn, TimeColumn, and TypeColumn with the names of the columns in your SharePoint list that store the corresponding data.
  Please accept this solution if it resolves the issue. ✅
  Best regards,
  Muhammad Ali

[MudassarSZ365]

Hi @Miss_Zo ,

Screen 1:

On your search button, you correctly use ClearCollect to create a collection with the selections from Screen 1.
Screen 2:

To filter the gallery based on the selections from Screen 1, you will use the Filter function.

Filter(
    'Product Family Grouping',
    colregion in Region_List,
    coltype in Product_List,
    coltime in Protection_List,
    // For multiple selections in Metal Types
    CountRows(
        Filter(
            varMetalTypes,
            Value in Metals_List
        )
    ) = CountRows(varMetalTypes)
)

Here’s an example of how you might modify the formula to handle an unselected or "no selection" state for coltype

Filter(
    'Product Family Grouping',
    (IsEmpty(coltemp.coltype) || coltype in Product_List),
    // Add similar logic for other fields
    ...
)

Kindly mark the solution as accepted if it resolves your issue.

Best Regards
Muhammad Mudassar Mazhar

[Hassan_SZ_365]

Hi @Miss_Zo ,

1. 1. Identify the Source of Your Galleries: Ensure that both galleries are pulling data from the correct data sources. Let’s assume Gallery1 and Gallery2 are using collections or tables named Collection1 and Collection2 respectively.

   2. Create a Relationship Between the Galleries: Your galleries should have a common key to relate them. In this case, it’s the Name of the workers.

   3. Filter the Gallery: On Gallery1, you want to set the Items property to something like this: 

Filter(Collection1, toggleValue = true)

However, you need to reference the toggle values from Gallery2. Assuming the toggle column in Gallery2 is called toggle and Gallery2's data source is Collection2, your filter formula for Gallery1 would look like this: 

Filter(Collection1, Name in Filter(Collection2, toggle = true).Name)

This formula means that you are filtering Collection1 where the Name exists in Collection2 filtered for rows where toggle is true.

Update the Filter on a Button Press: If you want to apply this filter using a button (since you mentioned the toggle is a separate button), set the OnSelect property of the button to update a context variable with the filtered collection. 

Set(FilteredCollection, Filter(Collection2, toggle = true));
​

Then, use this FilteredCollection to filter Gallery1.

Set Gallery1 Items Property: Change the Items property of Gallery1 to use this FilteredCollection. 

Filter(Collection1, Name in FilteredCollection.Name)

Now, when you press the button, it should filter Gallery1 to only show the items where the corresponding toggle in Gallery2 is true.

Remember that the exact syntax may vary depending on the platform you are using (like Microsoft PowerApps, for example). Ensure that the property names (toggle, Name, etc.) match exactly with the names in your actual data source.

Best Regards,
Hassan Raza

[Miss_Zo]

Hello, 

Thank you for the information. I encountered a few errors. 

It does not like "Value". Perhaps because the Metals can be multiple values. So in the column collection for metals there are multiple rows of values.

It also did not like the equal sign. 

My other concern is the "in" I want to only search products that have all of the selected and not just one selected. Does the "in" accomplish that? 

Thanks.

[Miss_Zo]

Hello, 

Thank you for the attempt. A few errors popped up when I tried this one. 

The first error is that the program does not recognize the col"name" from the collection. 

The second is a bit confusing. 

Thanks.

[Miss_Zo]

I'm a little confused and perhaps if I better show what I have you can help me understand. 

My first screen has a series of checkboxes and radio buttons. The checkboxes had to go into galleries in order to work. Everything is connected to one sharepoint list. 

From Screen 1 I have set it to create a collection based on the user inputs to make filtering on screen 2 easier. 

On screen 2 I have the enitre product database showing in a gallery. I need to filter that gallery based off the items selected on screen 1 (now the collection). I do not want to create a gallery based off the selection.  

[MudassarSZ365]

@Miss_Zo ,

try this 

Filter(
    'Product Family Grouping',
    coltemp["colregion"] in Region_List,
    IsEmpty(coltemp["coltype"]) || coltemp["coltype"] in Product_List,
    coltemp["coltime"] in Protection_List,
    // For multiple selections in Metal Types
    CountRows(
        Filter(
            varMetalTypes,
            Value in Metals_List
        )
    ) = CountRows(varMetalTypes)
)

Kindly mark the solution as accepted if it resolves your issue.

Best Regards
Muhammad Mudassar Mazhar

[M_Ali_SZ365]

Hi @Miss_Zo 

Error with "Value": To handle multiple values in the Metals column, you should modify the formula to split the selected metals into a collection and check if any of them match the values in the SharePoint list's Metals column. Here's the updated formula:

Filter(
    SharePointList,
    (coltemp.colregion = "" || RegionColumn = coltemp.colregion) &&
    (IsEmpty(coltemp.colmetals) || 
        CountRows(
            Filter(
                Split(coltemp.colmetals, ","),
                MetalColumn = SharePointList[@MetalColumn]
            )
        ) > 0
    ) &&
    (coltemp.coltime = "" || TimeColumn = coltemp.coltime) &&
    (coltemp.coltype = "" || TypeColumn = coltemp.coltype)
)

1. Error with Equal Sign: Ensure that the column names in your formula match the actual column names in your SharePoint list. Check for any typos or case sensitivity issues.

2. Filtering for All Selected Items: The "in" operator checks if any of the selected metals match the values in the Metal column. If you want to filter for products that have all selected metals, you'll need to implement more complex logic to ensure all selected metals are present in the product's Metals column.

Make these adjustments to your formula based on your requirements and verify the column names for accuracy.

Please accept this solution if it resolves the issue. ✅
Best regards,
Muhammad Ali

[Miss_Zo]

Thank you so much for your continued help. I tried your changes and I'm getting somem new errors. 

If I use the quotess the formula does not recognize the Lists and I get an error at the start. "Expecting Boolean."

The formula will strangely recognize the functions if I use @ for the coltemp column type, but then I get the circular error.