Hello friends. I created a basic reminder flow on a library that has 50,000 items. Understanding that the flow can only process 5000 items, i am using a filter query to only process records who's termination date (the column i'm interested in) is equal to today's date.
concat(concat('Termination_x0020_Reminder_x0020_Date',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('Termination_x0020_Reminder_x0020_Date',' lt ','''', outputs('x_Days_+_1'),''''))
This query should only return a handful of items. When running the flow, i get no results, and in the output section of get items, i see a 200 status code and this message in the body
{
"@odata.nextLink": "https://flow-apim-msmanaged-na-centralus-01.azure-apim.net/apim/sharepointonline/shared-sharepointonl-cc31f36b-841e-401d-a1ac-f5a737c9df15/datasets/https%253A%252F%252Fbluelinxco.sharepoint.com%252Fsites%252FLegalMatter/tables/4e094f30-843e-4b46-b8ec-cde1729b8d7b/items?viewScopeOption=Default&$filter=Termination_x0020_Reminder_x0020_Date+ge+%272020-04-20%27+and+Termination_x0020_Reminder_x0020_Date+lt+%27+2020-04-21%27&$top=1000&$skiptoken=Paged%3dTRUE%26RootFolder%3d%252fsites%252fLegalMatter%252fContracts%26ix_Paged%3dTRUE%26ix_ID%3d105618",
"value": []
}
{
"Message": "Missing Authorization header for a privileged call on connection.",
"Source": "product policy"
}
