Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Pages
    • Take a guided tour
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find partner offers
    • Partner GTM Resources
    • Blog
    • Customer stories
    • Developer Plan
    • Documentation
    • For IT Leaders
    • Roadmap
    • Self-paced learning
    • Webinars
    • App development topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power Apps Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Connector Development
    • Power Query
    • GCC, GCCH, DoD - Federal App Makers (FAM)
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog
    • Power Apps Community Blog
    • Galleries
    • Community Connections & How-To Videos
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Emergency Response Gallery
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community Calls Conversations
    • Experimental
    • Error Handling
    • Power Apps Experimental Features
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Community App Samples
    • PowerApps Calendar

    PowerApps Calendar

    06-17-2022 17:01 PM - last edited 07-16-2022 07:40 AM

    Super User TheRobRush
    Super User
    1295 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    TheRobRush
    Super User TheRobRush
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    PowerApps Calendar

    ‎06-17-2022 05:01 PM

    This Calendar has been created to use a single control as it's body, feel free to use this in your own apps.

     

    CalExample.png

     

    It also automatically highlights Holidays on your calendar, using a formula in the fill to compare against a self generated list of the holidays for selected year (formulas for xth weekday day of each month created with American federal holidays, may need to adjust regionally)

     

    You can also select a day day by clicking on it to highlight it blue, click it again to unselect it, and a control outside the calendar will display the selected day.

     

    Control in top right will calculate if selected year is a leap year. 

     

    Hidden controls on left of screen will calculate working days (-weekends - holidays) between two dates, both counting and excluding first day

     

    Calendars have been something I have been experimenting with for a very long time and wanted to share with others what I have working so far.

    _____________________________________________________________________________________
    Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
    This helps others find solutions to future issues!
    SingleControlCalendar_20220617235522 (1).zip
    Labels:
    • Labels:
    • Formulas and Controls
    • Galleries and Forms
    • Offline App Design
    Message 1 of 5
    1,295 Views
    3 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    R3dKap
    R3dKap Community Champion
    Community Champion
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-13-2022 10:02 AM

    Hi @TheRobRush,

    Would you mind adding a capture of your calendar components to your post so we can see how it looks when we view your post?

    Thanks 😉

    Message 2 of 5
    1,166 Views
    0 Kudos
    Reply
    TheRobRush
    Super User TheRobRush
    Super User
    In response to R3dKap
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-16-2022 07:40 AM

    Sure 🙂

    _____________________________________________________________________________________
    Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
    This helps others find solutions to future issues!
    Message 3 of 5
    1,136 Views
    0 Kudos
    Reply
    hsfournier
    hsfournier Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-12-2023 12:26 PM

    Is it possible to set this calendar to just show Monday to Friday, and exclude Saturday and Sunday altogether? 

    Message 4 of 5
    440 Views
    0 Kudos
    Reply
    TheRobRush
    Super User TheRobRush
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-12-2023 02:23 PM

    Yah you'd just need to set visibility of the controls to be false on saturdays and sundays. Then remove them from the header gallery

    _____________________________________________________________________________________
    Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
    This helps others find solutions to future issues!
    Message 5 of 5
    433 Views
    0 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    Browse

    • Sample apps
    • Services

    Downloads

    • Windows
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2023 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices