Delivering a Consolidated Snapshot from Multiple SharePoint calendars

Anatomy of the Company Happenings Power App

Anatomy of the Company Happenings Power App

Site Architecture Snapshot

My intranet’s calendars are each on their own site.  All sites are Modern Communication sites.  The News & Events site is my Intranet’s “Home” and it is a Hub Site for my other communication Sites.  I’ve renamed each of my site’s events calendars to reflect their purpose, rather than having 3 calendars all titled “Events”.

The data source options between SharePoint and PowerApps is flexible.  You could have multiple calendars residing within one site, or many different sites with many different calendars.

Anatomy of the Company Happenings Power App

Company Events SharePoint Calendar Consolidation Power App

Happenings App Home Screen
Home Screen

The Next 7 Days

  • Shows only next 7-days’ items
  • Color-coded section for each of the calendars.
  • > View detail screen for that Calendar
  • Each Calendar’s list scrolls individually when there are more items to see
  • <star> notes important items tagged by contributor in custom “highlight” column
  • All lists in chronological order.
  • Next 7 Days – Data shown:
    • Calendar (Primary Category)
    • Weekday of Event
    • Event Title
    • Highlight
    • Filtered to show:
      • Start date is less than 7-days from now
      • End date/time has not passed

All Important Events

  • Only pulls from Events calendar
  • Shows ALL items tagged for highlight, no matter how far in the future they are.
  • All Upcoming Events – Data Shown:
    • Events calendar items only
    • Date/Time of start
    • Filtered to show:
      • End date/time has not passed
      • Flagged “Highlight” in “Highlight Indicator” field
Ad

Detail Screen For Each Calendar

  • < Return to app Home screen
  • Refresh data
  • Items’ Start date & End date are shown vertically at start/end of item listing
  • <star> notes important items tagged by contributor in custom “Highlight Indicator” column
  • Scroll to see all of the event’s “body” text
  • Bottom row for each event includes:
    • Location
    • Category
  • Click on “More” to open event’s SharePoint page in the full window.
    • Legacy detail page
  • Background picture is event page’s Header image when one is input by the contributor.  Otherwise blank.
  • Filtered to show:
      • Start date is less than 7-days from now
      • End date/time has not passed
      • Exception for Important Events, shows all future events tagged as important.

 

How useful was this information?

Click on a star to rate it

We are sorry that this post was not useful for you!

Let us improve this post!