Hi power app experts
I am working with SQL datasource with around 5000 rows and I want to search in a column on multiple values.
I use a combobox where user selects multiple values to search and then I use filter to perfrom the search and show results:
Filter(DataSource, MyColumn in ComboBox1.SelectedItems.Result)
This gives me a delegation error and does not return all the records.
Hence, my question is, does anyone have any idea on how to perform "in" function with delegation (workaround)?
How can I achieve this?
Any help would be appreciated. Thanks 🙂