Hi,
Help! I am getting a delegation warning error with the below code:
If(IsBlank(Dropdown2.SelectedText.Result),SortByColumns(Search(MyInOut,TextSearchBox1.Text,"{Name}"),"{Name}",Ascending), SortByColumns(Search(Filter(MyInOut,Tags=Dropdown2.SelectedText.Result),TextSearchBox1.Text,"{Name}"),"{Name}",Ascending))
Also, how do you put an option where it searches for all the names when no tags are selected.
Thank you in advance.
Hi @Anonymous ,
Firstly, Search() is not Delegable, hence the warning. The code below does not solve the issue, just "masks" it and assists if you use the drop-down. Basically, the top filter needs to return item numbers under your Delegation limit for the Search to return the full results.
Share
Report
All responses (
Answers (
156,545
With(
{
wData:
SortByColumns(
Filter(
MyInOut,
IsBlank(Dropdown2.Selected.Result)
Tags = Dropdown2.Selected.Result
),
"{Name}",
Ascending
)
},
Search(
wData,
TextSearchBox1.Text,
"{Name}"
)
)
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
