cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HemanthV
Frequent Visitor

Filter Query is not Working as expected

Hi Guys,

I have an issue with the flow.

I have created a simple flow with the below steps

HemanthV_0-1639583759176.png

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

HemanthV_1-1639583910104.png

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

Sharepoint

HemanthV_2-1639584028510.png

Flow

HemanthV_3-1639585758426.png

I am unable to figure out the issue.

 

Please help me on this!

Thanks in advance!

 

2 REPLIES 2
fchopo
Super User
Super User

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

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Hi @fchopo ,

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

HemanthV_0-1639649872972.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,061)