Announcements
I would like to get all rows in my SharePoint List where the date is the latest / maximum date in the list. There will be more than 1 result as there are multiple items for each date in my list. How should I go about doing this in Get items step?
@acs1 , Try this
@SudeepGhatakNZ do you mean to leave 'Filter Query' blank and do a sort instead? I tried it but it didn't work, as it resulted in the same number of rows as my original list.Just to further clarify using below illustration as an example, I would like to "get" only the rows in yellow since those 2 rows have the latest dates.
Sorry, I misunderstood your question. You do infact need to use the filter.
Try something like this:
1) Get the maximum date by getting the first item in your Get items action output
2) Next use filter to get dates that match that value.
Thanks, it worked!
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 283
David_MA 256 Super User 2026 Season 1
Expiscornovus 225 Most Valuable Professional
