Unanswered

Delegation problem but in one column

(0) Share

Report

Posted on by pablik01

Hi. I receive such a warning but it applies only to one "Tagi" column. I've looked through the forum but I can't apply the advice to my situation.

Warning regarding delegation. The "StartsWith" part of this formula may not work correctly for large data sets

With({
 asmt: SortByColumns(
 Filter(
 'Wykaz klas JRWA';
 IsBlank(searchQuery) || StartsWith(Title; searchQuery) || StartsWith (Tagi; searchQuery) || StartsWith(Sposob_prowadzenia;searchQuery)
 );

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WarrenBelz 152,843 Most Valuable Professional on at

Like (0)

Report

Re: Delegation problem but in one column

Hi @pablik01 ,

I suspect Tagi is a Choice or Lookup column - if so, StartsWith is not Delegable. I suggest you change it to a Text column, or use a drop-down with the available value and use equals if you want to use that structure.

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
pablik01 on at

Like (0)

Report

Re: Delegation problem but in one column

Tagi is a text column, also I have a second question is Is there a way to search the entire text, not just the first word?

Was this reply helpful? Yes No
WarrenBelz 152,843 Most Valuable Professional on at

Like (0)

Report

Re: Delegation problem but in one column

@pablik01 ,

For further clarification - Tagi is a Single Line of Text and your data source is SharePoint ? If so it should be Delegable.

Was this reply helpful? Yes No
pablik01 on at

Like (0)

Report

Re: Delegation problem but in one column

Suddenly it started working when I once again set the columns in SharePoint to a single line of text. I have a question about searching by each word in one column. I was thinking about collecting information from a SharePoint table into a collection and using the Split formula. Am I right?

Was this reply helpful? Yes No
WarrenBelz 152,843 Most Valuable Professional on at

Like (0)

Report

Re: Delegation problem but in one column

@pablik01 ,

Yes it will work as a Single Line of Text, ashough I do not understand your reference to the Split() function as this is used when text is delimited (for example by commas).

Was this reply helpful? Yes No
pablik01 on at

Like (0)

Report

Re: Delegation problem but in one column

I have several words in a column separated by commas. I wanted to set the search to run after each word in the column.

Was this reply helpful? Yes No
WarrenBelz 152,843 Most Valuable Professional on at

Like (0)

Report

Re: Delegation problem but in one column

@pablik01 ,

Yes that will work except Split() is not Delegable.

Was this reply helpful? Yes No