Announcements
I am attempting to use Get items in a Flow where the Created dates fall between 7/1/22 nd 12/31/22. What syntax do I need to use in the Filter Query?
Should work.
I've tested it locally and following query returns all items created today
Hi @RJF61 ,
For Created dates that fall between 7/1/22 and 12/31/22, I would use the query using a Date formatted as ISO 8601 (starting with the year, followed by the month, the day).
Created ge '2022-07-01' and Created lt '2023-01-01'
This will filter for Created items between '2022-07-01 00:00:00' (i.e. midnight on 2022-07-01) and '2022-12-31 23:59:59' (the year, followed by the month, the day, the hour, the minutes, seconds)
See: Solved: Re: Comparing MS Forms responses dates with utcnow - Power Platform Community (microsoft.com)
Ellis
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 389
Vish WR 331
David_MA 298 Super User 2026 Season 1
