Search Filter - Delegation? - how to find a combox dropdown with text ??

(0) Share

Report

Posted on by bbsin

1,994

I am trying to Search filter in Gallery , the yellow delegation appear, please advise what is wrong thanks

AND How to have the data display from oldest to new?

or is it

Search(Filter(list)', IsBlank( combo box.Selected.Value) || IsEmpty( combo box.SelectedItems) || (Category = combo box.Selected.Value), SEARCHBOX.TEXT, "Description")

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Jagadeeshk 457 on at

Like
a
(0)

Report
Copy link

Link copied!

Search is not supportfir sharepoint,
Use startwith instead of search.
Or filter(addcolumn (source, "temp", len(description)-len(substitute (description, textip,"")),temp>0)
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks but what is , "temp", len(description)-len(substitute (description, textip,"")),temp>0)??
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@bbsin ,

This is Delegable

Search( Filter( list, ( IsBlank(combo box.Selected.Value) || Category = combobox.Selected.Value ) && StartsWith(Description,searchbox.Text) ) )

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.
Jagadeeshk 457 on at

Like
a
(0)

Report
Copy link

Link copied!

Temp is a temporary column added for filtering.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Jagadeeshk ,

The output of AddColumns is subject to Delegation limits - it is one of the "hidden" Delegation items in Power Apps - Microsoft doc is here - relevant parts below

You also seem to be simply comparing the length of the fields - not sure why.

@bbsin ,

You simply cannot use the Search (or in) Filter directly on a list of more than your Delegation limit. Depending on the size of your list, there are some possible workarounds. How big is it?