How to apply Grouped filters on a gallery or Modern table

(1) Share

Report

Posted on by Venkata Golla

Hi experts,

I am seeking advice on applying grouped filters to Gallery items or Table data in power apps.

Scenario:

My data source is Dataverse with more than 50k rows.

I currently have a popup with filters (2 text fields, 2 combo boxes, 2 date columns, and 2 Currency columns) and 2 buttons (Apply, Reset). The table is being filtered right after the input is entered.

My requirement is that I want to let the user fill all the filters needed and click Apply, then filter the table at once with all filters. Or filter the table when Filters are Reset.

What is the best way to achieve this?

Thanks in Advance.

Venkata

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,442 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Realistically what I would do

1. Create a Collection with your data

2. Assign that to the Items Property

3. Add NO filterings in the items Property, just have the Collection Name

4. In the Apply and Reset buttons add your filtering or resetting there
And this happens by those OnSelects, reading the Filters and applying them

Was this reply helpful? Yes No
Meekou 200 Moderator on at

Like (1)

Report

How did you implement the popup with filters?

1. Try to check and remove the code in Text.OnChange event

Try to share the Items property for your Gallery.

Was this reply helpful? Yes No
Venkata Golla 78 on at

Like (1)

Report

@FLMike ,

Apparently, I can't use a collection as I am using a Dataverse views selector outside the popup filter.

Was this reply helpful? Yes No
Venkata Golla 78 on at

Like (0)

Report

@Meekou,

Popup open on button click:

Items property of the table:

If(

IsBlank(textInputSearch_2.Value),

Filter(

Cash,

dropView_2.Selected.Value,

IsParent,

(IsBlank (textInputSAPCode.Value) || 'SAP Code Text' = textInputSAPCode.Value),

(IsEmpty (ComboboxPM.SelectedItems) || 'Project Manager' = ComboboxPM.Selected.'Full Name'),

(IsEmpty (ComboBoxVendor.SelectedItems) || Provider.Account = ComboBoxVendor.Selected.accountid),

(IsBlank(dpDueDateFrom.SelectedDate) || 'Line Item End Date' >= dpDueDateFrom.SelectedDate),

(IsBlank(dpDueDateTo.SelectedDate) || 'Line Item End Date' <= dpDueDateTo.SelectedDate),

varRefresh

),

Filter(

Cash,

dropView_2.Selected.Value,

IsParent,

'Project Code' in Split(

TrimEnds(textInputSearch_2.Value),

","

),

(IsBlank (textInputSAPCode.Value) || 'SAP Code Text' = textInputSAPCode.Value),

(IsEmpty (ComboboxPM.SelectedItems) || 'Project Manager' = ComboboxPM.Selected.'Full Name'),

(IsEmpty (ComboBoxVendor.SelectedItems) || Provider.Account = ComboBoxVendor.Selected.accountid),

(IsBlank(dpDueDateFrom.SelectedDate) || 'Line Item End Date' >= dpDueDateFrom.SelectedDate),

(IsBlank(dpDueDateTo.SelectedDate) || 'Line Item End Date' <= dpDueDateTo.SelectedDate),

varRefresh

)

)

Was this reply helpful? Yes No