Gallery filter based on dropdown

(0) Share

Report

Posted on by Joaoandrebs

361

I need to filter the gallery based on these choice boxes, but I don't know how I can do it.

in my scenario I have a gallery (APS Request) that show this data, the "Site" column needs to be filtered in the choices box, however, the site column in sharepoint is of the CHOICES style.

Another thing I need to filter is the Status column, which is also a choice column (I don't know why, I didn't create the app).

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Joaoandrebs ,
Use Choices([SPList_Name].[ColumnName]) as your combo-boxes source.
Then in the source of the gallery,
lets suppose you have combobox1 for column Col1 and combobox2 for column Col2 And our datasource called "DS",
filter(DS,
(IsEmpty(combobox1) Or Col1 in combobox1.SelectedItems) And (IsEmpty(combobox2) Or Col2 in combobox2.SelectedItems))

If the multiple options in combobox is false then use isblank instead of isempty and combobox.selected.value instead of combobox.selecteditems
Please refer my comment as accepted solution if it fix your problem,
Regards.
Joaoandrebs 361 on at

Like
a
(0)

Report
Copy link

Link copied!

the combobox part is ok,

now the second formula filter(DS,
(IsEmpty(combobox1) Or Col1 in combobox1.SelectedItems) And (IsEmpty(combobox2) Or Col2 in combobox2.SelectedItems))

It didn't work, I didn't quite understand how to do it either.

it does not identify the "Col1" that you mention in the formula
Joaoandrebs 361 on at

Like
a
(0)

Report
Copy link

Link copied!

@OussamaOsman
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

What does the error says