Filter Query is not Working as expected

[HemanthV]

Hi Guys,

I have an issue with the flow.

I have created a simple flow with the below steps

in Get items step I have used one condition Reporting week = 29th nov 2021, please see below screenshot

I have 17 records in the sharepoint with this date But get items is pulling only 3 records

Sharepoint

Flow

I am unable to figure out the issue.

Please help me on this!

Thanks in advance!

[fchopo]

Please, specify the date value in ISO 8601 format: yyyy-MM-dd that should be 2021-11-29.

Hope it helps!

Ferran

[HemanthV]

Hi @fchopo ,

Tried the format you specified but still getting 3 rows instead of 17