Hello @Hepworthnot,
your suggestion about the limit record seems to be right.
You can do two things to bypass this:
- You could just increase the number of the data row limit. Go to File/App settings/Experimental features - there you could set the number.
- More preferable: put your data as raw input into a collection and save this collection. After this you could easily access and for example filter your data.
Code example for collecting and saving:
If(
Connection.Connected,
ClearCollect(localData, 'YourDataSource'),
SaveData(localData, "saveLocalData");
LoadData(localData, "saveLocalData", true)
)
This code checks for a available connection and retrieves the data. If no data is available it will load the already saved data from your cache.
Note: in the web browser you will get an error message trying to save a collection. You could easily ignore this, as it will work properly on your device. For just creating the collection ignore the rest and just do the ClearCollect.
