Just select month and year in powerapps date

(0) Share

Report

Posted on by Gorilla_8

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

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Mitanshu 1,650 Moderator on at

Like (9)

Report

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

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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (3)

Report
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.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

@happyume

I understand now! Thanks

Was this reply helpful? Yes No
rybnzdev 31 on at

Like (0)

Report

Thank you! This worked perfectly

Was this reply helpful? Yes No
EmiliaLI 7 on at

Like (2)

Report

This is very useful and just met my request, but I'm still confused where to enter the formula.

Was this reply helpful? Yes No
butterfly1 3 on at

Like (0)

Report

if I want start from 2019 what solution

Was this reply helpful? Yes No
agorkemt 73 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
agorkemt 73 on at

Like (1)

Report

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!

Was this reply helpful? Yes No