Filter and Search error

(0) Share

Report

Posted on by nagestiada

504

Hey guys, I have a combobox with a static items ["Action required","In progress","Completed"]

Now I want to filter the gallery based from the selected items of the combobox(multiple select)

Filter(SharePointList,
 StartsWith('Client Name',SearchInput.Text)&& 
 ('Current Status'.Value = CurrentStatusDrpDwn.Selected.Value || CurrentStatusDrpDwn.Selected.Value=Blank()) 
 )

I also have a search but should be contains instead of starts with.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nagestiada ,

This is not Delegable, but should work

Filter( SharePointList, StartsWith( 'Client Name', SearchInput.Text )&& ( 'Current Status'.Value in CurrentStatusDrpDwn.SelectedItems.Value || CurrentStatusDrpDwn.Selected.Value=Blank() ) )

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
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz, yeah I am having delegation issue with the code. Are there any workaround for this? I just want to filter the status of my gallery using a combobox and utilise the search text input 😞
Verified answer

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nagestiada ,

The in filter is simply not Delegable (and you need it) - the below is a workaround of sorts (you will not receive a warning however the top filter needs to return record numbers less than your Delegation limit for you to receive all results in the bottom filter.)

With( { wList: Filter( SharePointList, StartsWith( 'Client Name', SearchInput.Text ) ) }, Filter( wList, 'Current Status'.Value in CurrentStatusDrpDwn.SelectedItems.Value || CurrentStatusDrpDwn.Selected.Value=Blank() ) )

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
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nagestiada ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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
nagestiada 504 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,

Yes thank you very much!!!