Hi all,
Is anyone able to explain how OData filtering is working along with the Pagination in SharePoint 'Get items' action?
I have the list that contains 10k records and My flow is triggered when new item is created.
I need to get only records where Title equals 1. Record's ID are as per the below screenshot.
Once i run the flow with OData defined to Title eq '1' and disabled pagination, i receive 2 items with ID 1 and 10:
OK, i get it. By default, items threshold is set to 100 first items once Pagination is disabled:
But if i enable pagination with threshold set to 100, and defined filter query, i'm receiving 4 items(as if whole 10k records would be taken for filtering).
When i removed Filter Query from the action, i received 100 records as expected 😕
Could anyone explain how query to the SharePoint is executed in these instances?
it looks as if with disabled pagination, firstly 100 items are extracted, then filtering is performed on this 100 records and finally items are sent to the flow, once with enabled Pagination, firstly entire table is filtered and then items are sent to the flow.
