Hi all,
I have a large sharepoint list (10000 rows) from which I want to bring in a tiny subset (10-20 rows) and store in a collection. Obviously delegation becomes an issue here. This action is to be performed when the user presses a button.
The filter expression is delegable. Looks something like Filter(SPList, Textcol = Textval). I can put this into a gallery and see the expected values.
However put that same expression into a Collect or ClearCollect (or Set) and it becomes non-delegable. ie ClearCollect(Mycol, Filter(SPList, Textcol = Textval)). I was hoping that the delegability of Filter would still apply, then collect would work no problem as it was only storing 10 rows but that isn't the case.
My current work around is to use Filter(SPList, Textcol = Textval) in the items property of an invisible gallery. Followed by using ClearCollect(Mycol, DummyGallery.AllItems) in the button to load my desired table into a collection. Is there another way?
