I'm querying a SQL Server through Power Automate, however it's on premises and therefore the 'execute query' isn't viable, and neither is 'execute stored procedure' due to contractual restraints on the use of the server.
I'm using 'Get Rows' with an ODATA filter query to limit the records output. I need to filter by a datetime value where both the date and time components are relevant. However, when I attempt a direct comparison between the output from my SQL Server and a datetime value in power automate, I only get an empty array.
EG: End_Time lt 2025-06-20T09:21:00.000Z
I've formatted the datetime value in countless different ways, but none work.
I've been able to use the date(), time(), minute(), and hour() wrappers in my filter query to work around this limitation, but it extends the duration of the flow substantially as it completes several row by row checks.
date(End_Time) eq date(@{outputs('timestamp')})
and hour(End_Time) eq hour(@{outputs('timestamp')})
and minute(End_Time) eq minute(@{outputs('timestamp')})
Is there a way to directly filter by DateTime values in the SQL Server connectors 'Get Rows' action?
