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.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand