Combo box with Delegation filter

(0) Share

Report

Posted on by justlearner1

hi have combo box with Status Column.

in Gallery i added below code

StartsWith(Status= ComboBox3.SelectedItems)

but display error as incompatible comparison.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @justlearner1 ,

You need

StartsWith( Status, ComboBox3.Selected.xxxx )

where xxxx is the valid output of the combo box - or if is it multi-select

Status in ComboBox3.SelectedItems

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

1.i used combo box with multiple select
2. first 2 codes used for search filter

StartsWith('Assigned Designer'.DisplayName,TextInput2.Text)||
StartsWith('Notice Number',TextInput2.Text)||
StartsWith(Status in ComboBox2.SelectedItems)
showing error message on combo Box2 code as Invalid number of aruguments, received 1 ,expected2

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@justlearner1 ,

As I posted, it is

Status in ComboBox2.SelectedItems

not

StartsWith(Status in ComboBox2.SelectedItems)

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

showing delegation error at 'IN'

StartsWith('Assigned Designer'.DisplayName,TextInput2.Text)||
StartsWith('Notice Number',TextInput2.Text),
Status in ComboBox2.SelectedItems

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@justlearner1 ,

Correct - the in Filter is not Delegable - if your list has less items than your Delegation limit, it will work.

Was this reply helpful? Yes No
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

having more than 2000 records..
in this case how to use combo box filter for gallery?

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@justlearner1 ,

You cannot use the in filter on more than 2,000 records unless you "pre-filter" the set with a Delegable filter. What is the full code you are using on the Items of the gallery?

Was this reply helpful? Yes No
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

this the code i used, now i want to add combo box filter in it.

SortByColumns(
Filter(
'SPTracker',
Status.Value = varStatus || IsBlank(varStatus) ||varStatus="All",
StartsWith('project name',searchbox1.Text)
),
"ID",
Descending
)

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@justlearner1 ,

You can do this to avoid the warning however, the top filter will only return up to 2,000 records for the bottom filter to act on - there is no avoiding this unless you want to get into big collections as per this Delegation blog of mine.

With( { wList: SortByColumns( Filter( 'SPTracker', ( (IsBlank(varStatus) || varStatus="All") || Status.Value = varStatus ) && StartsWith( 'project name', searchbox1.Text ) ), "ID", Descending ) }, Filter( wList, Status in ComboBox2.SelectedItems ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
justlearner1 89 on at

Like
a
(0)

Report
Copy link

Link copied!

combo box working but button filter not showing any results.. i added full code here
(( with && not working so i added "," but it is filter only combo values.

With(
{
wList:
SortByColumns(
Filter(
'SP Tracker',
IsBlank(varproject) || varproject = "All"||Program.Value = varproject,
IsBlank(varStatus) ||varStatus="All"||Status.Value = varStatus,
IsBlank(vartask)||vartask="All"||'Task Type'.Value=vartask &&
StartsWith('project name'.DisplayName,TextInput2.Text)||
StartsWith('Request Number',TextInput2.Text)
),
"ID",
Descending
)
},
Filter(
wList,
Status in ComboBox2.SelectedItems
) )

Was this reply helpful? Yes No