Delegation warning when using Text() in a Filter() for Dataverse choice column

(0) Share

Report

Posted on by BradonK

375

Hi all,

I have been getting this error when trying to use the formula below:

"Delegation warning. The 'Text' part of this formula might not work correctly on large data sets."

Search(Filter('Task Data', Text('Task Status') = ctxTaskListFilter), cmpTaskListSearchFilter.Text, "bk_tasknumber")

I need to have the Text() there as choice columns need to be converted to text to compare against. Is there a workaround for this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BradonK ,

Note that Search is also not Delegable here, but if 'Task Status' is a choice column and you simply need TaskStatus.Value, however what is ctxTaskListFilter ?

Was this reply helpful? Yes No
BradonK 375 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

When I remove the filter and just keep the search I don’t have any delegation warning. The docs say that search can be delegated with text to Dataverse but not when using the Text() function. Since I am searching TaskNumber, which is technically a text field, this shouldn't be an issue, right? I just have to find a way around the Text() function delegation.

There doesn’t appear to be an option for TaskStatus.Value, only TaskStatus.
ctxTaskListFilter is a string that equals either Open or Archived and is changed by a couple buttons in the app.

The formula should filter Task Data by the context variable and then search from those results.

Thanks

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@BradonK ,

My apologies - I was missed the Dataverse reference - yes Search is Delegable, however I do not use Dataverse (I normally would not have responded) - however this article may be of assistance.

Was this reply helpful? Yes No
BradonK 375 on at

Like
a
(1)

Report
Copy link

Link copied!

@WarrenBelz ,

Thanks for the link, it was really helpful.
Unfortunately it did not explain exactly what I need as I am using a local choice value not a global choice component. However, the article did have a disclaimer near the end linking to an update on the options that they personally could not get working, but did exactly what I want! It all works now, turns out I needed to use the option that specifies a table which I had not previously used.

It looks a little like this:
Filter(Source, 'Task Status' = 'Task Status (Task Data)'.Open)

Instead of this:
Filter(Source, 'Task Status' = [@'Task Status'].Open)

Thanks again!

Was this reply helpful? Yes No