Is there any way to block PowerApps so it doesn't select days, just month and year?
Or if there is another solution for the user to just select month and year
thanks for the formula but where i should enter the formula? Can you explain it a little more specific please?
Edit: nevermind i found this video sur youtube and it is very simple indeed "https://www.youtube.com/watch?v=WthVOujDpZo"
just go to the proporties, select format and change the format to "mm-yyyy" and voila!
I think; if you select the date picker, on the right hand side there will be a menu indicating "properties" and "advanced". Click on the "advanced" and there, if you scroll down a bit, you should see the "endyear" and "startyear". so you can change it from there.
if I want start from 2019 what solution
This is very useful and just met my request, but I'm still confused where to enter the formula.
Thank you! This worked perfectly
Year(DatePicker1.SelectedDate)&"-"&Month(DatePicker1.SelectedDate)
This is meant to be used as an output to whatever user selects as the date from the DatePicker.
So, your user might be picking any date in October, you are still storing 2021-10 in your datasource, or using 2021-10 in your App.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.
Hey @happyume
In this part:
"From the DatePicker control, if you use Year(DatePicker1.SelectedDate)&"-"&Month(DatePicker1.SelectedDate), that will give you year and month."
Did you mean to put this on "DefaultDate" on DatePicker?
Thanks for the solution with dropdown, I didn't think in that one! Thanks!
From the DatePicker control, if you use Year(DatePicker1.SelectedDate)&"-"&Month(DatePicker1.SelectedDate), that will give you year and month.
I suppose you are looking more from a UI perspective - correct?
Alternatively, you can have two dropdowns, one for month another for year
Month: Calendar.MonthsLong()
Year: Sequence(50,Year(Today())) - this will give next 50 years starting from current one
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,083
Most Valuable Professional