How to filter a a gallery with multiselect combobox

(0) Share

Report

Posted on by ridhan

158

Hi All,

I need your help in filtering a gallery with multi select combobox :

items of combobox: Distinct(vw_equipment_classification,class_description)

onchange on combobox: ClearCollect(multifilter1, Self.SelectedItems);

gallery items:

Filter(AddColumns(vw_equipment_classification,"class_description2",class_description),class_description in multifilter1))

Please help urgently!

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ridhan,

Assuming that class_description is a text field, that Filter code looks good and I would expect it to work.

Would it be possible to provide more information about (1) the error, (2) the column types and (3) the datasource?

Thanks!

Was this reply helpful? Yes No
ridhan 158 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying @LaurensM - below is more information:
1. Error: It is only working till row 2000 and not filtering data after 2000 rows
2. Column types: class_description is a nvarchar
3. Datatsource is- sql

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@ridhan using the 'in' operator in such a manner indeed will cause a delegation warning. Should your list not exceed the Data Row Limit (default 500, max 2000) then this is nothing to worry about.

A few possibilities you could consider:

(1) Use a single-select dropdown and check whether the selected value equals your column value

(2) Prefilter your data to make sure the output is less than 2000 records. Below a fictive example:

With( //Prefilter with a delegable query to get a sub 2000 record output {wPrefilter: Filter(vw_equipment_classification, ColumnX = ValueY)}, //Non-delegable filter on the prefiltered dataset AddColumns( Filter( wPrefilter, class_description in multifilter1 ), "class_description2", class_description ) )

(3) Move the filter logic to Power Automate by using Stored Procedures or the Execute a Query V2 action. The flow then returns the ouput as a JSON response which is stored to a collection and displayed in the app. (This is generally my go-to approach when using complex non-delegable SQL queries)

I hope this helps!

Was this reply helpful? Yes No