Announcements
Dear All,
I want to create a get items query which filters all items / dates which are equal to today between two dates, start date and end date. The data is stored in a sharepoint list.
Any help with this would be appreciated.
Kind Regards
Daniel
Hey @DLCaterhamSch
Can you provide more details about your query? Can you give two examples how your cases would work.
Mostly I use get items filter when there is just 1 filter. You can also use filter array action.
Giving you more links for the above:
https://www.spguides.com/power-automate-multiple-conditions/
https://www.youtube.com/watch?v=I8FdUmECAn8
https://www.youtube.com/watch?v=V1ThALavvf0
I hope this helps 🙂
Hi @DLCaterhamSch ,
I did a test for your reference.
In my scenario:
utcNow('yyyy-MM-dd')
My SP List:
Best Regards,
Sunshine Gu
Thank you for the above so I have two columns in the sharepoint list Start Date Column and End Date column. Would this work with this?
Please check this example:
So where did you get startdate from in the filter part in get items?
I got the dynamic content of the start date and end date from the first 'Get item' control, because the control cannot get the dynamic content of itself, so I created two 'Get items' controls.
Sorry this still doesn't make sense to me?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 423
11manish 308 Super User 2026 Season 2
M Bilal Khan 177
