Share
Report
7891. There is a SharePoint list, ObsItems, which is a child list to Obs. The lookup field in ObsItems to Obs is Obsfk.
2. There is a SharePoint list, ObsItemsTemplates, which holds default items to be created in ObsItems, when a new Obs record is created.
3. In a CanvasApp, screen scrObsNew, that when a new Obs record is created, the Patch() function handles creating new ObsItems records, based on the ObsItemsTemplates records.
4. Screen scrObsDetails needs to display the newly created items in ObsItems, so a variable is used to store them, for display within a gallary.
Set(varObsItems, Filter('ObsItems', Obsfk.Id = varObsID)); /*This is a data snapshot, so it doesn't NEED to be a collection */
4. In the Canvas App, the Data Row Limit setting is 2000 items.
Problem: When more than 2000 rows have been added to the entire ObsItems list, the Filter in #4 above can't find any new items that are outside of the 2000 item window. (I assume this is determined by the ID or date Created, as to what is included in the 2000.)
5. The number of items needed is only 42, so I assumed that it would be easy to return this many rows.
Question: What other technique, code, function, etc do I need to use to return these 42 items from the ObsItems SharePoint list?
All responses (
Answers (
