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
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?
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.