Filter gallery based on dropdown [afresh]

(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

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Joaoandrebs

Combobox's or dropdown? If comboboxes, single or multiselect?

Name of list, 'APS Request'? Allow blanks in choices?

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp

Combobox - single select

Yes, my list is APS Request - yes

like this image:

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp
I tried this, but
I want it to receive more than one filter, which doesn't filter just by the "site" column, understand?
And if possible without that dataset refusal warning...

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Joaoandrebs

I am assuming that the information applies to all of your combobox controls. ie. single selection, allows blank. You do not need the "in" operator for single selection comboboxes. Besides, this operator is not delegable in SharePoint and will always give a warning.

Filter( 'APS Request', Len(ComboBox1.Selected.Site)=0 || Site.Value = ComboBox1.Selected.Value, Len(ComboBox2.Selected.Value)=0 || Status.Value = ComboBox2.Selected.Value Len(ComboBox3.Selected.Value)=0 || someotherchoicecolumn.Value=ComboBox3.Selected.Value )

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp ,

the filter worked.
however, would it be possible to filter through the two comboboxes?
example: filter by selection value of the 2 simultaneous comboboxes? so it will be grade 10.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Joaoandrebs

The above filter should work if both comboboxes have choices, if either one has a choice and if both are blank, all the records should show. Please post the text of the current items of your gallery.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Joaoandrebs

There was a typo in my formula and if you are using only two comboboxes for Choice type fields that are single select type then this should work.:

Filter( 'APS Request', Len(ComboBox1.Selected.Value)=0 || Site.Value = ComboBox1.Selected.Value, Len(ComboBox2.Selected.Value)=0 || Status.Value = ComboBox2.Selected.Value )

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp

Oh right, hadn't realized this.
now, last thing (promise)
I put this formula to the dropdown because it makes more sense... but I want to leave an option to "reset" the selected items, for example: a button that "erases" the choices "Requested" and "SJC"

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Joaoandrebs

IF you are using dropdown controls, make sure to set the default property to Blank() and the button OnSelect to

Reset(Dropdown1);; Reset(Dropdown2)

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Joaoandrebs

If it answered your question, please mark it as solved.

Was this reply helpful? Yes No