I havent actually got it working yet. When i use the if statement, I get blue squigglys:
But without the if, it looks oK:
So it seems the if function itself is not delegatable on a sharepoint backend. Any Ideas?
IsBlank cannot be delegated. See link below for more detail.
yeah, the IF statement itself is not delegatable either : https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
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 )
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
Likewise, no delegation warning on the previous code block I sent for whatever reason. What's up with that?
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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021