Delegation

[ruth]

I'm using the following function to filter the items in my gallery:

Sort(Filter(tblEventLog, logEventType.Label in Concat(cboEventTypeFilter.SelectedItems,Result,", ")),'logCaseID:caseTitle'.Value)

I'm getting a delegation warning with in and the filter is only working on the first 2000 rows. I thought I was understanding delegation but maybe I'm still confused.  According to the "Understand delegation in a canvas app", sort, filter and in all seem to be delegable functions. What might be be missing?

Background, I'm trying to filter my data source based on one to many event types.

[RandyHayes · Accepted solution]

@ruth 

This is all dependent on the DataSource.  You did not mention what you are using.

I am going to assume you are using SQL only because of your name for the datasource table.  In the case of SQL, the in operator is only delegable in scenarios where you are looking for "text" in a column, not for column in "text".

I would suggest a pre-filter to reduce the number of records you are working with to be less than 2000 and then apply your non-delegable criteria to the pre-filter.  In other words, do you need to apply this criteria to ALL records, or is it really only a subset (i.e. Status="Open", or something along those lines)?

I hope this is helpful for you.

[ruth]

Thanks, @RandyHayes . I am actually using sharepoint (migrating a standalone access application to sharepoint). The event type is the only field that I can use as a pre-filter. I was attempting to avoid having to pre-load all the data in a collection, then work off the collection. But with the way my data is modelled, it seems almost impossible to avoid.

[ruth]

@RandyHayes , I haven't given up on delegation. I changed my filter to the following:

Filter(tblEventLog,Label2.Text in logEventType.Label) 

*On this statement, the delegation warning is on in

Filter(tblEventLog,Label2.Text = logEventType.Label)

*On this statement, the delegation warning is on = and Label

I'm using Sharepoint. Is it possible that delegation cannot be performed on columns defined as managed metadata?