Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 41kOU2AhBIJS5H1CDIPsaR
Power Apps - Building Power Apps
Answered

Just select month and year in powerapps date

Like (0) ShareShare
ReportReport
Posted on 31 Aug 2021 20:24:15 by

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

  • agorkemt Profile Picture
    71 on 15 Feb 2024 at 09:07:13
    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! 

  • agorkemt Profile Picture
    71 on 15 Feb 2024 at 09:05:14
    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.

  • butterfly1 Profile Picture
    3 on 21 Aug 2023 at 08:12:25
    Re: Just select month and year in powerapps date

    if I want start from 2019 what solution

  • EmiliaLI Profile Picture
    7 on 10 May 2023 at 05:20:42
    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.

  • rybnzdev Profile Picture
    31 on 26 Jul 2022 at 05:24:34
    Re: Just select month and year in powerapps date

    Thank you!  This worked perfectly

  • Gorilla_8 Profile Picture
    on 31 Aug 2021 at 20:42:21
    Re: Just select month and year in powerapps date

    @happyume 

     

    I understand now! Thanks

  • Mitanshu Profile Picture
    1,614 Super User 2025 Season 1 on 31 Aug 2021 at 20:40:42
    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.

  • Gorilla_8 Profile Picture
    on 31 Aug 2021 at 20:37:27
    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!

  • Verified answer
    Mitanshu Profile Picture
    1,614 Super User 2025 Season 1 on 31 Aug 2021 at 20:33:16
    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.

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,083 Most Valuable Professional

Leaderboard
Loading started