Row Limits

[PCesarRT26]

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

[WarrenBelz]

Hi @PCesarRT26 ,

The non-delegable part of that is Search - the best you will do is this (where the top filter needs to return under your limit)

With(
   {
      wData:
      SortByColumns(
         Filter(
            Table1_1,
            (
               Len('WH_Filter'.Selected.Value) || 
               WH = 'WH_Filter'.Selected.Value
            ) &&
            Len(Bin_Filter.Selected.Value) = 0 || 
            GROWER = Bin_Filter.Selected.Value
         ),
         "HOUSE",
         SortOrder.Ascending
      )
   },
   Search(
      wData,
      TextInput1.Text,
      "HOUSE"
   )
)

however, if you are using Excel here, I cannot guarantee anything will work on that many records and this video may be worth watching.

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Pstork1 · Accepted solution]

The Excel Data source doesn't support delegation because there is no server to do the delegated selection.  So there is a hard limit on how big the Excel workbook can be and that puts a limit on how many rows you can show in the Power App. There is no way to extend that limit and no workaround.

[PCesarRT26]

Thank you this was informative, I am looking into using other DataSources

[PCesarRT26]

This is what i came across multiple searches and am looking into using other Data Source.

[WarrenBelz]

@PCesarRT26 ,

What is your other data source (I recommend SharePoint) and what did you come across ?

[PCesarRT26]

It is SharePoint and i am using a more simplified Filter function that does not have delegation issues