I have a flow that uses Get Items Filter Query that is supposed to Get Items from original SharePoint list (over 10,000 records) based on Start Date and Accept status and then create these items in second SharePoint list. See filter query below. About a month ago, it stopped creating items in the second list.
It's supposed to look at the original list, get items that are "Accept" and StartDate greater than today, and less than two weeks and create those items within this timeframe in another SharePoint list. I thought it was that the OData filter needed to be wrapped in 'datetime' and changed the varToday and varTwoWeeks to datetime'2026-06-15T00:00:00Z'. I was also originally using an Output on the Get date in 2 weeks, changed this to varTwoWeeks. I also noticed that the Filter Query keeps reverting my expressions back to variables. The other real issue for me is that since the flow isn't failing, I can't tell where the issue is, I'm assuming it's the Get items because this is the action that isn't producing it's intended outcome. Any help is appreciated here. This was working fine until around the end of May and then no new items to the second list.
When I look at the Filter Query on the completed run, AcceptDecline eq 'Accept' and StartDate ge datetime'2026-06-12T00:00:00Z' and StartDate lt datetime'2026-07-04T00:00:00Z' and the raw Outputs doesn't show any items after "value":[]}}
The Value on varToday - Expression - formatDateTime(addDays(utcNow(), -4),'yyyy-MM-ddT00:00:00Z
The Value on varTwoWeeks - Expression - formatDateTime(addDays(utcNow(),18),'yyyy-MM-ddT00:00:00Z
Filter Query
AcceptDelcline eq 'Accept'
and StartDate ge datetime'varToday'
and StartDate lt datetime'varTwoWeeks'
and (PAFCreatedFlag eq null or PAFCreatedFlag eq 'No')
