Unanswered

Delegation warning. The "MyProfileV2" part of this formula might not work correcly on large data sets

(0) Share

Report

Posted on by nhbinh

The highlighted part of this formula might not work correctly on large data sets.

Search(
 Sort(
 Filter(
 HelpDesk,
 'Created By'.Email = Office365Users.MyProfileV2().mail,
 IsBlank(cbTaskStatusFilter.SelectedItems.Value) || IsEmpty(cbTaskStatusFilter.SelectedItems) || TaskStatus in cbTaskStatusFilter.SelectedItems,
 IsBlank(cbPriorityFilter.SelectedItems.Value) || IsEmpty(cbPriorityFilter.SelectedItems) || Priority.Value = cbPriorityFilter.Selected.Value,
 Created >= dpFrom.SelectedDate && Created <= dpTo.SelectedDate
 ),
 Created,
 SortOrder.Descending
 ),
 txtSearch.Text,
 "Title"
)

i'm creating helpdesk app, connect data from sharepoint. During the writing of the application, I encountered this error without knowing how to handle it. look forward to everyone's help

Screenshot (1).png

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

iDLIR 50 on at

Like (1)

Report
Copy link

Link copied!

Hi @nhbinh ,

you might think about using User().Email formula there.

Thanks,
if this helped fixing your issue, kindly mark it as solved to help others too.

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

try this:

With({email: Office365Users.MyProfileV2().mail}, Search( Sort( Filter( HelpDesk, 'Created By'.Email = email, IsBlank(cbTaskStatusFilter.SelectedItems.Value) || IsEmpty(cbTaskStatusFilter.SelectedItems) || TaskStatus in cbTaskStatusFilter.SelectedItems, IsBlank(cbPriorityFilter.SelectedItems.Value) || IsEmpty(cbPriorityFilter.SelectedItems) || Priority.Value = cbPriorityFilter.Selected.Value, Created >= dpFrom.SelectedDate && Created <= dpTo.SelectedDate ), Created, SortOrder.Descending ), txtSearch.Text, "Title" ) )

and I would suggest creating a variable on 'OnStart' to store the user email to improve the performance

I hope it helps 🙂

Was this reply helpful? Yes No
nhbinh 19 on at

Like (0)

Report
Copy link

Link copied!

I tried but still got a bug 😞

Was this reply helpful? Yes No
nhbinh 19 on at

Like (0)

Report
Copy link

Link copied!

I tried but still got a error. The "Search" part of this formula might not work correcly on large data sets.

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (1)

Report
Copy link

Link copied!

Unfortunately 'Search' is not delegable, so when you use it, the delegation warning will happen.

To avoid that, I would suggest using StartsWith(), but it doesn't work as Search

Was this reply helpful? Yes No
colivam 58 on at

Like (0)

Report
Copy link

Link copied!

Question:
What is your data source?
"HelpDesk" is a Sharepoint/Dataverse/Other list?

Was this reply helpful? Yes No
nhbinh 19 on at

Like (0)

Report
Copy link

Link copied!

Helpdesk is a sharepoint list.

Was this reply helpful? Yes No
colivam 58 on at

Like (0)

Report
Copy link

Link copied!

I have only recently started using powerapps, but from the little experience I have, you mean that using inside the filter function (for example), the "in" operator or the IsBlank function, makes the "delegation" warning pop up everywhere!!!!
I mean .... I think you have the problem of delegation from the root, from the function Filter!!!!

Was this reply helpful? Yes No