Hello, I would like to delegate a filter function to a sharepoint list: Filter(@SharepointList, TextBox.Text in 'Column1') The "in" makes this indelegatable. Is there a workaround for this? Using "StartsWith" won't cut it since the users might not always know the starting letters/digits... Thank you in advance
@mdevaney is correct that you cannot filter a SharePoint list using "in". However, if you create a collection from your list, you can filter it using "in" and there is theoretically no limit to the number of items in a collection. There are several ways you can overcome the 2k limit on the Collect and ClearCollect functions. One example is /How-can-i-manage-to-filter-more-than-2000-records . All SharePoint lists have an ID column and you can use that to bring in chunks of data that can be added to a single collection.