Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Portals
  • 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
    • 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
    • Business Value Webinars and Video Gallery
    • Emergency Response Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Ideas
    • Power Apps Ideas
    • Community Engagement
    • Demo Extravaganza 2021
    • Demo Extravaganza - Components 2021
    • Power Apps Community Demo Extravaganza 2020
    • 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
    • Global Holiday Visual Calendar

    Global Holiday Visual Calendar

    10-28-2021 16:58 PM

    Super User JR-BejeweledOne
    Super User
    578 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    JR-BejeweledOne
    Super User JR-BejeweledOne
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Global Holiday Visual Calendar

    ‎10-28-2021 04:58 PM

                 VisualCalendarImage.jpg

     

    This visual calendar began as a project to replace a a list of Holidays.   The list didn't offer a calendar style view with highlighting.  There was no ability to compare holidays in different places.

     

    We needed something different.  

     

    Thanks to a video on creating a calendar from galleries by Shane Young, @Shanescows, (can be seen here:  https://youtu.be/SlfnhQgMXrY) I was able to create this fantastic visual calendar.

     

    This Calendar features:

     

    • A full year calendar style view with highlighted days
    • A 'by month' calendar style view with highlighted days
    • A comparison view where calendars for up to 4 locations can be compared in a list format OR a calendar format (by month) with highlighted days
    • Tooltips that show the Holiday name or for calendars where all 'regions' in a country are grouped, it displays the location for each highlighted day.
    • Date functions translate based on browser language including date format (I.E. dd/mm/yyyy or mm/dd/yyyy).
    • Dynamic display of the Holidays for the current user by auto populating the country and region fields using the O365Users connector and the country and city properties and looking up the holidays with matching information.

     

    Some of the functions used in this app are:

     

    • Gallery wrap count
    • Sequence
    • A variety of date functions

    This is a fantastic and neat way to use galleries!

     

    You can download the app and the SharePoint list template below.

     

     

     

     

    watch?v=NKNCsq3iF8I



    If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
    HolidaysList.zip
    VisualHolidayCalendar_20211028225646.zip
    Labels:
    • Labels:
    • Galleries and Forms
    Message 1 of 2
    578 Views
    2 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    Shanescows
    Shanescows
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎10-29-2021 06:31 AM

    Looking good!

    Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
    Message 2 of 2
    519 Views
    0 Kudos
    Reply

    Power Platform

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

    Power Apps

    • Sign in
    • Sign up

    Browse

    • Sample apps
    • Services

    Downloads

    • Studio
    • iOS
    • Android

    Learn

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

    • © 2022 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks