web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Just select month and ...

Power Apps - Building Power Apps

Answered

Just select month and year in powerapps date

Like (0) Share

Report

Report

Posted on 31 Aug 2021 20:24:15 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:

Using Apps Using Formulas

Employee Ideas app on Teams

General Questions

Connecting to Data

I have the same question (0)

All responses Img

All responses (9)

Answers Img

Answers (1)

Verified answer

Mitanshu 1,635 Moderator on 31 Aug 2021 at 20:33:16

Like (9)

Report

Re: Just select month and year in powerapps date

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 31 Aug 2021 at 20:37:27

Like (0)

Report

Re: Just select month and year in powerapps date

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,635 Moderator on 31 Aug 2021 at 20:40:42

Like (3)

Report
Re: Just select month and year in powerapps date

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 31 Aug 2021 at 20:42:21

Like (0)

Report

Re: Just select month and year in powerapps date

@happyume

I understand now! Thanks

Was this reply helpful? Yes No
rybnzdev 31 on 26 Jul 2022 at 05:24:34

Like (0)

Report

Re: Just select month and year in powerapps date

Thank you! This worked perfectly

Was this reply helpful? Yes No
EmiliaLI 7 on 10 May 2023 at 05:20:42

Like (2)

Report

Re: Just select month and year in powerapps date

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 21 Aug 2023 at 08:12:25

Like (0)

Report

Re: Just select month and year in powerapps date

if I want start from 2019 what solution

Was this reply helpful? Yes No
agorkemt 73 on 15 Feb 2024 at 09:05:14

Like (0)

Report

Re: Just select month and year in powerapps date

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 15 Feb 2024 at 09:07:13

Like (1)

Report

Re: Just select month and year in powerapps date

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

Join the conversation