Announcements
Hello,
i want to show date in gallery - for this i want to create a datepicker and select the first day of this month and an datepicker with the last day of this month selected.
Thanks a lot for your help.
There are some nice examples here:
http://powerappsguide.com/blog/post/example-date-functions-relative-to-now
Hi @pleibling ,this will probably help you. You can simply download the component and paste it into your PowerApps. This is a DatePicker with several options.
https://www.youtube.com/watch?v=pl1YoItT1VM
Write this in Datepicker1 DefaultDate Property:
Date(Year(Now()), Month(Now()), 1)
Write this in Datepicker2 DefaultDate Property:
DateAdd(DateAdd(Date(Year(Now()),Month(Now()),1),1,Months),-1,Days)
Thanks for your help, but i want to try it first with built in options. Thanks.
Many thanks for your fast reply - i try this, but it doesn't work. I add an Datepicker called Datepicker1 and at DefaultDate i insert: Date(Year(Now()), Month(Now()), 1)
But it show me an error. If i try it own and wrote today(), this works and it show this possibility with autocompletion - if i wrote date( there show no autocompletion. I try to inser date(1974,12,10) but gets to an error.
Whats the error? Did i have to set something other?
Looks like this:
This works for me:
DatePicker1 (From):
Date(Year(Now()); Month(Now()); 1)
DatePicker2 (To, Today default):
Today()
Get Items in Gallery until this Time:
Filter('DataSource';(Date_column_in_datasource >= DatePicker1.SelectedDate) && (Date_column_in_datasource <= DatePicker2.SelectedDate))
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 396 Super User 2026 Season 2
Mohsin Ali 323
WarrenBelz 193 Most Valuable Professional
