I have a one flow that adds rows to a table based on an external input, and also inputs the date it was added.
I have another flow that analyzes inputs of the table and classifies them based on an AI model.
As previous entries have already been classified, I want to input a date filter, for it to only run the model on items added yesterday.
I've tried multiple solutions:
- Format the Date in Excel as ISO (yyyy-MM-ddTHH:mm:ssZ) and in the filter greaterOrEquals(item()?[Time Added by the flow], addDays(utcNow(),-1)
- Used formatDateTime on both sides
- Covert the Dates in Excel as 'yyyy-MM-dd' and Initialize a variable "Yesterday" - formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd'), and use the filter on that variable
Every single option the output is blank.
How do I set this filter?