Sharepoint Get Items OData Query Not Returning All Results
I am using an OData query in the 'Get Items' flow on a Sharepoint list that is around 1,500 records. Occasionally, the OData query is not returning records that would be expected, and no error is being thrown.
I've been doing a lot of research on this issue and can't find a similar problem. The query simply returns the records that have today's date in a certain column. 99% of the time this works, but occasionally a record will not process and that's an issue. I will go check the output of the 'Get Items' step when the Flow ran and there is no record returned.
Today a record with today's date '2022-04-26' did not return. The query uses the following formula:
Formula returns: Contractual_x0020_Due_x0020_Date eq '2022-04-26'
When I 'hard code' the date with the string '2022-04-26', it doesn't work either.
When I query the record using a different field, it returns the following JSON output for the field which should be equivalent:
I checked that the field was indexed and that the record was not modified since the flow ran. I've tried making a new flow with the same query and it still does not return. Anyone have any thoughts? Do I need out reach out to Microsoft?