I have a GetItems action with this settings, where i am filtering the items using a SharePoint field named ExpiryDate of type DateOnly (without time):-
First thing I defined this Filterquery:-
which will result in this Filter Query:-
((ExpiryDate eq '2023-04-22') or (ExpiryDate eq '2023-05-08') or (ExpiryDate eq '2023-06-07'))
but i only get 1 item our of 6321 items. so based on my reading i append the ExpiryDate with this `T00:00:00.000Z`as follow:-
which result in this Filter Query:-
((ExpiryDate eq '2023-04-22T00:00:00.000Z') or (ExpiryDate eq '2023-05-08T00:00:00.000Z') or (ExpiryDate eq '2023-06-07T00:00:00.000Z'))
but i got 5547 items out of 6321 . i got the 6321 number, as when i defined this sharepoint list view :-
the total item count was 6321. any advice what is going on ? so wy getitem is nto able to get all the items?
now in total i have 6321 divided as follow:-
1) 5805 with expiry date = 07 June 2023
2) 258 with expiry date = 22 April 2023
3) 258 with expiry date = 8 May 2023
so is there any advice what is going on ?
