HI @GaganMehrok,
Could you please show a bit more about the Task_due_date column in your SQL table?
Could you please show a full screenshot of your flow's configuration?
I have created a SQL table on my side with following code:
Create table dbo.TaskLists1(
TaskId int not null identity(1,1),
Task_due_date datetime not null,
Task_current_state varchar(20) not null,
Creator varchar(25) not null
)
The Task_due_date column is a datetime type column, the data structure of my SQL table as below:
I think there is something wrong with the OData query that you provided within Filter Query field of "Get rows" action. When working with date value using OData query within Filter Query field of "Get rows" action, we should get year, month and day separately, please take a try with the following article as a reference:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests
I have made a test on my side and please take a try with the following workaround:
Within Filter Query field, type the following formula:
year(Task_due_date) le utcNow(...)​ and month(Task_due_date) le utcNow(...) and day(Task_due_date) lt utcNow(...)​ and Task_current_state eq 'Build' or Task_current_state eq 'Peer Review'
The first utcNow() expression read as:
utcNow('yyyy')
The second utcNow() expression read as:
utcNow('MM')
The third utcNow() expression read as:
utcNow('dd')
The flow works successfully as below:
Please check and see if the following article would help you in understanding the above solution that I provided:
https://powerusers.microsoft.com/t5/General-Flow-Discussion/Filter-SQL-Date-field/m-p/59778/highlight/true#M9022
Best regards,
Kris
