Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 339 Super User 2025 Season 2
David_MA 270 Super User 2025 Season 2