How to filter Powerapps gallery data with multi select combo box?

(0) Share

Report

Posted on by OK29

388

Hi,

I have a large data in SQL table and displaying in Powerapps gallery. I am trying to gallery data using selected values in multi select combo box but I am not getting results and getting delegation warning.

Here is my code.

StatusCombobox Items property has following items ["","Active", "Archive", "Inactive"]

OnChange has Set(varStatusCombo,Concat(statusComboBox.SelectedItems, Value & ", "))

Powerapps gallery Items has following code

SortByColumns(If(txtHSSID_1.Text = "",
Filter(
'SQLDataConnection',
status in statusComboBox.SelectedItems
),
Filter(
'powerapps.v_pa_krnl_published',
hssid = Value(txtHSSID_1.Text)
)
),varSortColumn,varSortDirection)

If I use below filter condition, I am getting results

status = "Active"

but I am not getting results if I use following

status in varStatusCombo OR

status in statusComboBox.SelectedItems

Any help would be greatly apprecited.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 154,475 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @aaedla ,

Firstly how big is your list as this may not be a total solution. The below should get rid of the Delegation warning, but the top filter needs to return record numbers under your Data Row Limit for a complete result.

With( { _Data: Filter( 'SQLDataConnection', Len(txtHSSID_1.Text) = 0 || hssid = Value(txtHSSID_1.Text) ) }, SortByColumns( Ungroup( ForAll( statusComboBox.SelectedItems As _Items, Filter( _Data, status = _Items.Value ) ), "Value" ), varSortColumn, varSortDirection ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
OK29 388 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thank you for your suggestions but I am getting invalid arguements error message in the following part.

With(
_Data,
Filter(
'powerapps.v_pa_krnl_published',
length(txtHSSID_1.Text )=0||
hssid = Value(txtHSSID_1.Text)
)}

Any suggestion?

Was this reply helpful? Yes No
WarrenBelz 154,475 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@aaedla ,

Typing error - please see correction.

Was this reply helpful? Yes No
OK29 388 on at

Like (0)

Report
Copy link

Link copied!

Thank you @WarrenBelz .

But it is not working as expected. If I change the status, it's trying to filter the records from _Data (which is like a data collection ) Only and it's not filtering the data from database based on statuses which I selected in combo box. I do have more than 25000 records in database.

Was this reply helpful? Yes No
WarrenBelz 154,475 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@aaedla ,

As I noted clearly in my post, depending on your list size - this may not be a solution. I will go a step further, but this is as far as you can go (now I know you have 25k records)

SortByColumns( Ungroup( ForAll( statusComboBox.SelectedItems As _Items, Filter( 'SQLDataConnection', status = _Items.Value && ( Len(txtHSSID_1.Text) = 0 || hssid = Value(txtHSSID_1.Text) ) ) ), "Value" ), varSortColumn, varSortDirection )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No