How to reTrigger Gallery Form to Refresh onSelect of button that creates collection for SP list

[JenVitug]

How to reTrigger Gallery Form to Refresh onSelect of button that creates collection for SP list that contains 3000+ items.

Initially, the Gallery should just show the default 500 items (limit)  from the SP Datasource, which is faster and especially if user just needs to CREATE a new item  for this SP list  (therefore, user does not need to load all 3000+ records ). 

But if user needs to EDIT an item , which is not from within the first 500 records of the SP list, i have created a button (Load All Records)   in the Gallery Form to  create the Collection to cache the 3000+ rows from the SP list.   

However,  how do i make the Gallery Form Refresh to use the Collection  so that it can now load all the 3000+ records  for the user to select for editing Need to refresh Gallery to show the Collection created for 3000+ records only when Button LoadAll is selected

[roknron]

Have you tried filtering the items based on a search that contains a criterier provided by the user?  You could still limit the recordset to 500 records.  Why would you have the user manually search through 3000 records?

[JenVitug]

hi @roknron,

I have tried filtering to limit the recordset, however, if the records being searched/filtered are not in the first 500 records of the SP list,  the search/filter returns NO results.    I have done a workaround, which is to display a second gallery form to show the recordset using the Collection (collection cached all the records)  as the datasource instead of the SP datasource.