How do I avoid the 'Delegation Error" when I have the following code

(0) Share

Report

Posted on by -aj

120

I am nearing the 2000 limit in my sharepoint list. Here is my code.

Search(
 SortByColumns(
 AddColumns(
 If(Lower(User().Email)=Lower("x@sample.com") || Lower(User().Email)=Lower("x@sample.com"), // admin email here separated by double pipe
 'Sharepoint_list',
 Filter(
 'Sharepoint_list',
 Lower('Created By'.Email) = Lower(User().Email) || // filter gallery by this
 Lower(Guest.Email) = Lower(User().Email) ||
 Lower('Modified By'.Email) = Lower(User().Email) ||
 Lower(Manager.Email) = Lower(User().Email) // or by this
 )),
 "ManagerName",
 Manager.DisplayName
 ),
 "ID", 
 If(
 SortDescending1, 
 SortOrder.Ascending, 
 SortOrder.Descending
 )
 ),
 TextSearchBox1.Text,
 "Title",
 "Topic",
 "ManagerName"
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Just did this in a notepad because there's too many variables to match for me to set it up in PowerApps and do it there so there may be some syntax to fix, but I think this should work or get you close. If it gets rid of most your blue lines but leaves one or two let me know, and I or someone else here can help further

Search( SortByColumns( AddColumns( If( Lower(User().Email)=Lower("x@sample.com") || Lower(User().Email)=Lower("x@sample.com"), // admin email here separated by double pipe 'Sharepoint_list', Filter( AddColumns( 'Sharepoint_list', "createdEmail", Lower('Created By'.Email), "guestEmail", Lower(Guest.Email), "modifiedEmail", Lower('Modified By'.Email), "managerEmail", Lower(Manager.Email) ), Or( Lower(User().Email)=createdMail, Lower(User().Email)=guestEmail, Lower(User().Email)=modifiedEmail, Lower(User().Email)=managerEmail ), "ManagerName", Manager.DisplayName ), "ID", If( SortDescending1, SortOrder.Ascending, SortOrder.Descending ) ), TextSearchBox1.Text, "Title", "Topic", "ManagerName" )

Was this reply helpful? Yes No
-aj 120 on at

Like
a
(0)

Report
Copy link

Link copied!

I've replaced the values with the correct information. Im getting this error message -

I removed the LOWER function, and the yield sign went away. I'll be waiting for our users feedback. Thanks!

Was this reply helpful? Yes No