Answered

How do I make the part that has delegation in the formula happen after all the other filters

(0) Share

Report

Posted on by UrquidiAlex

I have the formula below that has been working perfectly with SharePoint until we hit 500 request.

SortByColumns(Filter([@ClientReassignmentRequest],If(StatusFilter.Selected.Value="All",true,Status.Value=StatusFilter.Selected.Value), StartsWith(Summary, TextSearchBox1.Text),'Current Advisor'.Email=varUser.Email Or CreatorEmail=varUser.Email,txtSearch.Text in Summary || txtSearch.Text in Description|| txtSearch.Text in 'PINs Affected') , "Created", If(SortDescending1, Descending, Ascending))

I have this formula within it that is has delegation issues,

If(StatusFilter.Selected.Value="All",true,Status.Value=StatusFilter.Selected.Value)

basically I have an option where they can filter the request based the status.

How do I make that part occur once everything has happened in order to run the formula for only those items that are already pulled.

By the way this is used on a gallery

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @UrquidiAlex ,

Your main Delegation issue is actually the in filter at the bottom - you can make the one you mention Delegable as below - I have then isolated the offending items

With( { wList: Sort( Filter( [@ClientReassignmentRequest], ( StatusFilter.Selected.Value="All" || Status.Value=StatusFilter.Selected.Value ) && StartsWith( Summary, TextSearchBox1.Text ) && ( 'Current Advisor'.Email = varUser.Email || CreatorEmail = varUser.Email ) ), Created, If( SortDescending1, Descending, Ascending ) ) }, Filter( wList, txtSearch.Text in Summary || txtSearch.Text in Description || txtSearch.Text in 'PINs Affected' ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @UrquidiAlex ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
UrquidiAlex 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you this worked perfectly!

Was this reply helpful? Yes No