cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

Compare Datetime error for Get Rows Filter

I am using a SQL Get Rows action that connects to an on premise SQL instance.

 

I have the filter set up like this:

filterQuery_datetime_compare.PNG

 

This results in the error:

flow_datetime_comparision_query.PNG

 

 

Any idea on why i am getting this error and what the best way to compare datetime is?

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Compare Datetime error for Get Rows Filter

Hi @jonathanO,

 

Could you please explain a bit for the Odata Query formula, why adding the minutes () function after the day function?

I tested it from my side (on premise SQL Server) and it works:

44.PNG

 

Would you please try it again?

 

Further, if the issue insists, please post the running detail URL, which should contain the FLow and the Runs GUID.

For example:

https://asia.flow.microsoft.com/manage/environments/Default-9e51064f-f6a5-41a2-89a9-9785a9d6c706/

flows/77c37940-4734-4c8f-9XXXX66b734/

runs/085869252612XXXX47256941063

?backUrl=%2Fflows%2F77c37940-4734-4c8f-97cb-e872b366b734%2Fdetails&runStatus=Succeeded

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: Compare Datetime error for Get Rows Filter

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (8,240)