Solved: Large Dataset collection, to Filter a Filtered Dataset?

Hi,

Creating an offline mode with my SQL database.

I have a large SQL database with over 200,000 items records.

I have 4 columns in that database, Item Code, Item Description, Item Category, and Record ID (Unique ID from 1 to 200,000).

I made a download button and OnSelect, I was able to create a Collection (NewDataSet), by filtering the SQLdatabase with up to 2,000 Record ID at a time.

Ex. Collect(NewDataSet, Filter(SQLDatabase, RecordID <2000) ; Collect(NewDataSet, Filter(SQLDatabase, 2000 <Record ID && Record ID < 4000) etc.

This works perfectly, but it collects too much information and crashes the app.

I have created a Checkbox using Distinct Values of the Item Category in a Gallery from the SQL Database. The users can select the Categories using the Checkbox and then filter only for the records with the selected item categories.

On the Download Button, my formula is

ForAll(Filter(Gallery.AllItems, Checkbox.Value),Collect(NewDataSet,Filter(Filter('SQLDATABASE', 'Item Category' = Checkbox.Text),RECORDID < 2000 )));

The "'Item Category' = Checkbox.Text" part of this breaks it as the error is "Filter might not work on Large Datasets".

How can I filter the Checkbox based on each set (filtered) of RecordID that I have created?

Categories:

General Questions

Using Apps Using Formulas