I need to filter a SharePoint list of over 2000 items. So, delegating to SP to the filtering and return data is out.
The field to be filtered is a multi-line text field containing multiple email addresses and is called Owners Group. When a user accesses the app, I'd like to filter the items so that every item containing the users email address in Owners Group is displayed in a gallery. Basically, I'd like it to function as [Me].
In APP Onstart, I tried this: Set(varUser, User()); Set(vargroup, 'Owners Group')
Then in Gallery Items property: Filter(varUser.Email in vargroup) I thought I could build a collection in the app and filter it for 'contains' using 'in'.
I have watched numerous videos but all use = as the operand. No one discusses 'in'. I have also read numerous articles, but none say I can't do this some how nor do they show how you can.
Maybe this can't be done. If so, I can live with that. I would just like to know how or that I can't.
'in' is not a delegable operator for SharePoint. It will work in some data sources, but it won't work in SharePoint for large numbers of records. Your only real workaround is to pre-filter the list on something else to get it below the data row limit (max 2,000) and then apply your IN to an outer filter. At that point you can ignore the fact that its not delegable.
Hi @DTooley ,
The in operator is not delegable, so using on the entire list will simply not work. I have done a blog on using the With() filter on non-delegable queries - it may be useful if you have another Delegable filter you can reduce the data set with.
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.