Power Platform Community Forum Thread Details

I have an SP list with more than 4000 entries and growing. In order to get around the 2000 item limit in power apps, I am creating collections when the app starts. Here's the code:

ClearCollect(CollectionA,Filter(REM_Wood_Inventory,ID<2000));ClearCollect(CollectionB,Filter(REM_Wood_Inventory,ID>=2000 And ID<4000));ClearCollect(CollectionC,Filter(REM_Wood_Inventory,ID>=4000 And ID < 6000));ClearCollect(CollectionD,Filter(REM_Wood_Inventory,ID>=8000 And ID < 10000));ClearCollect(CollectionE,Filter(REM_Wood_Inventory,ID>=10000 And ID < 12000));ClearCollect(CollectionF,Filter(REM_Wood_Inventory,ID>=12000 And ID < 14000));ClearCollect(CollectionG,Filter(REM_Wood_Inventory,ID>=14000 And ID < 16000));ClearCollect(InvoiceInventory,CollectionA,CollectionB,CollectionC,CollectionD,CollectionE,CollectionF,CollectionG)

However, when I go to search for dates after the first of this year, Nothing pulls up. It's like it's not pulling in all of my entries even though I should have a collection with well over 2000 entries. Can I still not search by Date or will anything past 2000 in a collection not filter either?

Here's the filter code I have going on my gallery:

If(IsBlank(SearchBar.Text),Filter( InvoiceInventory,Wood_Type="Cant",Value('Board Feet')>0),If(Toggle1.Value=true,Filter(InvoiceInventory,SearchBar.Text in Text('Orginal Date (Date Only)',DateTimeFormat.ShortDate,"en-US"), Wood_Type="Cant",Value('Board Feet')>0),If(Toggle1_1.Value=true,Filter(InvoiceInventory,Wood_Type="Cant",Value('Board Feet')>0,SearchBar.Text ='Cant Vendor'),InvoiceInventory)))

Here's a picture of the filter working:

Here's a picture of it not (notice the dates):

On a side note, people are filtering by dates by selecting a date from the date picker. The date picker is set as a variable and passed to the search bar.

Thanks for your help guys!

Categories:

Building Power Apps