Announcements
Hello,
I am a new Power Apps user. I would like to know how to get first (and last) date from the filtered gallery.
Thank you very much!
@MarioMilicic
To get the first (earliest) date, you can use this:
First( Sort(YourGallery.AllItems, YourDateField, Descending ) )
To get the last date, you can use this:
First( Sort(YourGallery.AllItems, YourDateField, Ascending ) )
Hi @timl ,
I can get the first item like this -> First(Gallery.AllItems).'datepicker_name'
But I can not apply sort on that 😕
Some hint please?
Thanks,
Mario
I got the result, it is like this:
First(Sort(Gallery_Name.AllItems,'datepicker_name'.SelectedDate, Ascending ) ).'datepicker_name'
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.
11manish 411 Super User 2026 Season 2
Mohsin Ali 338
WarrenBelz 256 Most Valuable Professional
