cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: Filtering on multiple fields

@RussellGove
Glad to hear it’s working now. Please mark the post that solved your issue as the solution so others can find it in the future.

View solution in original post

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Filtering on multiple fields

I havent actually got it working yet. When i use the if statement, I get blue squigglys:

new.PNG

 

But without the if, it looks oK:

old.PNG

So it seems the if function itself is not delegatable on a sharepoint backend. Any Ideas?

Highlighted
Helper I
Helper I

Re: Filtering on multiple fields

IsBlank cannot be delegated. See link below for  more detail.

 

https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/

 

 

 

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Filtering on multiple fields

yeah, the IF statement itself is not delegatable either : https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

 

Highlighted
Helper I
Helper I

Re: Filtering on multiple fields

 I am not sure if your filter requirement will work this way: Item=If(condition, Filter(Splist,abc),Filter(splist,xyz))

Highlighted
Super User
Super User

Re: Filtering on multiple fields

@RussellGove @IvanZ 

Darn it.  I guess my delegation settings weren't set low enough to catch this.  Sorry guys.  I was definitely wrong on the delegation part

Highlighted
Super User
Super User

Re: Filtering on multiple fields

@RussellGove @IvanZ 

Could you please humour me and let me know if you are getting delegation warnings on this style of pattern?  I turned my delegation rows down to 1 using a list of 3,000 records and no error is appearing.  I know it says IsBlank is non-delegable for Text in Sharepoint but I am just not seeing the error.  I would appreciate it if you can help me do a test 🙂

 

Filter(
    FPARequests,
    IsBlank(tbYear.Text)=true Or Year = tbYear.Text,
    IsEmpty(cbxRegion.Selected)=true Or Region = cbxRegion.Selected,
    IsBlank(tbCustomer.Text)=true Or Customer tbCustomer.Text,
    IsBlank(tbKeyword.Text)=true Or Keyword = tbKeyword.Text
)

 

View solution in original post

Highlighted
Helper I
Helper I

Re: Filtering on multiple fields

I have a similar filter, and IsBlank does trigger delegation warning. You can test for delegation with this formula:

Filter(
    FPARequests,
    IsBlank(tbYear.Text)
)

 

 

Highlighted
Super User
Super User

Re: Filtering on multiple fields

@IvanZ 

Here's what I am seeing with the following settings:

 

datasource: SP List

list size: 3000 records

data row limit for non-delegable queries: 1

 

Untitled.png

 

Likewise, no delegation warning on the previous code block I sent for whatever reason.  What's up with that?

Highlighted
Helper I
Helper I

Re: Filtering on multiple fields

I tested on your formula, it is indeed able to delegate. The reason why it works because IsBlank(Input.Text) return a value which doesn't query Sharepoint. If you do IsBlank(SPColumn.value) then it will get the warning. 

 

Hope this answer your question. 

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,103)