"in" function delegation issues

(0) Share

Report

Posted on by SearchingYT

107

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 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

C-Papa 1,836 on at

Like (0)

Report
Copy link

Link copied!

Hi, i think you will always have this issue when using 'in' in this way. you could try the below which will collect the data for each selected item using =. this assumes that one of the select values is an exact match. if its not you could change it to use StartsWith().

Add a button to test it and set it OnSelect property to

Clear(col_Search_Results);

ForAll(ComboBox1.SelectedItems.Result As MyFilter,

Collect(col_Search_Results,Filter(DataSource, MyColumn = MyFilter)))

then view the collection by highlighting it in the formula bar or add a gallery and change its items to col_Search_Results

Was this reply helpful? Yes No
SearchingYT 107 on at

Like (0)

Report
Copy link

Link copied!

Still facing delegation issues, because of collection limitation..

Was this reply helpful? Yes No
Rhk 133 on at

Like (0)

Report
Copy link

Link copied!
Try using this
Combobox.SearchText
I used this formula to retrieve 50k plus items from SharePoint

Was this reply helpful? Yes No