I am running across a row limit issue, i have a spreadsheet with over 21K items on it and need to be able to show all items on a Gallery. I tried working around the row limit using the following function in the ITEMS propery of the gallery:
Search(SortByColumns(Filter(Table1_1,IsBlank('WH_Filter') || IsBlank('WH_Filter'.SelectedText.Value) || WH='WH_Filter'.Selected.Value,IsBlank(Bin_Filter) || IsBlank(Bin_Filter.SelectedText.Value) || GROWER=Bin_Filter.Selected.Value),"HOUSE",SortOrder.Ascending),TextInput1.Text,"HOUSE")
where 'WH_Filter' is a dropdown with all potential Options and Bin_Filter is a second dropdown with all potential options this formula also adds option to filter by typing in text input and filter that way. in other words i saying only show items where 2 separate columns values are equal to the selected item in the respective Dropdown.
however i am running into a row limit issue it looks like the OR operator is causing a delegation issue, i need to be able to filter my large list using 2 dropdowns that will make the list smaller than 2k records, i am including a sample data set and a screen shot of powerapp. i am hoping to get advice on how to overcome this if possible
WHGROWERItem #Batch
| MI | 40 | 1 | A |
| MI | 41 | 1 | B |
| NG | 80 | 2 | C |
| NG | 80 | 2 | D |
| VI | 70 | 3 | E |
| VI | 71 | 3 | A |
| SC | 30 | 4 | B |
| SC | 31 | 4 | D |
| SC | 32 | 4 | C |
