Power Platform Community Forum Thread Details

Hi everyone, I'd like to filter items in a Gallery with input boxes, or drop down lists. But I don't know where to start.

Because first of all I can't populate the drop down lists with fields for example in the "Status" column, I don't know where to get them.

And secondly, I don't know what to put in the gallery item formula, to filter with the input boxes or drop down lists, keeping the existing formula as well.

I show you the Gallery as it is composed:

I would like to filter by elements of the column, inserting these attributes in the drop down listes at the top.

The formula on the "item" on the Gallery is this:

What should I write in the drop down lists, and what here in this formula?

Thanks for who can help me!

Categories:

Building Power Apps

Hi @matteoseni,

Based on the issue that you mentioned, do you want to filter the Gallery based on search box or Combo Box selected?

Could you please share a bit more about the scenario?

If you want to filter based on search box or Combo Box selected in a single formula, I am afraid that there is no way to achieve this. You could filter items based on the search box input and Combo Box selected as below:

Sort(
 Filter(
 'Workplace Certification Program Pathways',
 'Exam Path'.Value = ComboBox10.Selected.Value||Choice.Value = ComboBox9.Selected.Value||TextSearchBox1.Text in Name
 ),
 Name,
 Ascending
)

Note that 'Workplace Certification Program Pathways' is my data source, please replace it with yours.

Also, I have 2 Choice columns to populate the Combo Box, so I refer to the column using Column.Value.

Hope it could help.

Regards,